Skip to Content
author's profile photo Former Member
Former Member

automated where-used liste for global key figures

Hi everyone,

does anyone know, which badi, function or alike is called by the 'where-used' functionality of restricted and calculated key figures within the BEx Query Designer?

Or maybe someone knows how the key figures definitions are stored in SAP BI?

Here's the background of my question:

I got a list of restricted and calculated key figures which might be deleted.

But before I can do that I need to find out which depenences they have with other query elements and queries.

I don't want to look it all up manually, because the key figure list is quite long.

I allready had a closer look at the tables RSZELTDIR and RSZELTXREF. But it seems RSZELTXREF does not hold the connection between queries and global key figures. (I'm not sure, but maybe they're connected to another element like 'querysheet'?)

Also the connection between 2 key figures isn't in there.

Thanks in advance for your help.

Regards

Chris

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 09:06 AM

    Hallo,

    I solved the problem.

    For those who are interested in this:

    Via the function RSZ_P_WHERE_USED_LIST_RECSV you can determine the dependencies of a queryelement recursively. The function uses an UUID as an import parameter and returns a list of depenend UUID. The details for those elements can be retrieved from RSZELTDIR.

    Greetings

    Christian Baum

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.