Tutorial:Dynamic Measure Captions

CoPlanner allows to define dynamic measure captions.

Therefore please open the BI-Center and an input mask. Select a measure in the object tree. On the right side the properties of the measure will be shown.

In this example following should be shown as measure caption (Quantity actual previous year):

• On the year element the measure caption and die previous year.
• On the months the measure caption, the month and the year.

Please insert following expression in the property "Caption":

'Quantity act. ' + 'TimeDimAdd(M,-12,[Zeit.ID],IIF('TimeDimFlag([Zeit.ID])'='Y','yyyy','MMM yy'))'

Error creating thumbnail: File missing

IIF-Condition

If you would like to display the measure in english and german, the expression looks like this:

german='Menge Ist ' + 'TimeDimAdd(M,-12,[Zeit.ID],IIF('TimeDimFlag([Zeit.ID])'='Y','yyyy','MMM yy'))';english='Quantity act. ' + 'TimeDimAdd(M,-12,[Zeit.ID],IIF('TimeDimFlag([Zeit.ID])'='Y','yyyy','MMM yy'))';

The dynamic display is available for the tooltip too.