Picklist cube not available when created by TI

[TomaszB]

Hello everyone,

I need to create picklist cube using a TI process, but after executing the code the picklist is not available and an instance restart is required to enable the picklist.
If I do the same action manually the picklist is available directly after definition.

Is there a way to enable TI created picklists directly after creation?
Some function which I missing in my code?

Code: Select all

sCube = '}PickList_SomeCube';
sValue = 'Static:Opt1:Opt2:Opt3';

CubeCreate(sCube, 'A', 'B', '}PickList');
CellPutS(sValue, sCube, 'Elem1', 'Elem2', 'Value');

My thanks for your suggestion

Best Regards
Tomasz Brzoza

[David Usherwood]

Did you run File\Refresh Available Servers? That is typically necessary to make new objects visible to Perspectives.

[TomaszB]

Did you run File\Refresh Available Servers? That is typically necessary to make new objects visible to Perspectives.

Hi David,

yes I tried this already, but the picklist selection wasn't available after the refresh.

Best Regards
TomaszB

[Wim Gielis]

Hello Tomasz,

I cannot reproduce it.
I changed your coding for an actual cube in my (test) environment, and it worked straight away. Without F5 or server reboot.
The last version of TM1 is used for the test.

[TomaszB]

Hi Wim,

what is the latest version for you? Planning Analytics 2.0?
I tested in with 10.2.2 FP4 FP1 & 10.2.2 FP6 IF4 and both versions did not shown the picklist after TI execution.

Best Regards
Tomasz

[Wim Gielis]

Planning Analytics 2.0
But it would seem strange to me if it would not work in earlier versions.
What about other cubes ?

[TomaszB]

Hi Wim,

I installed PA 2.0 and tested it.

Results:
When I run my TI Process and the picklist cube doesn’t exist the selection doesn't appear.
After the restart the picklist is available. When I execute the process again and add a picklist to the same cube but another element combination the picklist is available directly.
The conclusion - if the picklist cube already exists the TI is working as expected, but if the picklist cube if getting created during the execution the selection isn’t available.

I used for testing the 'Go New Stores' model.
Cube: Base Sales Forecast
Added an additional 'A’ string element to the month dimension.

Code: Select all

sCube = '}Picklist_Base Sales Forecast';
sValue = 'Static:Opt1:Opt2:Opt3';
CubeCreate(sCube, 'Country and Region', 'Retailers','Existing Stores Revenue', 'Store Type','Budget version','Month', '}PickList');
CellPutS(sValue, sCube, 'Americas', 'All', 'Cash Discount', 'Corporate Store', 'Budget version 1','A', 'Value');

Best Regards
Tomasz Brzoza