}ElementSecurity_: do not use it as prefix in a cube

[Wim Gielis]

While I was working on a script for the topic security by user (viewtopic.php?f=3&t=15582), I created a new control cube as:

vCube = '}ElementSecurity_' | Dim | '_2';

Basically, a suffix _2 to the normal security cube for elements on the dimension "Dim".

TI allows you to create such a cube, but writing leads to errors. Even non-sensical errors, such as: "Cell type is consolidated"

Code: Select all

vCube = '}ElementSecurity_TEST';

CubeCreate( vCube, 'test_dim', '}Clients' );

CellPutS( 'HELLO WORLD', vCube, 'A', 'B' );

The above leads to this error message. To test it, add a couple of test values or recreate the situation.
Even if the dimension "TEST" does not exist, this leads to an error.

1 character of a difference and it gives no error and does what it is supposed to do:

Code: Select all

vCube = '}ElementSecurityTEST';

I remove the underscore here.

So the takeaways:
- the error message makes no sense at all
- we should never create cubes starting with "}ElementSecurity_", choose a different name. Probably IBM treats cube names with this prefix in a different way / have their own plans with them.

[scrumthing]

Thanks for the information Wim! Didn't know that. Fascinating.