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

Composite provider join Advanced DSO

Hi Experts !

I have to implement a data warehouse on BW system powered by HANA.

I created 2 ADSO on HANA Studio and i would like, join the both ADSO (with inner join), with a composite provider.

I follow this documentation http://scn.sap.com/community/bw-hana/blog/2015/11/07/hana-composite-provider-hcpr-practical-tips

But when i search my ADSOs, with the wizard in HANA Studio, but i can't find them....

I don't know why... I just find classic DSO...


Do you have an idea ?

Componnents and versions:

SAP BW 7.4 SP13

BI Content 7.57 SP8

Hana studio

Thanks a lot for your help.

Regards,

Sylvain.

Capture.PNG (21.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 19, 2016 at 09:40 AM

    Hi Sylvain,

    are you facing the same problem with Union type of Join?

    Please let us know we are working on the proposal for new design to our client.

    Rregards,

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arun,

      sorry for the answer delay.

      Yes i'm facing the same problem with every types of joins.

      I open a ticket on SAP support.

      When i will receive the answer, i will update this topic !

      Regards,

      Sylvain.

  • Posted on Sep 12, 2016 at 08:38 PM

    Hello Sylvain,

    can you resolved? I have the same problem, I can't found adso?

    Componnents and versions:

    SAP BW 7.4 SP14

    regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Marcelo,

      Yes i found the solution.

      It's a user right and customizing problem.

      User right:

      Make sure that you have mapped on your system the mapping between SAP BW and the tenant SAP HANA wasn't implement.

      You have a new tab in SU01 (DBMS).

      For the technical customizing, you have to implement these actions:

      Implement notes:

      2248091 - Change to reimplementation handling

      2223484

      2222417

      Execute the report RS_UDO_NOTE_2187566 with the option "Update".

      Execute the report RSOSN_INIT_DATA_74008 and confirm all the displayed dialogs.

      Execute the report RSOSN_SEARCH_UPDATE_METADATA

      Implement note:

      2228691

      To do this, go to transaction RSOSM and choose "Configure BW Search". Then select button to delete the shared buffer in the "Shared-Buffer-Status" line. After you click on this button, the status of the shared should change from "Shared buffer is filled" to "Shared buffer is not filled.


      Implement notes:

      2258488

      2313424

      2319685

      2319696

      run RSOSM to deactivate / reactive BW Search

      I hope my topic can help you...

      Regards,

      Sylvain.

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.