Skip to Content
0
Former Member
May 13, 2010 at 09:22 AM

Load data to SSM using Excel File

42 Views

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