If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill down Month-Date doesn't display empty columns

Started by Azzoz06, 04 Jan 2016 08:08:27 AM

Previous topic - Next topic

Azzoz06

Hello,

Using a DMR model, my report shows a combination chart of monitor sensor values (series) and month (categories). Drilling on the month (to the date) works but doesn't display the dates where there are no sensor values. I'd like to have all dates shown on the x-axis with no bar shown (see picture and notice December 1, 4, 8... are missing).
In the model I have a left outer join between my time dimension table and my daily fact table. I have tested this on a non DMR model and it works fine but I can't find a way to have the dates displayed using DMR.

Any suggestion?
Thanks for your help.