Focal Point
Time dimension external file load error

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/7627011616

January 31, 2012, 02:57 PM
gregv
Time dimension external file load error
Has anyone run into this?

I defined Time dimension to use an external table with a KEY of A10 (year(a2),quarter(a2),month(a2),week(a2)).

And I get the following error when I click Save or Preview.

Error S02 in pmf_dim_ldr_time_reg -Error S05 in pmf_dim_ldr_look, FOCERRNUM: 9

I looked at this code but can’t find anythin that leads me to a solution.

TIA.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
February 01, 2012, 10:45 AM
EricH
Hey Greg,

Can you do a sample data on your Source?

EricH
February 01, 2012, 01:57 PM
gregv
Yes I can, EricH.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
February 02, 2012, 09:21 AM
EricH
The MFD for the external table has to be in a very specific format. I would suggest reviewing the documentation to make sure you have all the necessary columns - for example you need a START_DATE and END_DATE.

Also, it looks like you're making quarter an A2. Try making this an A1 in both your MFD and the external file.

If you're still stuck, open up a case with Customer Support and we'll get to the bottom of this.
February 02, 2012, 09:29 AM
gregv
Thanks, EricH. I was reviewing the docs last night and saw what you pointed out.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8