Page 1 of 1
Picklist cube not available when created by TI
Posted: Mon Jan 23, 2017 3:29 pm
by 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
Re: Picklist cube not available when created by TI
Posted: Mon Jan 23, 2017 5:06 pm
by David Usherwood
Did you run File\Refresh Available Servers? That is typically necessary to make new objects visible to Perspectives.
Re: Picklist cube not available when created by TI
Posted: Mon Jan 23, 2017 8:06 pm
by TomaszB
David Usherwood wrote: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
Re: Picklist cube not available when created by TI
Posted: Mon Jan 23, 2017 8:23 pm
by 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.
Re: Picklist cube not available when created by TI
Posted: Tue Jan 24, 2017 9:04 am
by 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
Re: Picklist cube not available when created by TI
Posted: Tue Jan 24, 2017 12:13 pm
by 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 ?
Re: Picklist cube not available when created by TI
Posted: Wed Jan 25, 2017 7:11 pm
by 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