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

Holiday inclusion

Started by KEKeogh, 06 Jan 2011 01:32:43 PM

Previous topic - Next topic

KEKeogh

In the back end somewhere there is a table that has the company holidays listed to feed one of the company's websites.

Unfortunatley somewhere Cognos uses this for the one set of data and will not pull information for any date listed as a holiday.  For example Martin Luther King Day 1/17/2011 is a company holiday and Cognos will not pull information for that day.

Is there a way that I can list those holidays in a report and tell it to include those?  Or is this something I'm going to have to dig deeper with the database team?

Any ideas would be appreciated.

Kathie

PS: I have a very basic knowledge of coding.

MFGF

It all depends on how the mechanism to filter your results has been set up.  If it has been done in the Framework Manager metadata layer, you will need to get a modeller to set up an unfiltered version of the query subjects and publish these into a package you can use.  If it has been done in the database (by means of views, for example), then you would either need a database-savvy person to modify the views (or create new ones), or use the underlying tables in your metadata layer instead.

Without knowing more about how things are set up in your situation, it's hard to be more specific, sorry.

Regards,

MF.
Meep!