Skip to Content
avatar image
Former Member

SAP IBP KEY FIGURES CONFIGURATION PARAMETERS DOWNLOAD

Hi SAP,

As a newbe consultant, we asked me to validate and/or modify parameters on all key figures of a specific Planning Area.

As we have several hundred key figures, you can just imagine what a clerical/repetitive job it means.....

Therefore, I would like to download/export all parameters of all keyfigures linked to a Planning Area (following fields: Name*, Description, Business Meaning, Base Planning Level, Aggregation Mode, Disaggregation Mode, Period Weight Factor, Disaggregation Expression, Used Key Figures, Snapshot Key Figure, Alert Key Figure, Stored, Edit Allowed, Calculated, I/O for Supply Planning, Convert Using, Change History Enabled, Aggregated Constraint and Calculation Definitions)

I suppose that all those informations are definetely stored in a table or two, somewhere in a database.

My first question is: is it possible to download those informations in a excel/csv file per Planning Area? and how?

My second question depends on the answer of the first one: if no, how come it's not possible???

It's clearly a must for us if we want to succeed in configuring efficiently and also to analyse our configuration with intelligent reporting.

Customers measure themselves and their data, so should we.

Thank you in advance for your answer.

Yours sincerely,

Hedi Chikhaoui

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 22, 2017 at 09:44 PM

    Hi Hedi,

    Coming to your question, it is possible to extract the KF information directly from the system back-end tables. However, as IBP is a cloud solution, this can be performed only by SAP. Currently, there is no Export feature directly from WEB UI in the product.

    I would suggest that you raise an incident in the Launchpad requesting this data for the PAs you need it, then it can be extracted from HANA Studio by an SAP representative.

    Best regards,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 23, 2017 at 02:27 PM

    Thank you Ivan.

    I will.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 04:47 PM

    @Ivan Andreis

    Ivan, following your answer, could you tell me if Hana Studio is available to other SAP members?

    Or is it only available to SAP representatives?

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 05 at 06:18 AM

    may I know the outcome?

    I am unable to see the option to download all the KF ( about 1700) with all the formulas in them ?

    Add comment
    10|10000 characters needed characters exceeded