Skip to Content
0
Former Member
Apr 08, 2014 at 10:03 AM

Issues with load from Excel

38 Views

Dear all,

I have issues with loading the data from excel.

My excel file looks like this:

Time

Store

Neto_prodaja_ACT

Neto_prodaja_TAR

Jan-12

C1

16

16

Feb-12

C1

2

2

Jan-12

C2

1

1

Feb-12

C2

3

3

My procedure for load is:

CLEAR STATUS

Across Var Down Time, Store

Sel Neto_prodaja_ACT, Neto_prodaja_TAR

Sel Store Input

access lslink

connect test1

select * from my_list

peek only 10

read

end

When I load the data I receive following error:

Time Store Neto_prodaja_ACT Neto_prodaja_TAR

1 01/01/2012 C1 16.00 16.00

2 02/01/2012 C1 2.00 2.00

3 01/01/2012 C2 1.00 1.00

4 02/01/2012 C2 3.00 3.00

4 Record(s) Read, 0 Record(s) Skipped.

DAT096:

Unexpected Dimensions in ACROSS/DOWN List For Variable NETO_PRODAJA_ACT

DAT096:

Unexpected Dimensions in ACROSS/DOWN List For Variable NETO_PRODAJA_TAR

The loaded data looks like this:

The data for store C2 is loaded also on store C1 so everything is messed up.

I also have a question regarding dimensions. I have a model in PAS which has data from different data sources (BW and excel). In excel I have dimensions which are not loaded from BW (they don't exist there). How to create such dimenison?

Thank you a lot in advance.

Best regards,

Petra