How to merge Two Cubes into ONE Cube?

[itbl]

Hi all,

I need some helpful tips how merge two cubes into one cube.
Currently I'm into a project where we meet the following problems:

Scenario:
I have a dbase file - pdtd.dbf (2G Size).
Since dbase have a limitation - the size cannot exceed 2G.
So, we divided it into 2 files - one is 1.5G (A.dbf), another is 0.5G(B.dbf).
B.dbf will go on adding transactions in it.

Method 1:
A.dbf is generated into a Cube (A.mdc) and B.dbf is generated into another Cube (B.mdc).
How can I merge them into One Cube (Production.mdc)?

Method 2:
I insert them into a Powerplay Transformer.
So, It has 2 query - A Query(A.dbf) and B Query(B.dbf) in a Transformer and generated into a Cube.
But I found out the value of A Query are incorrect, but the value of B Query are correct.
Why? What should I do?

This is urgent! Thanks a lot.

Regards,
Brian

 

[Guest_imported]

It seems it is impossible I think.

 

[Guest_imported]

Let me think ...
or you can ...

 

[goldsmt]

Use a multi query model.

First query based on 1.5 database structured as

Date Product Quantity1 Value1

second query based on .5 Gb dadabase structured as

Date Product Quantity2 Value2

Note the descriptions are the same but the values (measures) are labled differently.

In transformer create a calculated measure called quantity whose calculation is quantity1 + quantity2. Do the same for all other measures.

In the cube proberties select quantity1 and quantity2 and hide them. The user now sees only one quantity, the sum of both database sources. It is important that the 2 queries lables match so the dimensions scope against each other.

I use this method often so I know it works

Reagrds

Tony Goldsmith

 

[itbl]

Thanks a lot!