Hi experts,
I am trying to load data into PAS using an Excel File and a Procedure
The procedure I am using is this one:
CLEAR STATUS
SET PERIOD Jan 2009 - Jan 2011
SELECT Dim Geografica INPUT
SELECT Var KPI22_ACT, KPI22_TAR
ACROSS variables DOWN Geografica, Time
ACCESS lslink
CONNECT Excel1Link
SELECT * FROM DATOS6
PEEK only 10
LSS CREATE GEOGRAFICA = GEOGRAFICA
READ
END
The link is correct, and I am accesing to a region of the Excel Sheet with this data
GEOGRAFICA TIME KPI22_ACT KPI22_TAR
AREA1 Jan-10 35 40
AREA2 Feb-10 45 38
AREA3 Mar-10 7 7
AREA4 Mar-10 5 90
When I launch the procedure using the JOB statement in the IDQL console, everthing goes all right, but the data are not read into the systems.
I get the following Message
Across List: # Selected
VARIABLES 2 ...
Down List:
GEOGRAFICA 7 of 11 AREA1, AREA2, AREA3, AREA4...
TIME
Record: 1
GEOGRAFICA: AREA1 is Not a Selected Member of GEOGRAFICA
Record: 2
GEOGRAFICA: AREA2 is Not a Selected Member of GEOGRAFICA
Record: 3
GEOGRAFICA: AREA3 is Not a Selected Member of GEOGRAFICA
Record: 4
GEOGRAFICA: AREA4 is Not a Selected Member of GEOGRAFICA
It seems that the data are not read because I haven´t selected the INPUTs of the dimensiones, but I think I have.
What am I doing wrong? Any ideas?
Thanks in advance