This content has been marked as final. Show 5 replies
Take a Data export of cube "A" it will generate a file(csv ,txt etc) then create rule file for cube "B"(for example) and ignore the three dimension which are not in cube "B".
Avneet Singh Bhatia
Avneet gave you the beginnings of one way, but left out that a couple of things. First, you would want to do the export of level zero only. Second, the export needs to be in column format and third, you need to make sure the load rule you use is set to be additive otherwise the last row will overwrite the previouse values.
A couple of other wats I can think of doing this
Create a replicated partition that maps the 3 non used dimensiosn to null (Pick the member at the top of the dimension in your mapping area)
Create a report script to extract the data putting the three dimensions in the page so they don't show up.
Use the custom defined function jexport in a calc script to get what you want
911357 wrote:1. Create new Cube "B" is same as Cube "A"
we have a cube "A" of 13 dimenions with FY12 data. Now we got a requirement to create new cube same as cube A but with 10 dimensions (excluding 3 dimensions). And we need to load the data from the cube "A".
2. Export level0 data from Cube "A" and Load it into Cube "B"
3. Now Remove the 3 dimensions from Cube "B" and do the restructure
Now export the level0 data from Cube "B" which doesn't have the data for deleted 3 dimensions.
I hope this is the correct procedure..Any one correct me if m wrong..