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
Syntax for rules for dimension names with space
-
- 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
Hi
Try
[ region:'AUS', 'cost center':'10', 'A111111']=N:
Try
[ region:'AUS', 'cost center':'10', 'A111111']=N:
-
- 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
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: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
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.