Skip to Content

InfoObject Mapping in Composite Provider - Error Message for Display Attributes and Texts

Hi,

I was working with the Master Data Planning in SAP BW/4HANA and I would like to integrate the Master Data Planning in SAC. I already prepared my InfoObject, which means I chose to use it as a InfoProvider and I switched it to Planning.

I have the following Attributes in my InfoObject ZCOSTCTR (Copy of 0COSTCENTER), which I would like to plan:

As we have a Live Data Connection with BPC for the SAC I need to integrate my InfoObject in the BPC Model, which is only possible via a CompositeProvider. In the CompositeProvider I add the ZCOSTCTR as InfoProvider, where I have the attributes as well as the generated key figures for each attribute.

Here is my question: When I do the mapping for ZCOSTCTR in the CompositeProvider, it is only possible to do it for the Nav.-Attributes. However, for the keyfigures for the display attributes as well as for the texts I always receive error messages and I am not able to activate the CompositeProvider. Hence, I am not able to do a Planning for these in SAC.

In this example I mapped the two key fields 0CO_AREA and ZCOSTCTR (no problem) and as attributes 1KYF_0RESP_P (Nav.Attr.), 1KYF_0COMP_C (no Nav. Attr. ) and 1KYF_1TXTSH.

Does anyone have an idea on how to map these in a CompositeProvider or make it possible to enable planning on texts and display attributes in SAC?

Thank you in advance and best regards

Svenja

19.png (28.6 kB)
20.png (73.6 kB)
22.png (79.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 05, 2020 at 07:31 AM

    Hi Svenja,

    it seems that BPC only displays CompositeProviders and aDSOs in the value help where you can pick the InfoProviders to be included in the BPC Model. Have you checked the following approach:

    include the planning enabled InfoObject in a CompositeProvider (just map the InfoObject), include the CompositeProvider in the BPC Model; then below the CompositeProvider you should see all part providers in the BPC Model, including the InfoObject. I am not sure, I hope that BPC does not only include aDSOs used as part providers in the CompositeProvider.

    Regards,

    Gregor

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 03, 2020 at 08:07 AM

    Hi Svenja,

    input-ready query based on planning enabled InfoObjects also use 'characteristics as key figures' to expose all attributes and all existing text fields as key figures. Technically this means that the values are transported using the SIDs from BW data manager, to OLAP, planning and the clients.

    For the CompositeProvider this means that the BW data manager needs SIDs on the DB level to be able to use a characteristic as key figure 1KYF_A based on characteristic A (or 'text field' 1TEXT*, etc.). As display attribute A or the different kind of text fields have no SID on the provider level the CompositeProvider does not allow to map the fields 1KYF_A, 1KYF_1TXT*, 1KYF_1DATE*, 1KYF_1TXTDATE*. So in a CompositeProvider you can only map 1KYF_A if A is a navigation attribute.

    But you can create an aggregation level on the planning enabled InfoObject, an input-ready query on top of this aggregation level and use this query in SAC via a BPC liveConnection. In your story you can then use more than one input-ready query to integrate master data and key figure planning.

    Regards,

    Gregor

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Gregor,

      thank you very much for this explanation.

      I have an aggregation level on my planning enabled InfoObject and I created some queries on this aggregation level.

      For integration into SAC via the BPC liveConnection I need to add my InfoObject into a BPC Model first, correct?

      How do I get the InfoObject into my BPC Model as I am only able to select aDSOs or CompositeProvider? Is there any other way to use my queries in SAC via the BPC liveConnection without the BPC model?

      Thank you very much and best regards

      Svenja

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.