Setting an Alias on Title dimension in a view

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

Setting an Alias on Title dimension in a view

Post by PeteB »

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 );
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: Setting an Alias on Title dimension in a view

Post by Alan Kirk »

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 );
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.
"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.
PeteB
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

Post by PeteB »

Yes that will work
Post Reply