Scheduled switch of transactional infocube role

[Former Member]

Hello All,

I am trying to locate the way for automatically switching the role of a transactional infocube from "Planning to Allowed" to "Loading not Allowed" and vice versa. In this way we would be able to plan a job that after switch the infocube role and get the request in green could tranfer the data into aggregates to do the information available for users in BEx reporting.

Any help? Thank you in advanced for you inputs.

Regards,

[Former Member · Accepted solution]

You can use this abap program.

Regards.

REPORT ZBW_SWITCH_CUBO.

SELECTION-SCREEN BEGIN OF BLOCK a WITH FRAME TITLE text-001.

PARAMETER: P_CUBO LIKE RSDCUBET-INFOCUBE.

PARAMETER: P_VERS LIKE rsdcubet-objvers DEFAULT 'A'.

PARAMETER: B_TO_TR RADIOBUTTON GROUP a.

PARAMETER: TR_TO_B RADIOBUTTON GROUP a.

SELECTION-SCREEN END OF BLOCK a.

START-OF-SELECTION.

IF NOT B_TO_TR IS INITIAL.

CALL FUNCTION 'RSAPO_SWITCH_BATCH_TO_TRANS'

EXPORTING

I_INFOCUBE = P_CUBO

EXCEPTIONS

CUBE_NOT_TRANSACTIONAL = 1

INHERITED_ERROR = 2

OTHERS = 3

.

IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

WRITE: / 'CUBO ',P_CUBO,' da Base a Trans : PRONTO PER SEM'.

ENDIF.

IF NOT TR_TO_B IS INITIAL. .

CALL FUNCTION 'RSAPO_SWITCH_TRANS_TO_BATCH'

EXPORTING

I_INFOCUBE = P_CUBO

EXCEPTIONS

CUBE_NOT_TRANSACTIONAL = 1

SWITCH_NOT_POSSIBLE = 2

INHERITED_ERROR = 3

OTHERS = 4

.

IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

WRITE: / 'CUBO ',P_CUBO,'da Trans a Base : PRONTO PER CARICAMENTO DATI'.

ENDIF.

[Former Member]

That's exactly what I need.

Thank you very much.

[Former Member]

It works fine.....

Some point.... please.

Regards