How to Select a Member Using a Variable Text Input

This article will demonstrate how a Variable text input can be used to select a member.

In this example, the Variable will allow to select a customer using text input by either entering the customer name or ID (depends on how the customer is stored in the cube)

1.  Create a text box Variable by clicking the Text Box button in the Extensions tab.


2.  Give it a name and set a default value (either an ID or a customer name)


3.  Create a set that will add the input made in the Variable to the hierarchy to create the full member name. For example:
{STRTOSET ('[Customer].[Customer].&['+ '[Variable].[!##customer_ID##!]'+']')  } 


4.  Add this set to the query.

5.  The final result will allow to type an ID in the Customer_ID Variable and the corresponding customer will appear on Rows.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 5 yrs agoLast active
  • 464Views
  • 1 Following