Hi,
Is there a way to attach an alias to the title dimension in a view.
I am currently using the following commands to set the element for the title dimension, however I can't find the command to turn on the alias for the dimension.
ViewTitleDimensionSet( sCube, sView, sDim );
ViewTitleElementSet( sCube, sView, sDim, nIndex );
Setting an Alias on Title dimension in a view
- 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: Setting an Alias on Title dimension in a view
Off the top of my head the only way I can think of to do this is to create a subset for the dimension in question (use MDX if you want it to dynamically update, or Bedrock has a few good functions for quick'n'easy subset creation), assign it with ViewSubsetAssign, then you can use SubsetAliasSet. The rest is as you're doing it at the moment.PeteB wrote:Hi,
Is there a way to attach an alias to the title dimension in a view.
I am currently using the following commands to set the element for the title dimension, however I can't find the command to turn on the alias for the dimension.
ViewTitleDimensionSet( sCube, sView, sDim );
ViewTitleElementSet( sCube, sView, sDim, nIndex );
"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.
-
- Posts: 23
- Joined: Sun Sep 23, 2012 2:30 am
- OLAP Product: Planning Analytics Local, PAW
- Version: PAL 2.0.6, PAW 2.0.45
- Excel Version: 2010
Re: Setting an Alias on Title dimension in a view
Yes that will work