unprocessing database, virtual cubes/datasources 
Author Message
 unprocessing database, virtual cubes/datasources

HI,

- Is there a way of "unprocessing" a database and/or a
cube to save space, others than copying it to another
name ?

- Is it possible to prevent a specific cube in a database
from being processed when i process the database ? (a kind
of passive flag)

- I can't find a way to create a virtual cube that joins
cube INVOICED (dim: customer, product, time,
facttable "invoiced") with a planned cube ACCOUNTS (dim:
account, time, facttable "accounts") over dimension time,
where INVOICED and ACCOUNTS will be linked to different
data sources (different sql server databases). The time
dimension table is identical in both databases. Must i
really copy the account dimension table and account fact
table to the Invoiced database, and use only one data
source ?

/Sverker



Mon, 05 Jul 2004 23:21:27 GMT
 unprocessing database, virtual cubes/datasources

Quote:

> HI,

> - Is there a way of "unprocessing" a database and/or a
> cube to save space, others than copying it to another
> name ?

Per cube, set its WHERE clause to the expression (1 = 0) and reprocess.
No rows of data.

Quote:

> - Is it possible to prevent a specific cube in a database
> from being processed when i process the database ? (a kind
> of passive flag)

No.

Quote:

> - I can't find a way to create a virtual cube that joins
> cube INVOICED (dim: customer, product, time,
> facttable "invoiced") with a planned cube ACCOUNTS (dim:
> account, time, facttable "accounts") over dimension time,
> where INVOICED and ACCOUNTS will be linked to different
> data sources (different sql server databases). The time
> dimension table is identical in both databases. Must i
> really copy the account dimension table and account fact
> table to the Invoiced database, and use only one data
> source ?

You can always use linked servers if they are on different servers, or
use a view in the Invoiced database that performs something similar to:

SELECT * from Accounts.dbo.account_fact_table

You must use one data source to make the virtual cube work seamlessly,
but it need not be difficult. (Refer to the techniques in chapter 11 of
MDX Solutions if there is just no way to make one data source work.)

Quote:

> /Sverker

HTH

--
George Spofford
Microsoft MVP
Chief Architect / OLAP Solution Provider
DSS Lab

ISVs & IT organizations: Find out how DSS Lab can speed your
development!



Mon, 05 Jul 2004 22:44:44 GMT
 unprocessing database, virtual cubes/datasources
Did I get this right ?

1. Use 2 views to get the accounts dimension table and
accounts fact table appear in the invoice data source.

or

2. Make an account dim and time2 dim and an account cube
with the account data source and create a virtual cube
using "multiple versions of the same dimension" described
in MDX solutions.

The account cube actually exist on the same server. If it
was on another server, could I link it to my database and
then use the "multipel versions..." ? (why can't I link
cubes on the same server...)

PS ! I've just implemented the "Time analysis Utility
dimension" and it works great.

/Sverker

Quote:
>-----Original Message-----


>> HI,

>> - Is there a way of "unprocessing" a database and/or a
>> cube to save space, others than copying it to another
>> name ?

>Per cube, set its WHERE clause to the expression (1 = 0)
and reprocess.
>No rows of data.

>> - Is it possible to prevent a specific cube in a
database
>> from being processed when i process the database ? (a
kind
>> of passive flag)

>No.

>> - I can't find a way to create a virtual cube that joins
>> cube INVOICED (dim: customer, product, time,
>> facttable "invoiced") with a planned cube ACCOUNTS (dim:
>> account, time, facttable "accounts") over dimension
time,
>> where INVOICED and ACCOUNTS will be linked to different
>> data sources (different sql server databases). The time
>> dimension table is identical in both databases. Must i
>> really copy the account dimension table and account fact
>> table to the Invoiced database, and use only one data
>> source ?

>You can always use linked servers if they are on

different servers, or
Quote:
>use a view in the Invoiced database that performs

something similar to:

- Show quoted text -

Quote:

>SELECT * from Accounts.dbo.account_fact_table

>You must use one data source to make the virtual cube
work seamlessly,
>but it need not be difficult. (Refer to the techniques in
chapter 11 of
>MDX Solutions if there is just no way to make one data
source work.)

>> /Sverker

>HTH

>--
>George Spofford
>Microsoft MVP
>Chief Architect / OLAP Solution Provider
>DSS Lab

>ISVs & IT organizations: Find out how DSS Lab can speed
your
>development!

>.



Tue, 06 Jul 2004 21:16:01 GMT
 unprocessing database, virtual cubes/datasources
Yes, those are the options, and I think #1 is the way to go unless for
some reason you can't do it. Case #2 is really more appropriate when
you've got linked cubes (i.e. no access to the source tables). The views
are trivial to get right, since the databases are on the same server.

Quote:

> Did I get this right ?

> 1. Use 2 views to get the accounts dimension table and
> accounts fact table appear in the invoice data source.

> or

> 2. Make an account dim and time2 dim and an account cube
> with the account data source and create a virtual cube
> using "multiple versions of the same dimension" described
> in MDX solutions.

> The account cube actually exist on the same server. If it
> was on another server, could I link it to my database and
> then use the "multipel versions..." ? (why can't I link
> cubes on the same server...)

> PS ! I've just implemented the "Time analysis Utility
> dimension" and it works great.

> /Sverker

> >-----Original Message-----


> >> HI,

> >> - Is there a way of "unprocessing" a database and/or a
> >> cube to save space, others than copying it to another
> >> name ?

> >Per cube, set its WHERE clause to the expression (1 = 0)
> and reprocess.
> >No rows of data.

> >> - Is it possible to prevent a specific cube in a
> database
> >> from being processed when i process the database ? (a
> kind
> >> of passive flag)

> >No.

> >> - I can't find a way to create a virtual cube that joins
> >> cube INVOICED (dim: customer, product, time,
> >> facttable "invoiced") with a planned cube ACCOUNTS (dim:
> >> account, time, facttable "accounts") over dimension
> time,
> >> where INVOICED and ACCOUNTS will be linked to different
> >> data sources (different sql server databases). The time
> >> dimension table is identical in both databases. Must i
> >> really copy the account dimension table and account fact
> >> table to the Invoiced database, and use only one data
> >> source ?

> >You can always use linked servers if they are on
> different servers, or
> >use a view in the Invoiced database that performs
> something similar to:

> >SELECT * from Accounts.dbo.account_fact_table

> >You must use one data source to make the virtual cube
> work seamlessly,
> >but it need not be difficult. (Refer to the techniques in
> chapter 11 of
> >MDX Solutions if there is just no way to make one data
> source work.)

> >> /Sverker

> >HTH

> >--
> >George Spofford
> >Microsoft MVP
> >Chief Architect / OLAP Solution Provider
> >DSS Lab

> >ISVs & IT organizations: Find out how DSS Lab can speed
> your
> >development!

> >.

--
George Spofford
Microsoft MVP
Chief Architect / OLAP Solution Provider
DSS Lab

ISVs & IT organizations: Find out how DSS Lab can speed your
development!


Wed, 07 Jul 2004 00:21:53 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Can you build Virtual Cube from various datasources?

2. virtual cube from virtual cube

3. Virtual cube on cube in another database

4. Local cubes from virtual cubes

5. create local cube from a virtual cube

6. add-in to archive / backup individual cubes and virtual cubes

7. virtual cube joining cubes with different datasource

8. Creating A Virtual Cube Over Two Other Cubes

9. Virtual cube of actual and budget cubes

10. Local cubes from virtual cubes

11. Creating a Virtual Cube based on a slice of another cube

12. virtual cube based on a single cube


 
Powered by phpBB® Forum Software