TM1 Forum

Hi All,Rules guide defines the exclamation mark used in the rules as
"The exclamation point character is used as part of the !dimension argument in the rules DB function
and should not be used in object names that will be used in rules.
DB('MarketExchange',!market,!date)"

It is bit vague,what circumstances and when we use exclamation.Appreciate if someone explains with practical example.Thanks

You need to read the documentation. This is found in the Developer Guide, in the chapter entitled Advanced Calculations for Business Data .

From your prior posts it would appear that you are a consultant charging for your TM1 services. The issue you are raising here is at a level of difficulty that a paid consultant should be able to resolve it without outside help. Your question would be better directed to people within your organisation who are there to help you develop your skills. Alternatively you might ask your employer to put you on an IBM or IBM Partner training course.

If the assumption that you are a consultant/contractor is incorrect, please make that known. Forum members are generally more willing to support basic questions from end users than from those who charge for their TM1 knowledge.

Hi,
I actually have the same question as mentioned in this thread.

I am a business analyst working within a corporation and am now to TM1. I am trying to workout what the ! means when used in example like

attr(dimensions, !dimension, element)

TIA

Danielle

Danielle wrote:Hi,
I actually have the same question as mentioned in this thread.

I am a business analyst working within a corporation and am now to TM1. I am trying to workout what the ! means when used in example like

attr(dimensions, !dimension, element)

TIA

Danielle

The !dimension notation denotes a relative reference. Meaning wherever the rule is evaluated in the cube the address on that dimension will be "looked up" relative to the location of the cell. To put it in Excel terms if a reference in a formula is "A1" as you drag it down 1 row it changes to "A2", if you drag from there across 1 column it changes to "B2", etc. etc. If the cell location was fixed as "$A$1" then it stays static and always points to A1. In TM1 a fixed reference is always via name e.g. 'ElementX' and the dynamic reference is with !

Also as per advice given above, read the user and developer guide. It will save you a lot of time in the long run.

Danielle wrote:I actually have the same question as mentioned in this thread.

I am a business analyst working within a corporation and am now to TM1. I am trying to workout what the ! means when used in example like

attr(dimensions, !dimension, element)

As mentioned above the Rules Guide is the place to fund the answer to this, however this thread may prove enlightening. The use of the exclamation mark in attribute functions means the same as it does in DB functions (or indeed any functions which take an element name as an argument).