Drill-down

[#1]

Hi all,

What can be the reasons of a drill-down not working?

I got one that isn't working and I was not able to find any info on this topic. So what can be the reasons of a not working drill-down? An Expression that is blocking it? Month/year a dimension?

kind regards,

Vincent

[its_anandrjs]

A dimension is reason for that if your data model is built according to drill down then you are able to use that.

Eg:-

Easy example

Reason \ Country \ State \ City

if data model is like that then you are able to drill down it with lowest level.

Regards

[#3]

I got like:

Divisionname, week, year, weekday as dimensions

Then drill down = productiondriver, productioncountry, productionfleetnumber

Expression:avg(Production.DrivingGrossDurationHrs)

I can't drill down however.

[pwd]

The fields need to have more than one possible value in them, after taking the current selection into account. Otherwise it will drill down to the next field in the list automatically. Other than that there are no obvious reasons for why a drill-down would not work, maybe post an example file?

[its_anandrjs]

If the association among the fields that you asking about here like Divisionname, week, year, weekday and if you select Divisionname and drill to week and if week value has info about division name then it will drill otherwise not drill take a look for example.

DivisionTable:

Divisionname, DivID,TransactionDate

Div1,d1

Div2,d2

Div1,d3

MasterCalender:

week, year, weekday,TransactionDate

In master calendar TransactionDate is here and by this date DivisionTable table connected then if you make a chart with dimension

Divisionname, week, year, weekday

and Exression

avg(Production.DrivingGrossDurationHrs)

It will easily drill down to the lower level.