Alias Text

Post Reply
AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Alias Text

Post by AmbPin »

Hello,
I have built a customer dimension based on customer ID which has some 16K elements; this has worked fine and performed well until now. This week I have added a more user friendly alias using dbsa spreadsheet statements to match elements to names from a SQL extract from Sage. This seemed to work OK until I stopped and restarted the service. After the service restarted every time anyone switches to the alias the TM1 service on the server hangs. I have recreated this issue on a second server too. If I clear all of the alias values out using the dbsa then the dimension works again.
The alias contains combinations of customer names from around Europe so there are extended charachters.

Has anyone come across an issue like this?
User avatar
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: Alias Text

Post by rkaif »

Try running SaveDataAll() before restarting the service.
Cheers!
Rizwan Kaif
AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Re: Alias Text

Post by AmbPin »

Hello,

I have tried that already but it made no difference.
User avatar
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: Alias Text

Post by Martin Ryan »

Sounds like a proper bug that you should report to support.

The only thing I can think to check is that the aliases are unique. Usually if two elements have the same alias then TI simply doesn't load it the second time and spits an error, but perhaps your system isn't handling it very well.

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
Post Reply