Information loaded with procedure in SSM 7 Application Server gets lost.

[Former Member]

Hi everybody, i'm working with procedures inside SSM App Server (model administrator), in order to load data into a scorecard.

The procedure works fine, after running it I look at DataView TAB, and the information loaded is there, but when I change to another model inside que APP server , and return to my model, the information is not there!!!

Am I missing a step for the information gets commited or updated to database? Please review this simple procedure below that I'm using.

Another weird thing is hapenning, is that I have to put dimension members names like "L0M1258302262921" instead of the real values (inside my datasource table), that's because if use real values, the IDQL compiler shows me an error like this:

PAIS: 502 is Not a Selected Member of PAIS (where 502 is the real member value)

and don't load any data.

thanks for your help!

... /////////////////// PROCEDIMIENTO CARGA DE PARQUE LIMPIO //////////////////////////////

CLEAR STATUS

... SET DATE DMY

... SET PERIOD MONTHLY

SET PERIOD 01-JAN-2009 - 01-FEB-2009

SELECT VAR KPI2_ACT , KPI2_TAR

SELECT PAIS INPUT

SELECT CANAL INPUT

SELECT PRODUCTO INPUT

SELECT SERVICIO INPUT

ACROSS VAR DOWN PAIS, CANAL, PRODUCTO, SERVICIO, TIME

ACCESS LSLINK

CONNECT claro

select PAIS, CANAL, PRODUCTO, SERVICIO, convert(varchar,fecha,103)as time, PARQUE KPI2_ACT , TARGET KPI2_TAR from dbo.kpi_altas

READ

END

-

---

RESULT OF THE PROCEDURE AT IDQL WINDOW -

---

System> job carga_parque_limpio

LSS> ... /////////////////// PROCEDIMIENTO CARGA DE PARQUE LIMPIO //////////////////////////////

LSS>

LSS> CLEAR STATUS

LSS>

LSS> ... SET DATE DMY

LSS> ... SET PERIOD MONTHLY

LSS>

LSS> SET PERIOD 01-JAN-2009 - 01-FEB-2009

LSS>

LSS> SELECT VAR KPI2_ACT , KPI2_TAR

2 Variables Currently Selected

LSS>

LSS> SELECT PAIS INPUT

5 Members of PAIS Selected

LSS> SELECT CANAL INPUT

4 Members of CANAL Selected

LSS> SELECT PRODUCTO INPUT

3 Members of PRODUCTO Selected

LSS> SELECT SERVICIO INPUT

4 Members of SERVICIO Selected

LSS>

LSS>

LSS> ACROSS VAR DOWN PAIS, CANAL, PRODUCTO, SERVICIO, TIME

Across List: # Selected

VARIABLES 2 PARQUE LIMPIO-Actual, PARQUE LIMPIO-Target

Down List:

PAIS 5 of 6 502, 503, 504, 505, 506

CANAL 4 of 5 MASIVO, CORPORATIVO MASIVO, CORPORATIVO ESPECIAL...

PRODUCTO 3 of 4 PREPAGO, POSTPAGO, MULTIMEDIA

SERVICIO 4 of 5 MOVIL, LINEA FIJA, TURBONETT, HIBRIDO

TIME

Period 2009/1/1 - 2009/2/1

Attached Databases: CLARODES, APLIB, SMREPORT User: ADMIN

LSS>

LSS> ACCESS LSLINK

LSLink> CONNECT claro

LSLink>

LSLink> select PAIS, CANAL, PRODUCTO, SERVICIO, convert(varchar,fecha,103)as time, PARQUE KPI2_ACT , TARGET KPI2_TAR from dbo.kpi_altas

LSLink>

LSLink> READ

9 Record(s) Read, 0 Record(s) Skipped.

LSLink>

LSLink> END

[Former Member · Accepted solution]

You have two questions.

PAS rejects 502 as a dimension member id because it is numeric. keys like "L0M1258302262921 are probably generated by the cube builder. You could create a key as "P502" and then use either the synonym table, or SQL constructs to convert the value "502" to "P502"

Concerning the vanishing data, what did you do to display it? Did you select the correct input members prior to listing? There were only 9 records read but 480 combinations of input members in your dimensions. Consequently most combinations would be empty.If your list command has not made a selection in a dimension, it will default to the result member, and that will give no data unless you have consolidated.

[Former Member · Accepted solution]

Cliff,

Even if I use char type dimension member values, I got the same error, please review below my procedure an result. How can you tell PAS to use de member values and not the SHORTNAMES generated by cubebuilder? if I use in my select sentence the column that stores thes shortnames (like "L0M1258302262921"), the load works fine, but if I select the column that has the correct dim member value, gives me the error for each record that I need to load: CANAL,PRODUCTO & SERVICIO are dimensions.

CANAL: CORPORATIVO ESPECIAL is Not a Selected Member of CANAL

PRODUCTO: POST-PAGO is Not a Selected Member of PRODUCTO

SERVICIO: HIBRIDO is Not a Selected Member of SERVICIO

The refresh data issue it's now working fine after the CONSOLIDATION process !!

thank you for your all cooperation !

-

---

PROCEDURE----

---

CLEAR STATUS

... SET DATE DMY

... SET PERIOD MONTHLY

SET PERIOD 01-jun-2011 - 30-jun-2011

SELECT VAR KPI3_ACT

SELECT VAR KPI3_TAR

SELECT PAIS

SELECT CANAL

SELECT PRODUCTO

SELECT SERVICIO

ACROSS VAR DOWN PAIS, CANAL, PRODUCTO, SERVICIO, TIME

ACCESS LSLINK

CONNECT claro

select PAIS, CANAL, PRODUCTO, SERVICIO, convert(varchar,fecha,103)as time, ALTAS KPI3_ACT , TARGET KPI3_TAR from dbo.kpi_altas

