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 » Thu Dec 08, 2016 11:44 pm

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: 6164
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Setting an Alias on Title dimension in a view

Post by Alan Kirk » Fri Dec 09, 2016 12:00 am

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 » Fri Dec 09, 2016 5:24 am

Yes that will work

Post Reply