Syntax for rules for dimension names with space

Post Reply
telula_w
Posts: 15
Joined: Wed Jan 05, 2011 11:28 pm
OLAP Product: TM1
Version: 9.1
Excel Version: 2003

Syntax for rules for dimension names with space

Post 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
Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: Syntax for rules for dimension names with space

Post by Gregor Koch »

Hi
Try
[ region:'AUS', 'cost center':'10', 'A111111']=N:
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Syntax for rules for dimension names with space

Post 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).
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply