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

Strange Relative Time problem

Started by Arsenal, 04 Aug 2008 02:16:04 PM

Previous topic - Next topic

Arsenal

Hi All,

Just changed the databases on one of our cubes. Did all the required IQD changes etc. Cubes build fine. But Prior MTD and Prior QTD don't seem to want to pick up the dates from the database.

The months by themselves have data, but Prior MTD and Prior QTD don't bring up any results on Analysis Studio, although if I drag 2008 Q2 and drop it in the context, it shows data.

I checked all the settings such as only one datasource setting current period, Always Include etc...everything checks fine. Even funny, the same cube on a different database does have working Relative Time categories.

Any suggestions? Thanks

Arsenal

Well, to answer my own question, the relative time function I needed was Last Quarter, not Prior QTD