EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB44976: How to display the last or a specific attribute element instead of the first element in a dynamic textbox in a document's header section with MicroStrategy Web 9.x


Community Admin

• Strategy


SYMPTOM
When adding dynamic text for a given attribute in the dataset to a "header" section of the document, the dynamic text box will always resolve to the first attribute element in the dataset. There is no option to configure the text box to resolve to the last or a specific attribute element.
 
For example, the following document contains a dataset with the attribute Month and metric Profit. In the document header section, dynamic text for Month DESC attribute form is displayed as {Month@DESC}. The detail section lists all attribute elements available in the dataset.
 

ka04W000000OhnQQAS_0EM440000002JR6.png

 
In consequence, the document header section resolves the dynamic text to the first attribute element in the dataset, which is "Jan 2014" in this case.
 

ka04W000000OhnQQAS_0EM440000002JRB.png

 
CAUSE
This is by design and the behaviour cannot be configured manually. There is however a workaround that will help achieving the desired behaviour by following the steps in below workaround section.
 
ACTION
An enhancement request has been logged to review manual configuration of this behaviour. Contact technical support for a status update on this enhancement.
 
WORKAROUND 
To achieve displaying the last or a specific attribute element, one approach would be to use a selector that targets the text box and selects the last available element. As seen on the screenshot below, we must place the title textbox on a panel. Next, insert a selector and target the panel stack.
 

ka04W000000OhnQQAS_0EM440000002JRa.png

 
 
Set the selector to slice selector (uncheck "Use selector as a filter" option) and choose "Use Last" for current state setting.
 

ka04W000000OhnQQAS_0EM440000002JRG.png

 
Subsequently, when executing the document, note that instead of the first element, the last element is resolved by the dynamic text box.
 

ka04W000000OhnQQAS_0EM440000002JRL.png

 
Finally, you can hide the selector control and format the panel stack to blend into the background.
 

ka04W000000OhnQQAS_0EM440000002JRQ.png
ka04W000000OhnQQAS_0EM440000002JRV.png

Comment

0 comments

Details

Knowledge Article

Published:

April 13, 2017

Last Updated:

April 13, 2017