Referring to a Dimension Name with brackets

Post Reply
User avatar
TheMichael
Posts: 12
Joined: Tue Aug 19, 2008 12:08 pm
Location: Johannesburg, South Africa

Referring to a Dimension Name with brackets

Post by TheMichael »

If you have a dimension with brackets in it's name, say "Dim1 (Brand)" for example, how to you specify the dimension in a function as:

=N: DB("Cube1",!Dim1(Brand), ...)

You get an error if you try to do it as above. Putting quotations in won't work either. Has anybody encountered this before ?
User avatar
Steve Rowe
Site Admin
Posts: 2407
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Referring to a Dimension Name with brackets

Post by Steve Rowe »

I'm guessing you can't, it's normal to avoid these kind of chracters when naming objects...My only guess would have been single quotes, if you've tried that then I can't help, not that means that there isn't answer (other than change the name of dimension and rebuild the cube!)
Cheers
Technical Director
www.infocat.co.uk
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: Referring to a Dimension Name with brackets

Post by Alan Kirk »

TheMichael wrote:If you have a dimension with brackets in it's name, say "Dim1 (Brand)" for example, how to you specify the dimension in a function as:

=N: DB("Cube1",!Dim1(Brand), ...)

You get an error if you try to do it as above. Putting quotations in won't work either. Has anybody encountered this before ?
Yup, I thought that this one sounded familiar. Time for a dimension name change I'm afraid. See:
http://applixforum.olapforums.com/viewP ... adID=12074

and

http://applixforum.olapforums.com/viewP ... adID=16870
"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.
Phil Maynard
Posts: 1
Joined: Fri May 16, 2008 8:08 pm

Re: Referring to a Dimension Name with brackets

Post by Phil Maynard »

There is the concept of putting an alias on a dimension. Never tried it but it might work. Right click on Dimension> Edit Attributes and proceed as usual.
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: Referring to a Dimension Name with brackets

Post by Alan Kirk »

Phil Maynard wrote:There is the concept of putting an alias on a dimension. Never tried it but it might work. Right click on Dimension> Edit Attributes and proceed as usual.
Exercise care in attempting this; as per the links in my previous post, this has the potential to cause a server crash.

Admin Note: Certain post exchanges have been deleted from this thread for the sake of the tone of the Forum.
"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.
User avatar
TheMichael
Posts: 12
Joined: Tue Aug 19, 2008 12:08 pm
Location: Johannesburg, South Africa

Re: Referring to a Dimension Name with brackets

Post by TheMichael »

Luckily it's still early in the development phase, so rebuilding is still an option.

Thanks for the help!
Post Reply