In the query text region, add the condition
After the “=” sign, right click on the mouse and you will see a list of Dashboard parameters.
The parameter p31 is the parameter_id referenced within the dashboard, In the sub-menu you will see the available columns from the parameters. In this case you should see the product description and product_key.
Select the product_key from the sub-menu. Your final query should look like below
Click on “Apply”
Now change the product selection to ‘Pulp Fiction’
As you have noted above, the product keys in the Sales Fact does not serve any purpose.
Continued… We will now add some dimension descriptions in the Fact portlet