Write dimension descriptions to a text box – one per line
Using a chart, button and text box – when you click the button the result should be as per below
Write dimension descriptions to a text box – one per line Read More »
TABLES KB PAGE
Remove numeric format from all values in a table
Set number format to Unformatted with 2 decimal places
Remove numeric format from all values in a table Read More »
Format all numeric values in a table
Set number format to Millions with 1 decimal place
Format all numeric values in a table Read More »
Drill up & down a hierarchy in a table using buttons
An alternative way to allow users to drill up down hierarchies in a table (or chart) Script to drill down Script to drill up
Drill up & down a hierarchy in a table using buttons Read More »
Flatten the hierarchy of all dimensions present in a table
‘__FLAT__’ is a scripting parameter
Flatten the hierarchy of all dimensions present in a table Read More »
Set all members in a table to description display mode
This script is used in a table OnResultChanged event We have to include logic to check the current MemberDisplayMode, otherwise the script would loop indefinitely
Set all members in a table to description display mode Read More »
Write all measure values from a table to the browser console
This code could be placed in the onSelect event of a button
Write all measure values from a table to the browser console Read More »
Display the selected Dimension Member or Measure value in a text box
This has limited use – the code below will only work with a table containing 1 dimension & 1 measureWhen a user clicks a cell in the table, the clicked value will be displayed in a text box. The Script below is placed in the ‘onSelect’ event of a table
Display the selected Dimension Member or Measure value in a text box Read More »
Retrieve a Dimension Member Description from a table
This code will take the clicked (selected) dimension member description from a table in much the same way as we did for measure values. However – it’s only really suitable for a table containing 1 dimension,the reason being if there were multiple dimensions we have no way of knowing which dimension member cell a user
Retrieve a Dimension Member Description from a table Read More »