Disable drill down at specific level?

[linhlv]

Hi every one,

I'm facing a problem in Cognos Report Studio 8.4.1. I want to creating a report about Sales Revenue by Branch. I have two dimensions: Branch and Time (Year > Quarter > Month > Day) and a measure: Sales revenue. But in my data, I have only data about Sales Revenue by Branch and Quarter. And then, I create Scope Relationship in Framework Manager between Time dimension (at Quarter level) and measure. The problem is When I drill in Time (from Year level), at the Month level there're no data, so I can not drill up to Quarter level.

Does anyone have any suggest to disable drill down at the Quarter level?

Thanks in advance.

[Shailaja0520]

if this is what you want to show,You can create a custom dimension (Regular dimension) in FM and define only those levels what you need.