I'm using EV vers 9.3.1 and have noticed that support for element aliases (right-click > Extra > Choose Alias Tables) has a definite bug. Where multiple dimensions in a cube have aliases of the same name, the alias(es) if selected will apply to ONLY the first dimension in the cube (in tabdim order).
The only way around it would seem to be to create unique alias names for each dimension by creating an additional alias per dimension by prefixing or suffixing the dimension name to the alias name. This seems like quite an annoying and otherwise unnecessary chore and a little contrary to standard TM1 design.
EV support for aliases
-
- Regular Participant
- Posts: 152
- Joined: Fri May 23, 2008 12:08 am
- OLAP Product: TM1 CX
- Version: 9.5 9.4.1 9.1.4 9.0 8.4
- Excel Version: 2003 2007
- Location: Melbourne, Australia
- Contact:
EV support for aliases
Last edited by ScottW on Thu Aug 28, 2008 3:17 am, edited 1 time in total.
-
- Posts: 6
- Joined: Mon Aug 25, 2008 12:43 pm
Re: EV support for aliases
Maybe a good question to post to http://www.evusers.org/ which is pretty active and good about EV as it is run by the some of the old "Temtec" team, company which create EV at the beginning...
Hope this help.
Robert
Hope this help.
Robert
-
- Regular Participant
- Posts: 152
- Joined: Fri May 23, 2008 12:08 am
- OLAP Product: TM1 CX
- Version: 9.5 9.4.1 9.1.4 9.0 8.4
- Excel Version: 2003 2007
- Location: Melbourne, Australia
- Contact:
Re: EV support for aliases
Thanks Robert,
Martin / site admin, how about posting a link to the EV users board on the board index?
Martin / site admin, how about posting a link to the EV users board on the board index?
Re: EV support for aliases
Scott,
I recall a similar issue in EV 9.1.2, multiple alias(es) with same name (only different case) would result in undefined behavior, but this 'bug' was solved in EV 9.3.1! (the version you have), your issue seems to be a variant of that one though. So I suggest you contact Cognos Support to report it.
In your case you use the same alias(es) for different dimensions?
BTW the latest and greatest version of Executive Viewer is now 9.4, but it's possible that Cognos has not communicated this yet.
An external link has been already posted about the EVUsers.org in the Olapedia but, as you said, it may be a good idea to post it on the board index as well...
http://wiki.olapforums.com/index.php?ti ... ive_Viewer
Reg,
Garcia
I recall a similar issue in EV 9.1.2, multiple alias(es) with same name (only different case) would result in undefined behavior, but this 'bug' was solved in EV 9.3.1! (the version you have), your issue seems to be a variant of that one though. So I suggest you contact Cognos Support to report it.
In your case you use the same alias(es) for different dimensions?
BTW the latest and greatest version of Executive Viewer is now 9.4, but it's possible that Cognos has not communicated this yet.
An external link has been already posted about the EVUsers.org in the Olapedia but, as you said, it may be a good idea to post it on the board index as well...
http://wiki.olapforums.com/index.php?ti ... ive_Viewer
Reg,
Garcia
- Martin Ryan
- Site Admin
- Posts: 1989
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: EV support for aliases
Not quite sure where to put it. A single post doesn't warrant a forum of its own and I'm loathe to put it up with the Jobs/Olapedia/Calendar links in the top right as it is specific to the TM1 community (and a subset at that).ScottW wrote:Martin / site admin, how about posting a link to the EV users board on the board index?
I might set up a "Links" link at the top right with Jobs/Olapedia/Calendar that includes the EV forum and other stuff (e.g. The sites of Cognos partners who send me loads of money).
Can I suggest in the meantime you just tell people whenever they ask an EV question that they might get better response there? And people affiliated with the site can put the details in their signature if they wish.
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
-
- Site Admin
- Posts: 6647
- 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: EV support for aliases
WE'RE ACTUALLY ALLOWING PEOPLE TO SUGGEST USING OTHER FORUMS???Martin Ryan wrote:Not quite sure where to put it. A single post doesn't warrant a forum of its own and I'm loathe to put it up with the Jobs/Olapedia/Calendar links in the top right as it is specific to the TM1 community (and a subset at that).ScottW wrote:Martin / site admin, how about posting a link to the EV users board on the board index?
I might set up a "Links" link at the top right with Jobs/Olapedia/Calendar that includes the EV forum and other stuff (e.g. The sites of Cognos partners who send me loads of money).
Can I suggest in the meantime you just tell people whenever they ask an EV question that they might get better response there? And people affiliated with the site can put the details in their signature if they wish.
Wow.
Oh wait... this isn't Cognos Communities, is it?

(Interesting aside; you must have been logged in on the Test forum when you made that post since that was where the link was to in the notification e-mail. I thought it was a little odd that the star ratings were visible when I landed here...)
"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.
- rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: EV support for aliases
Right click in the on the view and the click on Extra -> Choose Alias Tables
Please see the attached screen shot for details
Please see the attached screen shot for details
- Attachments
-
- Using TM1 Aliases in Executive viewer
- EV_UsingTM1Aliases.JPG (26.25 KiB) Viewed 5440 times
Cheers!
Rizwan Kaif
Rizwan Kaif
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: EV support for aliases
It seems as though we have a 2 year echo ....rkaif wrote:Right click in the on the view and the click on Extra -> Choose Alias Tables

The original post also said exactly that and was referring to a bug in that feature with an older version of EV
ScottW wrote:I'm using EV vers 9.3.1 and have noticed that support for element aliases (right-click > Extra > Choose Alias Tables) has a definite bug ...