issue in reading data from Infocube in SAP BW

[abhimanyu_sharma]

Hi Experts,

I am using Function module RSDRI_INFOPROV_READ and reading cube data based on the fields specified in my program below.

I have added new field - Account type (0ACCT_TYPE) in the cube. Now, I have added this new field in the program to fetch the data for this field too. But when I run the program, it is fetching 0 records now. If i remove the new field from my program, the data is getting fetched from cube.

Please note I have one request in the cube which is not compressed and have no rollups.

Could you please help me in identfying the issue in this ?

 CLEAR GS_CH.
  GS_CH-CHANM       =   '0COMP_CODE'.  
  GS_CH-CHAALIAS    =   'COMP_CODE'.    
  GS_CH-ORDERBY     =   1.
  INSERT GS_CH INTO TABLE GT_CH.

  CLEAR GS_CH.
  GS_CH-CHANM       =   '0DIVISION'.  
  GS_CH-CHAALIAS    =   'DIVISION'.   
  GS_CH-ORDERBY     =   2.
  INSERT GS_CH INTO TABLE GT_CH.

  CLEAR GS_CH.
  GS_CH-CHANM       =   'OCRFBRND'.    
  GS_CH-CHAALIAS    =   '/BIC/OCRFBRND'.  
  GS_CH-ORDERBY     =   3.
  INSERT GS_CH INTO TABLE GT_CH.

   CLEAR GS_CH.
  GS_CH-CHANM       =   '0ACCT_TYPE'.  
  GS_CH-CHAALIAS    =   'ACCT_TYPE'.    
  GS_CH-ORDERBY     =   9.              
  INSERT GS_CH INTO TABLE GT_CH.


  CALL FUNCTION 'RSDRI_INFOPROV_READ'
    EXPORTING
      I_INFOPROV             = 'OBRFDT01'     "HARDCODE
      I_TH_SFC               = GT_CH
      I_TH_SFK               = GS_KF
      I_PACKAGESIZE          = GV_PACKET
      I_T_RANGE              = GT_SEL
    IMPORTING
      E_T_DATA               = GT_DATA
      E_END_OF_DATA          = GV_END_OF_DATA
    CHANGING
      C_FIRST_CALL           = GV_FIRST_CALL
    EXCEPTIONS
      ILLEGAL_INPUT          = 1
      ILLEGAL_INPUT_SFC      = 2
      ILLEGAL_INPUT_SFK      = 3
      ILLEGAL_INPUT_RANGE    = 4
      ILLEGAL_INPUT_TABLESEL = 5
      NO_AUTHORIZATION       = 6
      ILLEGAL_DOWNLOAD       = 7
      ILLEGAL_TABLENAME      = 8
      TRANS_NO_WRITE_MODE    = 9
      INHERITED_ERROR        = 10
      X_MESSAGE              = 11
      OTHERS                 = 12.

ENDFORM.                    " READ_CUBE_DATA

[vanessa_jie_ling · Accepted solution]

Hi,

you didn't post the code about how you set up the parameter GT_SEL. I will assume that it remains the same.

There is an optional import parameter: I_ROLLUP_ONLY. This one is by default true. If you don't have roll ups, please set it to false.

Additionally, you may check if the new characteristic 0ACCT_TYPE is a authorization relevant info object. Try to turn of the authorization check by using the parameter I_AUTHORITY_CHECK.

Best Regards,

Jie

[abhimanyu_sharma · Accepted solution]

hi ,

I have set I_ROLLUP_ONLY = RS_C_FALSE and also the info object 0ACCT_TYPE is not authorisation relevant.

Still I am not getting any data in the cube read.

[vanessa_jie_ling · Accepted solution]

Hi, how did you define gt_data? Did you add the new characteristic to the definition of gt_data? If yes, then please debug it, and check the Exceptions with sy-subrc.

[abhimanyu_sharma · Accepted solution]

yes, I forget to add it in GT_DATA 🙂

thanks jie..