Skip to Content
0
Former Member
Mar 07, 2014 at 02:22 PM

Problem loading data into SSM from oracle

28 Views

Dear Experts,

In SSM 10.0, Iam trying to load data into PAS measures from oracle schema and tried writting procedure as follows,

CLEAR STATUS

SET PERIOD Mar 2013 - Mar 2014

SELECT VAR KPI3_ACT
SELECT DIM GEOGRAPHY BRANCH
ACROSS Variables DOWN Time,GEOGRAPHY
ACCESS LSLINK
CONNECT Amit

SELECT Month as time,GEOGRAPHY,kpi3_act from SALES

Peek only 5

lss create GEOGRAPHY = Geography
lss create time = Month
READ

---------------------------------------------------------------

getting following issue on executing these commands:

Record 1:

GEOGRAPHY: AHMEDABAD is Not a Selected Member of GEOGRAPHY

Record 2:

GEOGRAPHY: MUMBAI is Not a Selected Member of GEOGRAPHY

Record 3:

GEOGRAPHY: BANGALORE is Not a Selected Member of GEOGRAPHY

Record 4:

GEOGRAPHY: MUMBAI is Not a Selected Member of GEOGRAPHY

Record 5:

GEOGRAPHY: AHMEDABAD is Not a Selected Member of GEOGRAPHY

0 Record(s) Read , 5 Record (s) Skipped

Table structure is for reference.

Can anyone please help me with this.

Thanks & Regards,

Nagajyoti G

Attachments

table.JPG (22.1 kB)