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.
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.