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
Well, to answer my own question, the relative time function I needed was Last Quarter, not Prior QTD