READ

END

-

---

IDQL RESULT----

---

ystem> JOB CARGA_ALTAS

LSS> CLEAR STATUS

LSS>

LSS> ... SET DATE DMY

LSS> ... SET PERIOD MONTHLY

LSS>

LSS> SET PERIOD 01-jun-2011 - 30-jun-2011

LSS>

LSS> SELECT VAR KPI3_ACT

1 Variable Currently Selected

LSS> SELECT VAR KPI3_TAR

1 Variable Currently Selected

LSS>

LSS> SELECT PAIS

6 Members of PAIS Selected

LSS> SELECT CANAL

5 Members of CANAL Selected

LSS> SELECT PRODUCTO

4 Members of PRODUCTO Selected

LSS> SELECT SERVICIO

5 Members of SERVICIO Selected

LSS>

LSS> ACROSS VAR DOWN PAIS, CANAL, PRODUCTO, SERVICIO, TIME

Across List: # Selected

VARIABLES 1 ALTAS-Target

Down List:

PAIS 6 502, 503, 504, 505, 506, TOTAL PAIS

CANAL 5 MASIVO, CORPORATIVO MASIVO, CORPORATIVO ESPECIAL...

PRODUCTO 4 PREPAGO, POSTPAGO, MULTIMEDIA, TOTAL PRODUCTO

SERVICIO 5 MOVIL, LINEA FIJA, TURBONETT, HIBRIDO...

TIME

Period 2011/6/1 - 2011/6/30

Attached Databases: CLARODES, APLIB User: ADMIN

LSS>

LSS> ACCESS LSLINK

LSLink> CONNECT claro

LSLink>

LSLink> select PAIS, CANAL, PRODUCTO, SERVICIO, convert(varchar,fecha,103)as time, ALTAS KPI3_ACT , TARGET KPI3_TAR from dbo.kpi_altas

LSLink>

LSLink> READ

Record: 1

PAIS: 502 is Not a Selected Member of PAIS

CANAL: CORPORATIVO ESPECIAL is Not a Selected Member of CANAL

PRODUCTO: POST-PAGO is Not a Selected Member of PRODUCTO

SERVICIO: HIBRIDO is Not a Selected Member of SERVICIO

Record: 2

PAIS: 502 is Not a Selected Member of PAIS

CANAL: CORPORATIVO ESPECIAL is Not a Selected Member of CANAL

PRODUCTO: POST-PAGO is Not a Selected Member of PRODUCTO

SERVICIO: HIBRIDO is Not a Selected Member of SERVICIO

Record: 3

PAIS: 502 is Not a Selected Member of PAIS

CANAL: CORPORATIVO ESPECIAL is Not a Selected Member of CANAL

PRODUCTO: POST-PAGO is Not a Selected Member of PRODUCTO

SERVICIO: HIBRIDO is Not a Selected Member of SERVICIO

Record: 4

PAIS: 502 is Not a Selected Member of PAIS

CANAL: CORPORATIVO ESPECIAL is Not a Selected Member of CANAL

PRODUCTO: POST-PAGO is Not a Selected Member of PRODUCTO

SERVICIO: HIBRIDO is Not a Selected Member of SERVICIO

0 Record(s) Read, 4 Record(s) Skipped.

LSLink>

LSLink> END

[Former Member · Accepted solution]

The load jobs (and all references in code) must refer to the short names. I tend to not use cubebuilder because the short names it generates are not likley to match those on my source systems.

As your database has long names the solution would be to create a synonym set for each dimension. The help file will show your the structure and how to use it. The synonym set provides a mapping of the external name (e.g. "POST-PAGO") to the internal name (e.g. "POSTPAGO"). You could cut and paste the dimension contents and that would give you a start towards the mapping.

I though your PAIS members shortname needed to start with an alpha, but the fact that your dimension compiles seems to show I am wrong on that one.

[Former Member · Accepted solution]

I want to thank all of you people that helps me in this case, as everyone said, the information is now loaded and can view it at SSM Scorecards, after using the CONSOLIDATE process, (below an example for help others with this same issue).

Cliff, the Synonym option was very usefull to solve the last trouble that I mentioned about matching external and internal DIMENSION members.

Certenly, I'll now continue with SSM 7.5 imlementation and I'm sure I can count on you (and SAP documentation also).

Best regards for all !!!

Example of consolidation for two kpis (KPI2_ACT and KPI2_TAR), this runs after the LOAD process (READ command)

SET VAR * NOCONSOLIDATE

SET VAR KPI2_TAR CONSOLIDATE

SET VAR KPI2_ACT CONSOLIDATE

ROLLUP KPI2_TAR

ADD everybody

SHOW COUNT

END

ROLLUP KPI2_ACT

ADD everybody

SHOW COUNT

END

CHECKPOINT freeze

CONSOLIDATE

CHECKPOINT update

SET VAR KPI2_TAR NOCONSOLIDATE

SET VAR KPI2_ACT NOCONSOLIDATE

[Former Member · Accepted solution]

Good to hear. PAS is a great product and one you get to grips with it you will find you can use it for all manner of applications.

[Bob_McGlynn]

Ricardo,

Although the Load Procedure will bring data into PAS, you do have to have a Consolidation Procedure to have that data rolled up through your dimensional hierarchy. Only after Consolidation will the front end of SSM be able to use the loaded data.

Regards,

Bob

[Former Member]

HI,

After reading data you only see the values in dataview tab because you still have the elements selected (SELECT PAIS INPUT,SELECT CANAL INPUT,SELECT PRODUCTO INPUT,SELECT SERVICIO INPUT).

This happens because you only have values at the INPUT levelu2026 I think that you forget to consolidate valuesu2026

Regards,

Miguel