When you want to filter the table data based upon the selected value in prompt
For example ,I have a table called SRC_ORDER_LINES it will show Sales amount and Order quantity based on order_id.My requirement is in dashboard i want to filter whole table data based on the VALUE(Order quantity) selected in Prompt
1) Create a session variable initialization block with following query
For example ,I have a table called SRC_ORDER_LINES it will show Sales amount and Order quantity based on order_id.My requirement is in dashboard i want to filter whole table data based on the VALUE(Order quantity) selected in Prompt
1) Create a session variable initialization block with following query
2) Next,variable creation and assign the above initialization block to this newly created variable
3) Double click on Variable qty,check in "Enable any user to set the value"
4) We need to add this session variable to the "BMM layer Content Level Filter" in order to filter the table
5) Double click on LTS(Logical Table Source) of SRC_ORDER_LINES click on content tab we need to give the condition under "Using where condition to filter out row counts"
5) Double click on LTS(Logical Table Source) of SRC_ORDER_LINES click on content tab we need to give the condition under "Using where condition to filter out row counts"
6) Coming to answers create a prompt and declare a request variable with same name as session variable "Qty"
7) Add the prompt to dashboard and its respective report .when you select value of quantity as 1500 then the SRC_ORDER_LINES will limit the rows like where qty >1500,it will retrieves only those records
Below figure shows
Quantity >1341 records
Below figure shows
Quantity >1341 records
Quantity >1881 records
Posts
