Alias's not working in Excel Retrieve
Posted: Mon Apr 27, 2009 1:49 pm
I encountered a problem with retrieving data based on alias's.
Background:
1.) Built Excel worksheet 2 weeks ago, utilizing alias's for the retrieve values in one of the dimensions. Proofed out sheet, everything works fine.
2.) Came in today, and only the cells that refer to Account ID's only are working, while any retrieve that is pointing to an account alias are not.
3.) Went into the attribute table, copied Alias directly from the attribute table and it still won't work.
4.) Typed in the element ID, instead of the Alias, and the values then populated as they were supposed to (both DBRW and DBRA commands)
5.) Put Alias back in and it stopped working again.
Other Observations:
A.) Only two of my dimensions uses Alias's for retrieves, but one seems to be immune from this. All ID/Alias issues appear related to the same dimension.
B.) Rebooted my PC and the server, but no luck.
C.) When I type in the ID, I can retrieve the Alias with the DBRA function with no problems.
D.) Confirmed in the attribute table that my Alias's are in fact of the "alias" type.
What am I missing here? Why did my alias's stop working all of the sudden? Is there a setting that got switched off. I've been using TM1 for 10 years and have never seen this before. Any help would be greatly appreciated.
Background:
1.) Built Excel worksheet 2 weeks ago, utilizing alias's for the retrieve values in one of the dimensions. Proofed out sheet, everything works fine.
2.) Came in today, and only the cells that refer to Account ID's only are working, while any retrieve that is pointing to an account alias are not.
3.) Went into the attribute table, copied Alias directly from the attribute table and it still won't work.
4.) Typed in the element ID, instead of the Alias, and the values then populated as they were supposed to (both DBRW and DBRA commands)
5.) Put Alias back in and it stopped working again.
Other Observations:
A.) Only two of my dimensions uses Alias's for retrieves, but one seems to be immune from this. All ID/Alias issues appear related to the same dimension.
B.) Rebooted my PC and the server, but no luck.
C.) When I type in the ID, I can retrieve the Alias with the DBRA function with no problems.
D.) Confirmed in the attribute table that my Alias's are in fact of the "alias" type.
What am I missing here? Why did my alias's stop working all of the sudden? Is there a setting that got switched off. I've been using TM1 for 10 years and have never seen this before. Any help would be greatly appreciated.