TM1 Forum

Under Process/Map/Dimension/Action...The options available are Create/ReCreate/Update/Asls .....What is Asls ? Nothing in any of the TM1 documentation including Google Search...

Thanks

mukeshrajdass wrote:Under Process/Map/Dimension/Action...The options available are Create/ReCreate/Update/Asls .....What is Asls ? Nothing in any of the TM1 documentation including Google Search...

Don't blame you for not being able to figure out that one; it's one of the reasons that I don't regard the code wizard as being particularly user friendly.

It's not ASLS, it's actually the two words "As is" mooshed together. In other words when you have a data field that represents dimension elements, you're telling the process not to do anything about updating the dimension but to simply use the element names as you find them. (Which is another way of saying use them "as is".) As you've noticed the other options are to Recreate the dimension from the names that you find in that field, to Create it if it doesn't exist, or to Update the dimension with any new elements.

(Of course if the element name in the field doesn't exist in the dimension and you leave this set to As Is, you'll then get reject errors if you're uploading data from the file.)

Appreciate your help....I'm just looking at a client site where somebody has used the Wizard as opposed to the raw Turbo Integrator which i and most TM1 developers prefer.

Thanks

If you prefer the raw turbo integrator then you can just skip ahead to the Advanced tabs and look at the code there. All the Wizard does is generate code.

You can take it one step further by copying all the generated code into the editable section, then remove the wizard stuff, including the generated code, by changing all the variable types to "Other".

Martin

Hi Martin....missed you buddy !! I'm in Auckland.

Another question...I've written alot of TM1 Turbo stuff but for some reason TODAY...I must be RETARDED !!

A VERY simple script is spitting error ... An elephant error is there and i must be missing it...

vcb = 'cp_ZSysLog';
vdm1 = 'cp_ZSysLogEvent';
vdm2 = 'cp_ZSysLogMeasure';

if(CubeExists(vcb) = 1);
CubeDestroy(vcb);
endif;

if(DimensionExists(vdm1) = 1);
DimensionDestroy(vdm1);
endif;
DimensionCreate(vdm1);
DimensionElementInsert(vdm1,'','Event1', 'S');

if(DimensionExists(vdm2) = 1);
DimensionDestroy(vdm2);
endif;
DimensionCreate(vdm2);
DimensionElementInsert(vdm2,'','Qty', 'N');

CubeCreate(vcb,vdm1, vdm2);

CellPutN(550,vcb,'Event1','Qty'); <----Error: Prolog procedure line (27): Invalid key: Dimension Name: "cp_ZSysLogEvent", Element Name (Key): "Event1"

WHAT AM I DOING WRONG ??? Did i get DimensionElementInsert Wrong with the S and N ?

Thanks...

mukeshrajdass wrote:Hi Martin....missed you buddy !! I'm in Auckland.

Another question...I've written alot of TM1 Turbo stuff but for some reason TODAY...I must be RETARDED !!

A VERY simple script is spitting error ... An elephant error is there and i must be missing it...

vcb = 'cp_ZSysLog';
vdm1 = 'cp_ZSysLogEvent';
vdm2 = 'cp_ZSysLogMeasure';

if(CubeExists(vcb) = 1);
CubeDestroy(vcb);
endif;

if(DimensionExists(vdm1) = 1);
DimensionDestroy(vdm1);
endif;
DimensionCreate(vdm1);
DimensionElementInsert(vdm1,'','Event1', 'S');

if(DimensionExists(vdm2) = 1);
DimensionDestroy(vdm2);
endif;
DimensionCreate(vdm2);
DimensionElementInsert(vdm2,'','Qty', 'N');

CubeCreate(vcb,vdm1, vdm2);

CellPutN(550,vcb,'Event1','Qty'); <----Error: Prolog procedure line (27): Invalid key: Dimension Name: "cp_ZSysLogEvent", Element Name (Key): "Event1"

WHAT AM I DOING WRONG ??? Did i get DimensionElementInsert Wrong with the S and N ?

Thanks...

Whether a cubes intersection is Numeric or String is purely driven by the element in the cubes LAST dimension, so since "Event1" isn't in "cp_ZSysLogMeasure", it doesn't really matter... although if I knew more about what you were doing I may be inclined to query whether it should be string or numeric.

By any chance is the whole script shown above on your prolog tab?
If so, just move the CellPutN to the epilog tab and it should work.

If you search the forum you will find a few topics about the order in which tasks are executed, this issue will be arising from the fact that TM1 has't committed your metadata changes within the tab before you get to the attempted data change.

Whether a cubes intersection is Numeric or String is purely driven by the element in the cubes LAST dimension, so since "Event1" isn't in "cp_ZSysLogMeasure", it doesn't really matter... although if I knew more about what you were doing I may be inclined to query whether it should be string or numeric. <--- Don't understand what you mean ?

By any chance is the whole script shown above on your prolog tab? YES

mukeshrajdass wrote:Whether a cubes intersection is Numeric or String is purely driven by the element in the cubes LAST dimension, so since "Event1" isn't in "cp_ZSysLogMeasure", it doesn't really matter... although if I knew more about what you were doing I may be inclined to query whether it should be string or numeric. <--- Don't understand what you mean ?

By any chance is the whole script shown above on your prolog tab? YES

Sorry, I got a bit trigger happy and slipped to press enter before I had finished. I edited the post above just as you were writing yours!
Long story short, move the cellputN to the epilog and all should be fine.

DAMN !! I forgot the obvious....too keen on coding everything on Prolog....yep you r right...

Appreciate your help.. Thx...Owe you a beer.