Apply a Top & Bottom rank in the same chart
This script allows users to display the Top & Bottom n results in the same chart, in this case Top & Bottom 3Sales Mangers by Quantity Sold.
Apply a Top & Bottom rank in the same chart Read More »
FILTERING KB PAGE
Write Single Dimension Filter value to a text box
Writes the filter value applied to a dimension to a text boxThis code will display either the included or excluded dimension value in a text box.
Write Single Dimension Filter value to 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 »
Retrieve a single measure value selected by a user in a table
This script is useful for capturing the measure value clicked by an end user in a table.I typically use this logic to capture a value and pass it as a filter elsewhere. The Script below is placed in the  ‘onSelect’ event of a table Extra line of code to write the value to a text
Retrieve a single measure value selected by a user in a table Read More »
Use the first & last result / row value from a table as a filter
I had a requirement to filter a chart on the highest and lowest value shown in a table.The table was sorted by measure value Z-A, so the first and last row will always be the highest and lowest.
Use the first & last result / row value from a table as a filter Read More »
Filter to show the first row in a table
This script will dynamically filter a table to show whatever value is present in the first row The Script below could be placed in a button for example
Filter to show the first row in a table Read More »
Filter a Chart or Table using a Check Box Group
In this example the checkbox group is populated with members of the ‘Sales Manager’ dimension from the sample Best Run Juice model.This article shows how to populate a checkbox group with alphanumerically sorted dimension members Populating checkbox groups article The Script below is placed in the onSelect event of the Check Box Group
Filter a Chart or Table using a Check Box Group Read More »
Apply a filter using resultset values
The script is placed in the button, when clicked it passes the values from Table_1 & applies them as a filter to Table_2
Apply a filter using resultset values Read More »
Filter a table using a search string entered in an Input Field
This script allows users to filter a table by entering a search string in an Input Field.You could enhance this to search for Strings that exactly match the entered value, in this example we filter on values that include the search string anywhere in the Dimension Member description.
Filter a table using a search string entered in an Input Field Read More »
Filter excluding specific values (all values are returned except those specified)
In this example we filter the table to show all ‘Sales Managers’ except the 2 specified. You will need to know the member ID’s of the dimension members. In this example SM1 & SM2 are the Sales Managers – Janet Bury & Lois Wood This KB shows you how to log the dimension members to
Filter excluding specific values (all values are returned except those specified) Read More »