Skip to Content

Join characteristic and navigation attribute in Composite Provider

Dear all,

we are running BW 7.4 on HANA.

I am trying to join two ADSO in a Composite Provider in HANA Studio. From ADSO A e.g. I want to select 0COSTCENTER whereas from ADSO B I want to use a nav attribute e.g. 0PLANT__COSTCENTER.

In former Multiprovider definition it was possible to do this, but in the composite provider definition neither in the "Scenario" nor "Output" tab I was able to do this mapping. In the "scenario" tab no navigation attributes are visible.

How this mapping can be done? Any ideas would be great.

Best regards,

Stefanos

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 20, 2017 at 03:34 AM

    Hi,

    Under Scenario, from the context menu of provider select Show unassigned Navigational Attributes


    Thanks,

    Raju

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2017 at 08:48 AM

    Hi Raju,

    I was not aware of this setting.

    Thank you, it works now very fine.

    Best regards,

    Stefanos

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 28 at 07:31 AM

    Hi,

    can you tell me what SP you have? I don't have these function in my BW 7.4

    best regards

    Tobias

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I don't think it's possible, at least not in BW 7.4

      It only works for InfoCubes, which is shown in the screenshots above. Current workaround for me: Create a second Composite Provider (just with the ADSO), activate navigation attributes and insert it into the first Composite Provider. Then you're able to display the unassigned navis as shown above.

      Best
      Mark

  • avatar image
    Former Member
    May 22 at 02:40 PM

    Hi - Not sure if you have the answer but its automatically mapped for source as ADSO. All you have to do is Make sure to turn them on in the Output page by right clicking on the field and turn on Nav attributes. This will map it and make it availalbe for reporting.

    Hope this helps!

    Regards,

    Ketul

    Add comment
    10|10000 characters needed characters exceeded