Hi team,

I'm running into some issues with Time Ranges, and I tracked it down to an improperly loaded TIME dimension. Here's what I mean:

I have a custom Time Dimension that has four years worth of dates, for Year, Quarter and Month (2007, 2008, 2009, 2010). No problem there.

When I do this request, I only see values for 2009:

 
TABLE FILE CALENDARS
PRINT *
END

If I reload the Time Dimension, it refreshes the DIMENSIONS table, but then throws up this error:

*** EXEC error. Failure retrieving Calendar Source Data .Error in dimensions loader time routine #05: S06_A

Viewing the source of the error contains these interesting lines:

  

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$  Next set of cases is for updating the calendar table
$$  This must run *after* we have updated the TIME view and all the MFDs since dim_loader_time05
$$  relies on correctness of the Time MFD.
$$  We clear out the calendar table and do a full refresh from the source data
.
.
.

ErrorMsg_Display = "*** Database error.  Could not fetch existing Calendar data." ;
.
.
.
ErrorMsg_Display = "*** Database error.  Could not clear out existing Calendar data." ;
.
.
.
ErrorMsg_Display = "*** Database error.  Could not insert new Calendar information" ;

I thought this might be a database permissions error, but I proved that wasn't the issue by switching to an autogenerated Time Dimension. When I do that, the CALENDARS table gets all the years entered that I put in the Autogeneration parameters. If it was permission related, it wouldn't be able to write to the table at all, would it?

Switching back to the Custom Time dim still results in the same error.

I might need to open a case, but I tend to always try here first.

Cheers,

Joey
PMF 5.1.3
WebFOCUS 7.6.8
Oracle db
Windows Server
IIS & Tomcat

This message has been edited. Last edited by: Moogle,

Hey Joey-

It's not clear to me why you would want to use external calendar if you're doing plain Year, Quarter, Month, but you must have some good reason. Check in the MFD that you're using to load your external Time data. Are the Formats for Year, Quarter, and Month respectively A4, A1, and A2? If they are not, then please try changing and try again.

If that's what you already have, then open up a case and we'll figure out what's going on.

EricH

Hi Eric,

I had some formats that had V in them, such as A2V. That solved this problem, thank you very much.

The reason for the custom time dimension is laid out in this post; it's the same client:

http://forums.informationbuild...461084022/m/98610495

Cheers,

Joey

This message has been edited. Last edited by: Moogle,