Forum Discussion

RandyThompson's avatar
RandyThompson
New Contributor III
3 years ago

Move data between mutually exclusive cubes (not linked) with different extensibility

I need to move data between two mutually exclusive cubes. Cube1 (FinPlan) U3 dimension base level is ProductType, Cube2(SalesFcst) UD3 base level is SKU which rollup up to ProductType. SKU also has a...
Extensibility
  • chul's avatar
    chul
    3 years ago

    On your second approach, create a DM Export Sequence Data Source. Since you're creating a transformation rule for accounts, create one for your UD3 (you can use Excel to bring in the text6 value and upload the trx). The other dimensions would use your PassThru rules.

    Not clear if this is a one-time exercise or you're moving data as an ongoing process.

TonyToniTone's avatar
TonyToniTone
Contributor II
3 years ago

2nd approach is your option here.  To answer your 1st question, yes, you can have mutually exclusive Cubes with different Account Dimensions and use the ConvertDataBufferExtendedMembers.  You would need Cube 1 to use FinAccounts and Cube 2 to use FinDetAccounts.  Because FinDetAccounts extends from FinAccounts, the ConvertDataBufferExtendedMembers is a viable option.  In this case, Cube 1 and Cube 2 have no Cube References assigned so they are not linked.