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