ViewCreate with keeping consolidation for data transfer

[lav4you]

Hi All,

I have an interesting situation,
I want to transfer data between two cubes, Cube A and Cabe B.
Cube A has 8 dimensions and cube B has 10 dimension.
One twist here is Cube A(Source cube) has a dimension name Regions with Hierarchy of
Countries > City

Cube B has a Region_Consol dimension with only Countries.
Now I want transfer data between Cube A to Cube B with TI.

I am creating a temporary view using VIEWCREATE function. as this function by default has zero and consolidation suppressed. so this will not transfer data.
If I use ViewExtractSkipCalcsSet(Cube,ViewName,0) then consolidation from all dimensions get active and though data transfer is correct I will get an error message.

A simple way to avoid this is to create a temporary subset for all dimensions and assign to this Sourceview.

I feel its a bit lengthy code. Is there any other simple way to assign only particular dimnsion with consolidtion and rest with suppression on
looking for some shortcut from TM1 gurus ..

Regards,
Lav

[Wim Gielis]

Hello

What error messsage do you see?

- You should use an MDX expression to have all level 0 elements for the 9 dimensions.
- And also an MDX expression to have all level 1 elements for that other dimension (Regions).

Then, as you did, do not skip the consolidated members.
AFAIK, there is no shorter method (unless you want to create a view manually and use that one - with all shortcomings of course).

Wim

[lav4you]

Hi Wim,

Thanks for the quick reply.

I am getting an error message for all consolidated elements other than regions. Since these items do not have a match with target.
I have already included MDX query for Region dimension subset. the data transfer is absolutely fine

I was just looking for way to improvise and get rid of unnecessary codes to create Subset for other 7 dimensions.


Regards,
Lav

[tomok]

There are no shortcuts. If you decide you want consolidated elements from at least one of the dimensions (and thus turn off the suppression of those) then you have to explicitly select only leaf level elements in all the other dimensions (via a subset) if that's what you want.