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

Current Period suddenly quit working correctly

Started by j_wilcox, 13 Jan 2010 12:30:50 PM

Previous topic - Next topic

j_wilcox

Cognos 7.4

I have a Transformer model that's suddenly stopped working.  We build a cube monthly - last month's was fine, this month's is wrong. 

I've been researching but haven't found a working solution.  I've rebuilt the cube manually by setting the Current Period by hand so my users have their data, but I need to find and fix the actual problem in the model.

The Current Period in the cube should be Dec 2009.  Instead it's showing as June 2009.

The originating data is extracted on the first for the previous month, so only goes through the last day of the month.  The transaction data for the model comes from two IQDs, which run for dates 2006-07-01 to 2040-01-01.  I've checked the actual data for this cube and it shows data through Dec 2009.  (I ran the IMRs with matching dates, and checked one query output in Transformer's View Source Data.)  The query files haven't been modified in the last year.

The model hasn't been updated since May 2008, by the file date.  It has one Date dimension, with Fiscal Year and Month, and Calendar Year as an alternate drill path.

The dimension earliest date is 1/1/1901 and latest date is 12/31/2100.  The 'Automatically set the current time period' is checked.  There's nothing in the Current Period display box when the model is opened; after building a cube, it shows June 2009.

When I originally looked at the model, it had all the datasources checked for 'Sets current period' (including the two rollup sources with no date data).  I've tried various combinations since, from none checked to all four checked - all get the same result (June 2009 for Current Period).

The date dimension does have several relative categories: Current Month, Last Month, 13 rolling, 24 rolling, Current & Prior Year & Month.

The Fiscal Year primary drill category is set to SUPPRESS, with year beginning 20010701.  The Calendar Year alternate drill is set to Default (always include) and begins 20010101.

The Current Month relative category is set to Current Month based on Fiscal Year.

I've tried saving the MDL file to PYI and back, as I know that sometimes unconfuses things.  I've checked the Transformer preferences - Enable Lunar Fiscal Labelling is NOT checked.

Any suggestions on what else I could try?  I'm completely stumped, other than to start from scratch and rebuild the whole model (yech!).

Thanks!

atnaatna

In short, you should only have one data source that sets the current time period.  So in your case it would be the data source that has a date value with the Dec/09.

But in some cases, we may need to force the current month to be a date that we don't have data in.  So what I do is if I would like the current month special category to be the month that the cube was refreshed in, I would do the following:

1. Insert a dummy data source, just make it reference a text file
2. Create a column and name that column the same name that is used to create your time dimension
3. Set this column to be a calculated column
4. Set the calculation to be "today"
5. Make the new dummy data source set the current time period by checking off "Sets the current period" setting

Hope this helps, I wish I could post a picture to show you what I mean.

MFGF

#2
Quote from: atnaatna on 27 Jan 2010 01:47:00 PMHope this helps, I wish I could post a picture to show you what I mean.

You can - upload the picture to a site such as imgbb.com, then copy the IMG tags from below the picture and paste into your Cognoise post.

Regards,

MF.
Meep!