TM1 Forum

Hi All,

I am writing a Ti process sourcing off of a cubeview that has measure dimension with multiple elements. On the variables tab only the first element of the measure dimension shows up . i dont see the remaining two measure elements.

I need all the measure elements along with the values to be loaded into a reporting cube. Tried looking up the same cube but getting error.

My cube structure is
Dimensions:
Project
Projecttype
Measure dimension
- Go live date
- Allocation location
-Project location

Appreciate your help.

I guess if figured it out.

You would need to create the cube view with just the first measure element and then use Cellget to get the other measure values.

Thanks

TM1 doesn't have the concept of a special measure dimension. Views will be read in TI with a single column and all dimensions on the row. This applies whether you have built a 'user' view or (the preferred approach) used Export to Text File to create the view.

yogin wrote:I guess if figured it out.

You would need to create the cube view with just the first measure element and then use Cellget to get the other measure values.

Thanks

As David explained, when you use a cube view as a source you get one record for every intersection in the view. If you have four measures in your measures dimension that's four separate records. To process so that each measure is part of one TI "record" then you would have to pull one in the view and then do a CellGet to get the other three. However, configuring the view to pull one of them and then CellGetting the others has a problem: If you are zero suppressing and the measure in the view is zero you'll never get it in the TI and you'll never CellGet the others. Better to create a consolidation of the four, use that in the view, and CellGet the four individual measures.