Check Infocube Basic or Transactional

[Former Member]

Hi all,

I want to check if an Infocube is basic or transactional with Function Module; I've tested the return of FM RSD_CUBE_GET_ONLY_DB but in the field l_s_cube-cubetype always "B"....

I've analyzed the FM: RSAPO_CLOSE_TRANS_REQUEST; RSAPO_SWITCH_TRANS_TO_BATCH, RSAPO_SWITCH_BATCH_TO_TRANS, ... But my problem is tested only the type of infocube (Basic or transactional) moreover if transactional even if the cube can be planned by function SEM.

I have found the table RSMDATASTATE and the field LOADALWD... for me this field is perfect.... I want to check this by Function Module...

you know some Function Module....

any help is appreciated.

regards,

Alessandro

Message was edited by: Alessandro Gasparro

[Former Member · Accepted solution]

Hi Alessandro,

the function module for modify the field "LOADALWD" is RSM_LOADALWD_SET and for check is RSM_LOADALWD_GET.

I hope help you.

DG

[harsha_jalakam]

for aDSO type we need to use the below utility classes

At any given time, the current behavior is given by

 data(lv_plan_mode) = cl_rspls_adso_api=>factory( )->GET_PLANNING_MODE( i_adsonm = 'aDSO_Name' ).

For aDSO type cube, we need to use the below snippet to switch between plan and load mode.

  cl_rspls_adso_api=>factory( )->set_planning_mode( i_adsonm = 'aDSO_Name' i_planning_allowed = 'X' ).

to switch back to load mode

  cl_rspls_adso_api=>factory( )->set_planning_mode( i_adsonm = 'aDSO_Name' i_planning_allowed = ' ' ).

[Former Member]

You have to check TRANSACT field of table RSDCUBE.

I don't know if exist an FM to check it.

Regards

[Former Member]

Thanks Paolo,

But in this table, the field TRANSACT not change if switch te Infocube, so the field value is always "X"..., moreover the field CUBETYPE is always "B"... I do not know the operation of this table. I think that the function RSD_CUBE_GET_ONLY_DB test this table,.....

Regards,

Alessandro