Problem while using:RSDRC_CUBE_DATA_GET

[Former Member]

Hi ,

I am extracting data from a basic infocube using fm :RSDRC_CUBE_DATA_GET . Unfortunately it is extracting the data from F-facttable only, and not extracting compressed data.

Following are my selections in the function module. Please advice if i need to do any modification to this.

CALL FUNCTION 'RSDRC_CUBE_DATA_GET'

EXPORTING

i_infocube = ic_name

• I_TH_FACTTAB =

• I_CUBETYPE =

i_th_sfc = i_th_sfc

i_th_sfk = i_th_sfk

i_tsx_seldr = i_tsx_seldr

• I_T_SELK =

• I_T_RTIME =

i_srdate = i_srdate

• I_DERIVE_REQUID = RS_C_FALSE

• I_TH_CUBE_REQUID =

• I_T_RPLCHA =

i_no_ncum_handling = rs_c_true

i_use_db_aggregation = 'X'

i_use_aggr_cubes = i_use_aggr_cubes

• i_most_recent = i_use_modif

i_packagesize = i_max_rows

• I_ACCESSTP = RSDRS_C_ACCESSTP-DEF

• I_NCUM_REPNM =

i_authority_check = rsdrc_c_authchk-read

• I_CURR_CONVERSION = RS_C_FALSE

• I_AVOID_GENERATION = RS_C_FALSE

• I_SAMPLE = 100

i_returntp = i_returntp

i_returnobj = i_returnobj

i_avoid_duplicates = i_avoid_duplicates

i_parallel_mc = rs_c_false

• I_PARALLEL_NCUM = RS_C_FALSE

• I_PARALLEL_SEL = RS_C_FALSE

• I_PARALLEL_DB = RS_C_FALSE

• I_REQUID_SPLIT = RS_C_FALSE

i_show_report = i_show_report

i_show_plan = i_show_plan

• I_EXPLAIN_MC = RS_C_FALSE

• I_QUERY_SCENARIO = RS_C_FALSE

• I_OLAP_CALL = RS_C_FALSE

• I_SET_EMPTY_RESULT = RS_C_FALSE

• I_DEBUG = RS_C_FALSE

IMPORTING

e_t_data = e_cube_data

• E_END_OF_DATA =

• E_EMPTY_RESULT =

• E_AGGREGATE =

• E_NCUM_VALUES =

• E_TSX_SELDR =

• E_SEL_FEMS =

• E_FEMS_PART =

• E_RUN_TIME =

• E_SPLIT =

• E_BASICCUBE =

CHANGING

c_first_call = l_first_call

EXCEPTIONS

wrong_input = 1

metadata_error = 2

inherited_error = 3

no_authorization = 4

OTHERS = 5.

Thanks in Advance,

Ramesh

[Former Member · Accepted solution]

Hi,

I would try to change this:

i_use_aggr_cubes = i_use_aggr_cubes in

i_use_aggr_cubes = <b>rs_c_true</b>

/manfred

[Former Member · Accepted solution]

Hi Manfred,

Thanks for your response.

But i am not using any aggregates on that cube.

Regards,

Ramesh

[Former Member · Accepted solution]

Hi Ramesh,

than I would try to use parameter: I_USE_FACTVIEW = RS_C_TRUE.

/manfred

[Former Member · Accepted solution]

Thanks alot manfred it is working fine.

Last question is do we need any additional license to use this FM in production. does SAP released this to customers?

Regards,

Ramesh

[Former Member · Accepted solution]

Hi Ramesh,

Are you able to assist in getting me to call this function successfully.

I have the following report, but the programing is short dumping on the declaration of the

E_CUBE_DATA.

Thank you.

Simon

&----

---

*& Report ZRSDRC_CUBE_DATA_GET

*&

&----

---

*&

*&

&----

---

REPORT ZRSDRC_CUBE_DATA_GET.

DATA:

I_TH_SFC TYPE RSDD_TH_SFC,

I_TH_SFK TYPE RSDD_TH_SFK,

I_TSX_SELDR TYPE RSDD_TSX_SELDR,

RS_C_FALSE TYPE RS_BOOL,

RS_C_TRUE TYPE RS_BOOL,

I_MAX_ROWS TYPE I,

I_AVOID_DUPLICATES TYPE RS_BOOL,

I_SHOW_REPORT TYPE RS_BOOL,

