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

[RS],[AS] dynamic report

Started by golep, 20 Jun 2007 05:27:19 AM

Previous topic - Next topic

golep

I need to get report like this: current day, same day last week, current month, last month this column will represent average value for some measure.
Another request is: if current day is eg. Monday in columns current month I have to present average values just for Mondays in current mont, same for previous month it should show average value for all Mondays in previous month.

I have produced this report putting  Monday in context/slicer, and it is OK.

Question: how to prepare this report in daily changing manner? Idea is to check current day and change context, but how to automate this procedure without any prompts? Any ideas?