Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2011 at 06:45 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 06, 2011 at 02:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2011 at 09:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.