Adding Time dimension to Dashboard

In the previous section we demonstrated on how to add the parameter description.

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)

basic_time_dimension.png

We will extend the basic Time dimension to include the month and the year columns

time_dimension_with_month_year.png
Click on the new parameter button (follow the detailed steps of adding the Product dimension)

time_parameter_final.png

Click on ‘Apply’

You should see the Time dimension added to the dasboard

sales_fact_with_product_and_time.png

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

connect_time_dimension_to_sales_fact_selecting_time_key.png

Your final ‘Sales Fact’ query should look similar as shown below

sales_fact_query_after_time_dimension.png

Click on ‘Apply’ and you should see a more restricted list in the Sales Fact portlet.

sales_fact_query_results_after_product_time.png

Concluding the Dashboard creation process with the Store Dimension and enabling ‘All’ values