}ElementSecurity_: do not use it as prefix in a cube
Posted: Thu Nov 05, 2020 12:23 am
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"
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:
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.
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' );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';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.
