Using dimension PickList to filter data on import to cube
Posted: Mon Jun 18, 2018 4:43 am
Hi all,
A quick bit of background. I am an experienced EP modeler and new to TM1, yet to get the IBM training. I am in the process of self teaching on our 10.2.2 installation currently using TM1 Performance Modeler.
I want to replicate a technique quite often used in EP.
I have a 2 dimensional cube. Dimension A is just a simple hierarchy dimension. Dimension B is a calculation dimension.
Dimension B has a text Picklist defined from another Dimension.
I can successfully import data into this cube. However, the data imported into the Picklist slice contains values outside of the picklist that can not normally be picked by the end user.
In EP the typical behaviour is that these values will not be imported and there is a blank.
How can I achieve this? Is there a setting somewhere? Is there something I need to do post import?
Thanks in advance for any help.
Mark.
A quick bit of background. I am an experienced EP modeler and new to TM1, yet to get the IBM training. I am in the process of self teaching on our 10.2.2 installation currently using TM1 Performance Modeler.
I want to replicate a technique quite often used in EP.
I have a 2 dimensional cube. Dimension A is just a simple hierarchy dimension. Dimension B is a calculation dimension.
Dimension B has a text Picklist defined from another Dimension.
I can successfully import data into this cube. However, the data imported into the Picklist slice contains values outside of the picklist that can not normally be picked by the end user.
In EP the typical behaviour is that these values will not be imported and there is a blank.
How can I achieve this? Is there a setting somewhere? Is there something I need to do post import?
Thanks in advance for any help.
Mark.