Does BWA come into Play for Relational SAP BW (DSO) Multi Source Universes ?

[Former Member]

Hello,

While Designing Multi-Source Universes on top of SAP BW (Using Multiple DSO's) and SQL Server as a Source . Does BWA Come into Play at all.

or is it only While using OLAP Universes on top of Bex Queries i.e. while using BICS Connectivity ?

Could anyone provide any clarification on this .

Thanks & Regards

Karthik

[Henry_Banks]

Hi,

That's a good question.  I think the answer is no, but you should check with your BW BASIS.

The MDX API (XI3.1) and BICS API (BI4.0) both go through the BW OLAP engine, and my understanding is that a BW-SQL multi-source federation goes direct to the underlying relational DB schema on which the "R-OLAP" warehouse (therefore, effecively by-passing the BW application layer) .

Regards,

H

[Former Member]

Hello Henry,

Thanks for your reply. Appreciate your Help.

Could you please tell me How IDT UNX Universe Interprets and Forms Tables and JOIN's from an SAP BW Source Like DSO's.

Thanks & Regards

Karthik

[Henry_Banks]

Hi,

1. Here’s an FAQ http://scn.sap.com/docs/DOC-22146
2. Here’s a how to for the connection http://scn.sap.com/docs/DOC-31890
3. There’s a tutorial online here for multi source
   joins: https://websmp204.sap-ag.de/~sapidb/011000358700001251732010E   (from www.service.sap.com/rkt)

4.  Here are the Help Guides of interest:

•    Information Design Tool Guide: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_info_design_tool_en.pdf

       See “9.1.3 About multisource-enabled data foundations”

• Data Federation Admin guide: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_dfat_guide_en.pdf

       See “4.5.1 List of connector properties for SAP NetWeaver BW data sources”

• Data Access Guide: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_data_acs_en.pdf

       See 5.3 Creating JDBC connections

5.   Here are a bunch of useful notes (& prerequisites):

• Note 1316106 - Data
  Federator: Configuration of RFC connection
• Note 1465871 - Minimal BW
  Authorizations for BO Data Federator
• Note 1460273 - NW BW
  7.01/7.02: Missing error message in Data Federator
• Note 1426509 - Error
  "SAP NetWeaver BI cannot reach a callback server on this host (...)
  E_ERROR=99"
• Note 1604227 - Error Testing Relational
  connection to SAP BW system using the SAP Java Connector

I hope this is of use to you.

  Regards,

H

[Former Member]

Thanks Henry for your Help. Appreciate your Response. I Have seen this Material also, but havent seen any where how IDT Forms Alias for the Test or Dimension Tables. And How it Forms Classes etc.in detail.

[Henry_Banks]

Hi,

Aliases are user defined.

a Class is a logical folder, under which you have objects.

Initially, it's probably the same container as the table, but by the time you are making a business layer it could be a customised grouping for the business.

i think you are getting hung up on the details here.

You might get some fundamentals/definitions in the IDTs own Help guides.

Regards,

H