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

problem in cross tab report/ working days

Started by johny.cbi, 30 Jan 2008 02:18:52 PM

Previous topic - Next topic

johny.cbi


Source: cube 

Daily average report

There is a cross tab report. In that report there are two columns current year, previuos year
and a row woking days
I need the average sales report till  previous business day
(for eg: Today is wednesday, I need the data in the report up to Tuesday)
problem:

for 2007 working days are showing correct when I run the report

but for 2008 working days it is showing one day more

please share your ideas


Suraj

Can't say what's going on without looking at your source and queries.
But if it is more by a day for 2008, then create a data item that adds 1 day when year = 2008.