Page 1 of 1

Setting an Alias on Title dimension in a view

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

Re: Setting an Alias on Title dimension in a view

Posted: Fri Dec 09, 2016 12:00 am
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.

Re: Setting an Alias on Title dimension in a view

Posted: Fri Dec 09, 2016 5:24 am
by PeteB
Yes that will work