How to read Transaction data from a specific member dimention in BPC

[Former Member]

Hi Experts,

I want to read specific member data from cube I'm implementing Badi UJ_CUSTOM_LOGIC

There is a Dimention Called SUBITEM in this there are so many members like

Parent member ==>>SUBITEM

Under Subitem Member==>SUBTOT

Under SUBTOT there are two sub child

                                   INROAM & OUTROUM

                         Under INROAM there is there are two member dimentions

                              INROAM-POS

                              INRAOM-PRE

                        Then inraom-pos have input

                                   MOU-101 upto MOU-105 ( The User Will Enter Data In this)

                         Then INRAON-PRE

                                   MOU-201 upto MOU-205 ( The User Will Enter Data In this)

I want to get the data of member Dimention (SUBTOT)

like there so many Dimentions how Should I read specific transaction data from the CUBE

Regards

Mohammed Sajid

[Former Member · Accepted solution]

Hi Mohammed Sajid,

Follow the below steps.

1) Read all the base members from Parent (SUBTOT)

2) Pass all the base members in your filter to get data from cube/model.

In BW, You cannot see the data at parent level.

Regards

Rohit

[Former Member]

I got solution by applying below method

         lr_dim_data->get_children_mbr(

         exporting

           i_parent_mbr = 'TOTMOU'

           if_only_base_mbr = 'X'

           importing

            et_member = lt_mbr_name ).

***

         loop at lt_mbr_name into ls_base_en.

           "CREATE AND FILL LT_RANGE FOR FURTHER USAGE IN RSDRI QUERY

           ls_range3-dimension = 'SUBITEM'. "'TOTMOU'.

           ls_range3-attribute = 'CALC'.

           ls_range3-sign = 'I'.

           ls_range3-option = 'EQ'.

           ls_range3-low = ls_base_en.

           append ls_range3 to lt_range3.

         endloop.

'TOTMOU' is member of 'SUBITEM' Dimention like this i'm preparing internal table lt_range3.

and passing this to method run_rsdri_query and getting result.

[former_member339201]

Hi Sajid,

It will work fine. But just in case if you have to scope 2-3 dimensions like this. For example say you want to get base members to 2014.TOTAL , then you again call the method?

You can, in that way pass the values of base members from script logic and collect in your internal table in code for master data scoping.

Regards,
SHUBHAM

[Former Member]

like I said'TOTMOU' 'EOPS' 'SOPS''RGSE' & 'RGSS' these are members of SUBITEM the data is entered like in this format               Jan2015 Feb2015 Mar2015 Apr2015 May2015 Jun2015...DEC2015 TOTMOU'   MOU101        22        11   .   . EOPS EOPPOS        11        12 . . . . so I'm getting data in internal table and performing calculations.

[former_member186338]

Hi Mohammed,

"I want to get the data of member Dimention (SUBTOT)

like there so many Dimentions how Should I read specific transaction data from the CUBE"

"I want to get the data of member" - meaningless, you can get data only for some intersection of all dimensions!

Vadim

[former_member339201]

Hi Sajid,

Like Vadim said. You have transaction data corresponding to an intersection of different dimension members.

If this is the scenario then :

1) you can pass the base members of SUBTOT from the logic script into your Badi code

2) collect the base dimension members(passed from script) in an internal table in your Badi code.

3) Use it to scope your Master data.

4) retrieve the transaction data based on the scoped master data.

5) get the sum of transaction data on criteria of  dimension members [BAS(SUBTOT)]  you passed from the script into your Badi code.

Regards,
SHUBHAM

[Shrikant_Jadhav]

Hi Mohammed,

As you are talking about BADI , I think you are using NW version.  Please post query on NW forum.

SAP Planning and Consolidation, version for SAP NetWeaver

Take look at below document.

ABAP Badi Usage in BPC 7.5

Hope this will help you.

Shrikant