TM1 Forum

I was wondering is it possible to reference a cube where there is a string element that I want to create a dimension then transfer the data from that cube to another consolidating all the values with the same string element. The only difference is the source cube, has an item description as part of the measure and on the destination cube it form part of the cube as a dimension.

Like for example I'm doing a CAPEX model where I allow users to type the product description. Then I create that item description as a dimesnion so I can have a report that shows a specific printer and which months I have budgeted to buy this printer?

Since I'm more familiar with data transfer with the use of attribute...there might be other way of doing this that I'm not familiar with. Is there a better approach to this this kind of requirement.

First you need a dimension at the source dimension with a 'Total' element to sum the value with the common 'Item description' (such as 1,2,3, and TOTAL NO.), and another hidden cube consisting of measure dimension and all other dimensions which match the destination cube.

Then write rule at the hidden cube as;
IF ( DB(...source cube... 'item decription') @= ! item decscription, DB(...source cube with ! of all dimensions....), stet or whatever )

This way it will check the data of the measure 'item decription' at the source cube, when matched with the hidden cube, it will pull the desired value (says the price of product) from source to the hidden cube.

Then at the destination cube, write rule as
DB(... hidden cube....,' TOTAL NO.')
The destination cube will pull from the hidden cube the price at TOTAL NO., which are summation of prices of a single 'item description'.

BAC, Thailand