Hi,

I need some advice for merging 2 cubes into 1 cube.
Because now 1 cube is from 1 table. So, can I do the
merge cubes?

Thank you so much.

Kit

you can't merge 2 cubes

but you can create a virtual cube. a virtual cube combine 1 or more cubes
if your cubes used the same shared dimensions, then you can analyse your
measures from your 2 cubes using these shared dimension without problem.

"Kit" <anonymous (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:
8dad01c4d204$002feee0$a601280a (AT) phx (DOT) gbl...

Thank you for your suggestion, Mr.Jeje.

Now, I have 2 tables that are Stock Balance and Stock
Transaction.

The structure for Stock Balance consists of
Warehouse_Code + StockBalance_Date + Product_Code and
Balance_Qty, In_Qty, Out_Qty, Total_Qty.

And Stock Transaction is Place_Code + StockTrn_Date +
Document_Code + Product_Code and Qty.

They have been made to be 2 cubes. I did the virtual
cube to combine both cubes.

Currently, when I drag a dimension of StockBalance_Date,
the figures in Qty (Stock Transaction) do not appear. On
the contrary, StockTransaction_Date is dragged, the
figures in Balance_Qty, In_Qty, Out_Qty, Totay_Qty do not
show too.

So, How can I show all figures, when select either
StockBalance_Date or StockTransaction_Date?

Thank you again.

Kit

its because you have 2 differents dimensions
you have 2 choices:
* use only 1 dates dimension
* use calculated measures and the LinkMember MDX function to retrieve the
same date of the second date dimension (then hide this second dimension to
the user)

Search with google in the newsgroup to know how to use linkmember
but I think a calculated member like this can help you:

(measures.Balance_Qty, linkmember(StockBalance_Date.currentmember,
[StockTrn_Date]))

"Kit" <anonymous (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:
926d01c4d2c4$049f53b0$a601280a (AT) phx (DOT) gbl...
Thank you for your suggestion, Mr.Jeje.

Now, I have 2 tables that are Stock Balance and Stock
Transaction.

The structure for Stock Balance consists of
Warehouse_Code + StockBalance_Date + Product_Code and
Balance_Qty, In_Qty, Out_Qty, Total_Qty.

And Stock Transaction is Place_Code + StockTrn_Date +
Document_Code + Product_Code and Qty.

They have been made to be 2 cubes. I did the virtual
cube to combine both cubes.

Currently, when I drag a dimension of StockBalance_Date,
the figures in Qty (Stock Transaction) do not appear. On
the contrary, StockTransaction_Date is dragged, the
figures in Balance_Qty, In_Qty, Out_Qty, Totay_Qty do not
show too.

So, How can I show all figures, when select either
StockBalance_Date or StockTransaction_Date?

Thank you again.

Kit