Add parameter description to Sales Fact portlet

In the previouse section, we saw how we linked the product dimension to the sales fact.

We will tweak the Sales Fact query to include the product description as below.

Edit the Sales Fact portlet (qlet)

In the Query region, click “Enter” after the select keyword

Right click and pick the product description value from the sub-menu as shown below

sales_fact_add_product_description.png

Your final Query should look similar to below

sales_fact_modified_query_with_product_description.png

As you noticed, we removed the f.* and replaced with individual column names.

Click “Apply”

You should now see the product description in the Sales Fact as shown below

sales_fact_with_beautiful_girls_description.png

sales_fact_with_pulp_fiction_description.png

Continued… Now we will add the Time Dimension as parameter