Page 1 of 1
Syntax for rules for dimension names with space
Posted: Thu Feb 03, 2011 4:32 am
by telula_w
Hello,
Can anyone show me the syntax for the left hand side of the rules where there is a space in the dimension name
[ region:'AUS', cost center :'10', 'A111111']=N: .....
I am getting an error in the cost center section
Re: Syntax for rules for dimension names with space
Posted: Thu Feb 03, 2011 4:46 am
by Gregor Koch
Hi
Try
[ region:'AUS', 'cost center':'10', 'A111111']=N:
Re: Syntax for rules for dimension names with space
Posted: Thu Feb 03, 2011 5:05 am
by Alan Kirk
telula_w wrote:Hello,
Can anyone show me the syntax for the left hand side of the rules where there is a space in the dimension name
Gregor's approach seems to work; so does simply omitting the spaces from the dimension name. As was discussed recently, TM1 is (usually) case insensitive and in 9.5.1 at least the rules seem happy enough to follow the principle on page 14 of the Developer's Guide that:
Spaces in Object Names
Spaces are allowed in all object names, but spaces are ignored by the IBM® Cognos® TM1® server. The TM1 server considers the dimension name Act Vs Bud to be equivalent to ActVsBud (or actvsbud).