Dashboards, Applications & Business Intelligence

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