Prevent string data entry at consolidation level

[tez]

Hi

We would like to prevent data entry into a string field at the consolidation level. Has anyone been able to do this?

Currently, we are just using grey shading on the cell in Excel so it looks "locked" to the user, but would like to lock it properly from the cube if possible.

Thanks

[Alan Kirk]

We would like to prevent data entry into a string field at the consolidation level. Has anyone been able to do this?

Currently, we are just using grey shading on the cell in Excel so it looks "locked" to the user, but would like to lock it properly from the cube if possible.

Thanks

The easiest way is to put security on the dimension and give the users only Read access at consolidation level.

[tez]

Thanks Alan, we shall do that.

[lotsaram]

If you want no string comments at consolidated level at all you could also use a rule to set the cell value to a blank string. The test could be for a leaf cell or level 0 on one or more dimensions.

For example

Code: Select all

[ ] = S:
IF( ISLEAF = 1,
  STET,
  ''
);

[kkmk]

Hi,

I am also facing the same problem and trying to write a rule that prevent data entry at C level. Can anyone help with the rule on how to check this? My data is not string type, it is numeric.

Thanks
KKMK

[MSidat]

KKMK,

No need to write a rule to stop data entry at C Level for numeric data points as TM1 by default will not allow you to write to a numeric data point. Only Rules can override the default consolidations that occur at C Level.

[kkmk]

I am trying in TM1 Web, where I am able to enter values in Consolidation and it is spreading. How to prevent this using Rule.

[lotsaram]

I am trying in TM1 Web, where I am able to enter values in Consolidation and it is spreading. How to prevent this using Rule.

If you don't want to override the natural consolidation but want to prevent the ability to spread at a consolidated level then the way you do this is to implement element security in the dimension(s) where you don't want to spread such that consolidated elements are READ not WRITE. (usually only 1 or 2 dimensions will be relevant for security purposes). If you want to prohibit spreading on ANY dimension then you could do this with cell security in which case your rule would look something like...

Code: Select all

[ ] = S:
IF( IsLeaf() = 1,
  STET,
  'READ'
);

EDIT:
Hmm, I see on review I gave EXACTLY THE SAME ADVICE BACK IN 2011 in this very same thread! http://www.tm1forum.com/viewtopic.php?f ... 376#p18786
Top marks to you for reading the thread before asking your question!
Shame there isn't a simile emoticon for red with steam coming from ears, I will have to make do with "evil"

[kkmk]

I was trying to do this with DTYPE and here is my rule:

[] = S: IF(DTYPE(!PL_Funds, DIMNM('PL_Funds', DIMIX('PL_Funds', !PL_Funds))) @= 'C', 'Read', STET);

There is no error shown but not getting the expected output as similar to using ISLEAF function. Am I missing something?

Thanks
KKMK

[tomok]

I was trying to do this with DTYPE and here is my rule:

[] = S: IF(DTYPE(!PL_Funds, DIMNM('PL_Funds', DIMIX('PL_Funds', !PL_Funds))) @= 'C', 'Read', STET);

There is no error shown but not getting the expected output as similar to using ISLEAF function. Am I missing something?

Yes. Do you know the syntax for using the DTYPE function (and for that matter, ALL the dimension and element functions)??? The first argument is always the dimension name, not an element. And why are you looking up the index, to get the name of an element to use in the function? You already have the name of an element by just using the !Dimension notation. Try this:

[] = S: IF(DTYPE('PL_Funds', !PL_Funds) @= 'C', 'Read', STET);

[kkmk]

Thanks Tomok..working as expected.