Calendar Drill Down issue

[rathnam_qv]

Hi All,

I have created a drill-down group like Quarter-->Month-->Date.(Have data only for Current year).

But Quarter is not coming in the drill only Month-->Date is working fine.

What will be the reason for this.

Any help is appreciate.

Thanks,

Muni.

[niclaz79]

Hi, this would happen if the quarter is not properly defined in your model or if it's not available based on your other selections. Could you provide more info on your model itself?

[rathnam_qv]

Hi Niclas,

I am using single table not joining any other table to it and i am using a DATE filed and calculatin Quarter,Month from it.

Thanks,

Muni.

[niclaz79]

Is there a chance you can provide the script for calculating the quarter, or even the application itself? It's much easier to click in an actual application to find out where it goes wrong.

[rathnam_qv]

Sorry Niclas...i can't share either query or app.

[niclaz79]

Ok, then without any screenshots, code or other information it's where hard to figure out what has gone wrong.

[rathnam_qv]

Hi Niclas,

PFB logic which i am using to extract Year,Quarter and Month.

Year(Date_Field) as Year,

'Q' & ceil(month(Date_Field)/3) as Quarter,

Month(Date_Field) as Month,

Thanks,

Muni.

[Digvijay_Singh]

Do you have a single quarter in your data? Currently there is a bug in drill down design, it skips the dimension and goes to the next one automatically if there is only one value selected or available for that dimension.

[Digvijay_Singh]

Drill down issue for one possible value

[rathnam_qv]

Yes, Digvijay...i have only single quarter (for 2018).

Is that an issue?