Its possible to have so many Calculated Key Figures and Restricted Key Figures against a particular info provider

/wp-content/uploads/2015/07/b11_743568.png

And this is not a welcome sight for anyone looking to create a Query and consume one of the CKF’s or RKF’s

Solution


There is an ABAP Report “RSZ_COMPONENT_TREE”, using which the CKF’s and RKF’s , for a particular info provider, can be grouped. For ease of use

How to do it


(1) In SE38 transaction, execute the ABAP Report “RSZ_COMPONENT_TREE”

(2) Key in the info provider and execute

/wp-content/uploads/2015/07/b12_743569.png

(3) The list of all CKF’s and RKF’s will be seen

/wp-content/uploads/2015/07/b13_743582.png

(4) Right click on the “Calculated Key Figures” and select “Create Node”, giving an appropriate name

/wp-content/uploads/2015/07/b14_743583.png

(5) Drag and drop the needed CKF’s inside the node

(6) Next, save the operation using the “Save Hierarchy” button

(7) The created nodes will now be reflected in BEx and Eclipse BW Query Designer

(8) The same can be done for RKF’s

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Gajesh Nagesh

    Hello Aneesh,

    Good one, it will help out in organizing the query. Can you throw some light on how the transport will be moved. ( what needs to be collected in transport)

    Regards

    Gajesh

    (0) 
  2. Nanda Anantha

    Hi Aneesh,

    It really good one, i tried in SAP BW 7.3 version didnt find , in which version you used this program.

    Thank you,

    Nanda

    (0) 
  3. Sridevi Aduri

    Aneesh Kumar


    Thank you for the blog. Since there are so many versions and sp are running at the moment. A little introduction/ purpose  and Version of the BW would have been an added advantage.

    Regards

    Sri

    (0) 
  4. Yiannis Kasolis

    Thanks for the tip!

    I work on a BI 7.31 with SP 12 and i have the program.

    You can use the transaction “RSZTREE”. Search for the note 1648317.

    (0) 
  5. Jalina Vincent

    Hi Aneesh Kumar,

    We are using Bi 7.0 version and I am unable to find the below program in Se38

    Program Name : “RSZ_COMPONENT_TREE”

    Please help.

    Thanks.

    (0) 
  6. Pankaj Purohit

    The Information is Good. But no clarity on the availability of the Program in which version of BW & with which SP. Neither the  questions on the blog have been answered.

    (0) 

Leave a Reply