Skip to Content
1
Former Member
Feb 11, 2016 at 10:51 PM

how are dimension filters in design studio applied at runtime?

154 Views

BObj 4.1, SP 5

Design Studio 1.5, SP 2

Source : Relational Information Design Tool universe

Database : Oracle

Greetings et al.

Question: How is a dimension filter actually applied by Design Studio at runtime? For a dimension filter to be applied to a anayltic component, does the dimension from the dimension filter need to be in the data source for the analytic component as a retrieved column?

I have looked for an answer to this in the SCN archives and the internet generally with no luck. Please jump in.

I am creating a Design Studio dashboard with trend charts for average cycle times by half, quarter, month and week. The averages are accurately calculated on the fly in the IDT universe by summing the cycle times for the selected slice of data and dividing by the number of rows returned.

I also need to be able to filter the graphs based on a few dimensions, so I added dimension filters. I created a separate data source for each dimension and then set all of the data sources for the graphs as target data sources for the filters. The correct filter values are showing up in the selection popup.

Does anyone know the behavior under the covers when a dimension filter is applied?

Assuming a base select statement (as created in the background by DS and IDT) of:

select month, average_ct from my_table

where month >= start_month and month <= end_month;

I would assume that applying a filter would do this:

select month, average_ct from my_table

where month >= start_month and month <= end_month

and dimension = selected_value;

which would still return accurate averages.

The results I am currently getting - apprarently summing the averages - leads me to believe that the backend may be doing something like this:

select month, average_ct, dimension from my_table

where month >= start_month and month <= end_month

and dimension = selected_value;

Any assistance greatly appreciated.

Jeff