We will continue adding the Time dimension.
Here is a basic time dimension query (In the figure below, it is displayed as a Qlet and not as parameter)
We will extend the basic Time dimension to include the month and the year columns
Click on ‘Apply’
You should see the Time dimension added to the dasboard
We will now link the Sales Fact to the Time dimension (wiring with Time dimenion)
Edit the Sales Fact portlet
In the Query region, add a condition ‘and f.time_key = ‘
After the ‘=’ sign, right click and select the Time parameter key value from the sub-menu as shown below
Your final ‘Sales Fact’ query should look similar as shown below
Click on ‘Apply’ and you should see a more restricted list in the Sales Fact portlet.