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.

Hey Greg,

Can you do a sample data on your Source?

EricH

Yes I can, 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.

Thanks, EricH. I was reviewing the docs last night and saw what you pointed out.