SSM - Entry/Approval and PAS Question

[Former Member]

I need help understanding why data isn't loading into PAS using E&A.

I created a very simple model in cubebuilder with two variables, variable1 and variable2 (KPI1 and KPI2 for shortnames in PAS). The cube built successfully and I can see the variables in PAS - these are NOT dimensioned:

Variable Type Items Date Range

KPI1_ACT NU S MO

KPI1_TAR NU S MO

KPI1_TARDEV NU N UN

KPI1_TARDEV = KPI1_ACT%KPI1_TAR

KPI1_TRD NU N UN

KPI1_TRD = MOVING2(KPI1_ACT,1)

KPI1_TRDDEV NU N UN

KPI1_TRDDEV = (KPI1_TARDEV-MOVING2(KPI1_TARDEV,1,3))%MOVING2(KPI1_TARDEV,1,3)

KPI2_ACT NU S MO

KPI2_TAR NU S MO

KPI2_TARDEV NU N UN

KPI2_TARDEV = KPI2_ACT%KPI2_TAR

KPI2_TRD NU N UN

KPI2_TRD = MOVING2(KPI2_ACT,1)

KPI2_TRDDEV NU N UN

KPI2_TRDDEV = (KPI2_TARDEV-MOVING2(KPI2_TARDEV,1,3))%MOVING2(KPI2_TARDEV,1,3)

R=Rate U=Units F=First L=Last (W)(X)A=(Wtd)(Exc)Average N=Nocon S=Sparse D=Drillthru

The model connections are created within the admintool. I went into Entry and Approval setup and create a one-step process (Data Entry only) for one period (so current data and date ranges all set to Oct 08) using pipadmin for the administrator. I create a model set in Entry and Approval, select variable1-actual and variable1-target and make pipadmin the data entry person. I release the metrics set, enter a value for the target and actual data for oct. 08 for variable1. Then I go back to the main screen and load PAS data.

When I go into PAS, I don't see any data loaded.

System> set period oct 2008

System> exh var kpi1* both

KPI1_ACT variable1-Actual

KPI1_TAR variable1-Target

KPI1_TARDEV variable1-Score

KPI1_TRD variable1-Trend

KPI1_TRDDEV variable1-Gap Performance

System> sel kpi1_act, kpi1_tar

2 Variables Currently Selected

System> across time down var

Across List: # Selected

TIME

Down List:

VARIABLES 2 variable1-Actual, variable1-Target

Period 2008/10/1 - 2008/10/31 Earliest 01 Jun 2008

Latest 31 Dec 2008 (MO)

Attached Databases: ROBB User: ADMIN

System> disp

0 Pages of Data Printed

What am I doing wrong?

[Former Member]

I discovered in the trace file that the following message was appearing:

[SAP AG][SQLOD32 DLL][MaxDB] Invalid authorization specification;-4008 POS(1) Unknown user name/password combination

SQLSTATE: 28000

SQL System code: -4008

Sou2026 I went back to MaxDB SQL Studio and logged in as the user to double check the U/P combination and it worked fine. I re-entered the correct password in the linkid connection and it tested successfully.

However u2013 when I went into PAS and did the following:

System> access lslink

Access pilot link> conn ssm_cb_ea

[SAP AG][SQLOD32 DLL][MaxDB] Invalid authorization specification;-4008 POS(1) Unknown user name/password combination

SQLSTATE: 28000

SQL System code: -4008

I got the error msg again. So I created a new u201Ctestu201D linkid and went into pas u2013 and it connected no problem.

Sou2026 I removed the linkid and recreated, and it worked! Not sure what was amiss.