Skip to Content
avatar image
Former Member

Populate fields in infocube

Hi geniuses,

Please help:)

Is it possible to populate fields in infocube in the start routine?

I am trying to load data from ODS to Infocube. They are 1:1 mapping, but there a few fields are not populated in ODS like occupy_percentage_low. Now I am asked to calculate those values in start routine and send the values to coresponding fields in the infocube.

I tried to use the following code, but there is no values in the cube after I load data to cube.

loop at data_package assigning <fs>.I

IF <fs>-/BIC/occupy / <fs>-/BIC/Totalavailable < '0.10'.

  • DATA_PACKAGE-/BIC/OCCU_LOW = 'Y'.

  • CONTINUE.

  • ENDIF.

ENDLOOP.

I also tried to use <fs>-/BIC/OCCU_LOW = 'Y'. In debugging mode, there is no value for <fs>-/BIC/OCCU_LOW either. Really lost!

Thanks!

Lin

Message was edited by: Lin Cong

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 07, 2006 at 02:00 AM

    hi Lin,

    if the infoobject name is 0occupy and 0totalavailable then it should be like

    <fs>-occupy / <fs>-Totalavailable

    (without /bic/; /bic/ is for customized infoobject, e.g you have infoobject zoccupy then it will be like <fs>-/bic/zoccupy.

    if the calculation didn't involved any data from other table, only from ods (occupy and Totalavailable are exist in ods) then you have no need to populate with start routine, you can simply populate e.g infoobject occupy_percentage_low using method 'routine', create routine and put code like

    result = 'N'.

    IF comm_structure-occupy / comm_structure-Totalavailable < '0.10'.

    result = 'Y'.

    ENDIF.

    or ..

    IF comm_structure-/BIC/zoccupy / comm_structure-/BIC/z... < '0.10'.

    (zTotalavailable is too long for customized infoobject name, so the name should be not like that).

    hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2006 at 02:32 AM

    The answer to your question is absolutly possible to add a field to your cube. Make sure you have that field to your comm. structure as well; and follow AHP's code.

    Regards:

    BK

    Add comment
    10|10000 characters needed characters exceeded