Wiring the Dashboard Portlet with Parameter

In the previous post, we saw how to add a fresh parameter to the dashboard. We will continue and create a link between the parameter and the portlet (Qlet)

Click on the “Sales Fact” qlet and select “Edit”
select_sales_portlet_and_edit.png

In the query text region, add the condition

“and f.product_key=”

After the “=” sign, right click on the mouse and you will see a list of Dashboard parameters.

add_product_link_to_sales_fact.png

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

sales_fact_query_after_product_dimension.png

Click on “Apply”

You should see the results as shown below. As you see, the Sales Fact is showing results only for “Beautiful Girls” product selection (all the product_key =1 ).
sales_fact_results_for_product_beautiful_girls.png

Now change the product selection to ‘Pulp Fiction’

sales_fact_results_for_product_pulp_fiction.png

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

Leave a Comment