Is it possible to identify via Rules if a dimension is part of a cube?
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Thanks.
Art
TABDIM only gives you the dimension name for the specified index. TABDIM doesn't accept a dimension name as a parameter.lotsaram wrote:The function you want is TABDIM. If it returns 0 then the dimension is not part of the cube.
Which can purely be built via a scheduled TI and a pretty damn simple TI at that so all in all its not at all difficult to do...FallenCipher wrote:TABDIM only gives you the dimension name for the specified index. TABDIM doesn't accept a dimension name as a parameter.lotsaram wrote:The function you want is TABDIM. If it returns 0 then the dimension is not part of the cube.
A small helper cube would be the best solution in my opinion.
bunchukokoy wrote:It just became a requirement to identify if certain dims are part of certain cubes. And I wanted to make it general and simpler via rules.
But then, based on comments, it's the only solution which is as you said very simple to do.
Thanks.
Sorry what I meant was returns blank if the dimension is not part of the cube, not 0.FallenCipher wrote:TABDIM only gives you the dimension name for the specified index. TABDIM doesn't accept a dimension name as a parameter.lotsaram wrote:The function you want is TABDIM. If it returns 0 then the dimension is not part of the cube.
A small helper cube would be the best solution in my opinion.
Code: Select all
['Dim_Use_M':'Position'] = N:
IF( TABDIM(!zCubes, NUMBR(!DimIndex)) @= !zDimensions,
NUMBR(!DimIndex),
0
);