Sales Fact - Parameter Description

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

Next