Dynamic Text and WikiText

Some of the places you can use dynamic text include:

• In HTML reporting elements
• In the EvalWiki function
• When creating drop down menus in editable tables
• In ApptioScript
• In arguments to the CopyTable function
• To control report component visibility

Example 1: Displaying User, Project, or Period in HTML

To start, create a sandbox report. You don’t need to check it in. Then create an HTML reporting element on the report and paste the following into the element:

User ID: <%=$CurrentUser:Users.Id%><br>

User Role: <%=$CurrentUser:Users.Role%><br>

User Name: <%=$CurrentUser:Users.Full Name%><br>

<br>

Domain Name: <%=DomainName()%><br>

Project Name: <%=ProjectName()%><br>

Trunk or Branch: <%=if(Left(ProjectName(),1)="-","branch","trunk")%><br>

Trunk Project Name: <%=if(Left(ProjectName(),1)="-",Mid(ProjectName(),2,find("_(",ProjectName())-2),ProjectName())%><br>

Trunk Path: <%=if(Left(ProjectName(),1)="-",DomainName()&":"&Mid(ProjectName(),2,find("_(",ProjectName())-2),DomainName()&":"&ProjectName())%><br>

<br>

Currently Selected Period: <%=CurrentDate("MMM ffff")%>

When you close the HTML configuration dialog you should see something like this:

This is an example of what you can do with dynamic text to obtain user, project, or period information.

Example 2: Displaying Table Data in HTML

If you wish to display data from a table in an HTML element, you can do this by associating columns from a table.

In this example we will create a report which displays the Cost of an IT Resource Tower in large bold text at the top, and the associated Cost Pools in a table beneath.

1. Create a report with an HTML element configured as follows. In this example we call the report "Dynamic Text Demo".

   

   The HTML in the screen shot is:

   <font size=5><%=IT Resource Tower Name%>: <b><%=Currency(Cost)%></b></font>

   Note that the HTML displays "{Various}", this is because there is more than one Cost Pool value in the Cost Pool column. However, we will address that shortly.

   On the same report we include a table that displays Cost by Cost Pool based on Cost Source object as shown in the screen shot above.

2. Next we create a separate report we call “Dynamic Text Drill Demo” with a table that displays Cost by IT Resource Tower Name and configure the Ad-Hoc drill to drill to the first report:

   

3. Now when we click on a IT Resource Tower Name in the table we arrive at the “Dynamic Text Demo” report filtered by the selected IT Resource Tower Name. In this example we clicked on “Network”:

   

Example 3: Component Visibility

This may better be placed in the report component visibility.

Example 4: Controlling Drop Downs in Editable Tables

This may better be placed in the drop down menus in editable tables.

Example 5: In ApptioScript

This may better be placed in the ApptioScript.