Calculated (CKF) and restricted (RKF) key figures are often used in BW mainly for re-usability and maintenance reasons. However, the handling in the Query Designer is not optimal in case of huge  number of CKF or RKF. Finding a certain CKF/RKF can be tedious and very time consuming. Using the sorting might help, but typically only if  the naming supports it. The following screenshot shows the sorting in the BEx key figure section:

The highest number of CKF/RKF on a single MultiProvider I have seen was more than 1.400. Here also the sorting is not really helpful anymore.

A way of supporting a high(er) number and structuring of CKF/RKF is available since the following note (available as of BW 7.3 SP8) was introduced:

1648317 – Hierarchical display of RKF/CKF in Query Designer

It delivers the transaction RSZTREE, which is typically used to maintain a hierarchical structure in the backend. The note also explains how to use it. The following example demonstrates this based on the business content MultiProvider 0RMA_MP01. After activating the content and opening the Query Designer the CKF section there will look like this:

Call now the transaction RSZTREE in the back-end and enter the InfoProvider there:

The CKF/RKF are displayed in the same structure from the Query Designer. Individual grouping typically starts with building up the hierarchy and then assigning the CKF/RKF to the corresponding nodes. The finalized example looks like this:

Re-opening the Query Designer for the corresponding InfoProvider does look like this:

There are a few smaller downsides. For instance the missing integration into the Query Designer or the not always intuitive behavior of the RSZTREE transaction. Nevertheless, this functionality is useful to structure CKF/RKF more user friendly in the query designer.

Finally, some additional information/thoughts, which might be beneficial using this functionality:

  • The hierarchy maintained in RSZTREE is transported together with the InfoProvider.
  • The hierarchy information is stored in the table RSZCOMPTREE and RSZCOMPTREETXT.
  • The assignment of a single CKF/RKF is stored in the table RSZCOMPIC, field FOLDER. The information is always transported together with CKF/RKF.
  • If a CKF/RKF with hierarchy assignment is transported but the hierarchy information is not available in the target, the information is ignored.
  • Top nodes Calculated key figure and Restricted key figure cannot be changed
To report this post you need to login first.

5 Comments

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

  1. glen spalding

    hi, very interesting stuff. are there any hierarchy limits. e.g. number of nodes.

    also, does the hierarchy aggregate the key figures, or is it just a way of organizing a large number of KFGs.

    thanks

    glen

    (0) 
    1. Stefan Witteck Post author

      Hi, we haven’t come across any limits. But the maintenance is not so intuitive, therefore we tried to restrict the number of nodes. And it is only for organizing.

      Best regards,

      Stefan

      (0) 
  2. Dirk Umbach

    Hi, does anyone know, how it works, if we develop the queries and restricted key figures not in the data model development system?

    Can we transport the multi provider from development system and the RKF/CKF from test system?

    Thanks, Dirk

    (0) 
    1. Stefan Witteck Post author

      Hi,

      I haven’t tried it this way myself but I assume that it should work. You should maintain the node structure in the development system. Otherwise a transport of the Multi would delete the structure in the target systems. In the quality/production system you then only assign the CKFs/RKFs to the corresponding nodes. Doing it with a programm is also an option if RSZTREE is causing issues in the target system

      Best regards,

      Stefan

      (0) 
      1. Dirk Umbach

        Hi,

        thanks for your answer. I do it in the way you described since two weeks. At now I got no problems.

        Another question is, if there is any possibility to join calculated and restricted key figures in one folder. Because our key users are only interested in the key figures.

        I thought to create a calculated key figure for each restricted key figure, but that does not improve the well-arrangement.

        Best regards, Dirk

        (0) 

Leave a Reply