I_SHOW_PLAN TYPE RS_BOOL,

L_FIRST_CALL TYPE RS_BOOL.

DATA: BEGIN OF tb_itab,

col1 TYPE i,

col2 TYPE c,

END OF tb_itab.

DATA E_CUBE_DATA LIKE tb_itab.

*DATA E_CUBE_DATA LIKE HASHED TABLE OF tb_itab WITH UNIQUE KEY col1.

*DATA E_CUBE_DATA TYPE E_T_DATA.

*E_CUBE_DATA TYPE TABLE.

*I_RETURNOBJ TYPE RSDRS_RETURNOBJ.

*I_RETURNTP TYPE RSDRS_C_RETURNTP.

*RSDRC_C_AUTHCHK-NONE TYPE RSDRC_AUTHCHK.

parameters: p_date like sy-datum default '10000101'.

start-of-selection.

• if not p_date ge '18000101'

• or not p_date le '99991231' .

*

• write: 'ok'.

*

• endif.

CALL FUNCTION 'RSDRC_CUBE_DATA_GET'

EXPORTING

I_INFOCUBE = 'CPRD_C50'

• I_TH_FACTTAB =

• I_CUBETYPE =

I_TH_SFC = I_TH_SFC "Pass Characteristics

I_TH_SFK = I_TH_SFK "Pass Key Figures

I_TSX_SELDR = I_TSX_SELDR

• I_TH_CHA_CHECKFL_0 =

• I_TH_CHA_CHECKFL_N =

• I_T_SELK =

• I_T_RTIME =

• I_TSX_MPR =

I_SRDATE = SY-DATUM

• I_DERIVE_REQUID = RS_C_FALSE

• I_TH_CUBE_REQUID =

• I_T_RPLCHA =

I_NO_NCUM_HANDLING = RS_C_FALSE

I_USE_DB_AGGREGATION = RS_C_TRUE

I_USE_AGGR_CUBES = RS_C_TRUE

• I_USE_AGGRCUBE =

• I_USE_FACTVIEW = RS_C_UNKNOWN

• I_USE_ODS_TABTP = RSDOD_C_TABT-ACTIVE

• I_PACKAGED = RS_C_FALSE

I_PACKAGESIZE = I_MAX_ROWS

• I_MAXROWS = 0

• I_ACCESSTP = RSDRS_C_ACCESSTP-DEF

• I_NCUM_REPNM =

• I_NCUM_QUERY = RS_C_FALSE

• I_NO_NCUM_INTERSECT = RS_C_FALSE

• I_AUTHORITY_CHECK = RSDRC_C_AUTHCHK-NONE

• I_CURR_CONVERSION = RS_C_FALSE

• I_SAMPLE = 100

• I_RETURNTP = I_RETURNTP

• I_RETURNOBJ = I_RETURNOBJ

I_AVOID_DUPLICATES = I_AVOID_DUPLICATES

I_PARALLEL_MC = RS_C_FALSE

• I_PARALLEL_NCUM = RS_C_FALSE

• I_PARALLEL_SEL = RS_C_FALSE

• I_PARALLEL_DB = RS_C_FALSE

• I_REQUID_SPLIT = RS_C_FALSE

I_SHOW_REPORT = I_SHOW_REPORT

I_SHOW_PLAN = I_SHOW_PLAN

• I_EXPLAIN_MC = RS_C_FALSE

• I_QUERY_SCENARIO = RS_C_FALSE

• I_CALLER = RSDRS_C_CALLER-MISC

• I_SET_EMPTY_RESULT = RS_C_FALSE

• I_REPORTRFC = ' '

• I_STATICS_CLEANUP = RS_C_FALSE

• I_DEBUG = RS_C_FALSE

• I_NOMES252 = RS_C_FALSE

IMPORTING

E_T_DATA = E_CUBE_DATA

• E_TX_DATA =

• E_END_OF_DATA =

• E_EMPTY_RESULT =

• E_RUN_TIME =

• E_TX_SPLITPACK =

• E_SPLIT_OCCURRED =

CHANGING

C_FIRST_CALL = L_FIRST_CALL

EXCEPTIONS

WRONG_INPUT = 1

METADATA_ERROR = 2

INHERITED_ERROR = 3

NO_AUTHORIZATION = 4

NESTED_QUERY_ERROR = 5

OTHERS = 6

.

IF SY-SUBRC <> 0.

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

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

ENDIF.