Page 1 of 1

[SOLVED] What is TurboIntegrator function to assign Measure Dimension cube property to cube?

Posted: Fri Oct 30, 2015 6:01 am
by Stanislav2
Hi,
using Cognos 10.1.1. Every time I create a cube from TurboIntegrator I manually right click on cube and select Properties option, then I select a dimension for "Measure Dimension" setting. I have to assign measure dimension because of Cognos BI requirement.

My idea is to just add some TI function to the TI create cube process. Is there a TurboIntegrator function to assign Measure Dimension cube property to cube?
Thanks

Re: What is TurboIntegrator function to assign Measure Dimension cube property to cube?

Posted: Fri Oct 30, 2015 7:01 am
by escape18in
why cant you assign value in }CubeProperties using cellputs('Dimension name', '}CubeProperties','Cube name','Measures Dimesnion') in your TI code?

Re: What is TurboIntegrator function to assign Measure Dimension cube property to cube?

Posted: Fri Oct 30, 2015 7:46 am
by Stanislav2
In Epilog of create cube TI process I added code:

Code: Select all

CellPutS('Dimension_name', '}CubeProperties', 'Cube_name', 'MEASURES_DIMENSION');
Where: 'Dimension_name' is measure dimension name and 'Cube_name' is cube name.
Thanks for help. Problem solved.

P.S.It totally flip my mind that TM1 settings are also stored in cubes.

Re: [SOLVED] What is TurboIntegrator function to assign Measure Dimension cube property to cube?

Posted: Mon Nov 02, 2015 3:26 pm
by David Usherwood
That's pretty much the only place TM1 has to store content. Sometimes IBM deigns to document what is where.