Skip to Content

Composite Provider vs Calculation View

Hi,

Have a question w.r.t. Composite Provider vs Calculation View based reporting please help me to understand which will be the best approach for BW modeling.

  • Why Composite Provider based reporting is required in BW4HANA?
  • Can we build report directly on Composite provider or Generated Calculation View based on Composite Provider/ADSO? Which approach is recommended and Why?
  • Report build on top of generated calculation view or composite provider will give better performance throughput?
  • Technically all the scenarios we can handle through calculation view then why we need to follow BW based approach (Composite Provider) based reporting.

Thanks,

Muruga M

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 10, 2017 at 03:10 PM

    Hi Muruga,

    Below are my answers. Hope that helps.

    • Why Composite Provider based reporting is required in BW4HANA? Without composite provider, you cannot use navigation attribute for reporting purpose. An old "good practice" followed in multiproviders has now become a "forced practice" - if you must use navigation attributes for reporting.
    • Can we build report directly on Composite provider or Generated Calculation View based on Composite Provider/ADSO? Which approach is recommended and Why? - You have to decide which connection your reporting tools use. Commonly used ones are BW connection (BICS) or a HANA Online connection. If you use HANA Online, you will bypass application layer. Which means there is an additional overhead of user maintenance and HANA database security. To overcome this problem, a recommended approach is to use BW connection and implement user security in BW.
    • Report build on top of generated calculation view or composite provider will give better performance throughput? - The former, but you cannot enrich with semantics like BW master data in this case.
    • Technically all the scenarios we can handle through calculation view then why we need to follow BW based approach (Composite Provider) based reporting. - Refer to my answer to second question above.

    Anup

    Add comment
    10|10000 characters needed characters exceeded