Drilldown in reports

[Former Member]

Hi

I have few doubts about drilldown option in query designer

1.how do we decide which characteristics should be part of drilldown menu in reports given to users?

2.Once we know which charcateristics should be part of drilldown menu in reports,where do we place these characteristics in Query Designer while creating query?

3.what is the significance of 'Free Characteristics' and 'Default Values' boxes in Query designer and in which situations do we use them?

Thanks alot.

[former_member186082 · Accepted solution]

Hi Simon,

1 & 2. It completely depends on user requirement. Accordingly we design the queries considering performance.

For example if user requirement is to generate Sales report of 1 year for every day (0CALDAY), it is not advisable to include 0CALDAY in Rows. Hierarchy should be used, first loading month data (0CALMONTH), then drilldown based on week (0CALWEEK) and then days (0CALDAY)

Including characteristics on Rows/Filters also depends on the requirement.

3. Free characteristics : If you want some characteristics to not be included in the default view of the query, but still be available for drilldown if needed are to be placed here.

Ex : Time characteristics included in free characteristics will not be shown in the default run of the report. But futher drilldown is possible for these variables.

Default Values : The default values for which the query should be first executed.

Ex : If 0CALDAY is included in Free Characteristics and default value is fixed to some value, default run of the report will fetch data for that value of 0CALDAY

Regards

Chandu