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
Your final Query should look similar to below
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
Continued… Now we will add the Time Dimension as parameter