TM1 Forum

Hi,

New to TM1,trying to learn.

I would like to know ,how to extract the input values from the picklist and transfer to a different cube.

Example:

Car model year color
Camry 95 red

I want to assign "camry,95, red " values to a different cube.

Thanks in advance.

Moved to the correct forum.

Prajan_cyber wrote:Hi,

New to TM1,trying to learn.

I would like to know ,how to extract the input values from the picklist and transfer to a different cube.

Example:

Car model year color
Camry 95 red

I want to assign "camry,95, red " values to a different cube.

Thanks in advance.

I might be wrong but as far as I know picklists actually are "text" values in the cell. So in my opinion you could use the substring operators to extract the values you need from the strings placed in the picklist cells and then paste them in other cubes using the cellput instructions.

This is how I would do it:

The picklist-dimension would have string attributes with Model, Year and Color.

The "different cube" would then contain rules that checks the picklist value and then gets the model, year and color using ATTRS.