SAP BusinessObjects Explorer on BW on HANA
Does BW on HANA support SAP BusinessObjects Explorer Accelerated the same way as BW 7.3 with BWA 7.2?
SAP BusinessObjects Explorer for BW on HANA is based on the HANA architecture, not on the BWA architecture anymore. The SAP BusinessObjects Explorer on BW on HANA leverages HANA’s own repository, its modeling capabilities and security model. HANA views are created directly on the underlying tables of BW InfoProvider as BW sits on HANA. The design is based on the metadata of BW InfoProviders.
The major difference between “SAP BusinessObjects Explorer, accelerated (with BWA)” and “BW/HANASAP BusinessObjects Explorer” is, that HANA has its own modeling environment (BWA/SAP BusinessObjects Explorer has not). The HANA modeling tool is aware of the capabilities of the HANA engine and is enhanced as the engine capabilities advance.
SAP BusinessObjects Explorer integration for BW on HANA is based on the BW model & HANA model interoperability.
Which BW InfoProviders are supported with SAP BusinessObjects Explorer? Do all SAP BW InfoProviders with SAP BW on HANA automatically become available in SAP BusinessObjects Explorer?
SAP BusinessObjects Explorer on BW on HANA leverages HANA’s own repository, its modeling capabilities and security model. HANA views are created directly on the underlying tables of BW InfoProviders as BW sits on HANA. The design is based on the metadata of the SAP BW InfoProviders.
At this point the following object/features are supported:
- HANA Optimized InfoCubes excluding CKF/RKF
- HANA Optimized/Standard DSOs excluding CKF/RKF
- Time Characteristics
- FISCAL Time characteristics
- Query Snapshot – BEx Query data available for Explorer
- MultiProvider Snapshot (via query snapshot)
- Analysis Authorization with restrictions on InfoProviders only, excluding authorizations based on key figures/measures and hierarchies
- Role based authorizations
With HANA revision 57 also HANA views based on Standard DSOs can be generated.
For more detailed information please have a look at the attached white paper and OSS note 1764251.
There is also a detailed HowTo guide about creating Dynamic Analytic Privileges in SAP HANA Based Upon Analysis Authorizations in SAP BW.
Do you have to use SAP HANA in order to use SAP BusinessObjects Explorer?
No, SAP BusinessObjects Explorer can also be used either with BW on RDBMS if you use the BWA, or the non-accelerated version on top of relational databases without BW and BWA.
Can the SAP BusinessObjects Explorer consume directly from the SAP HANA information model?
The SAP BI 4.x platform supports the direct consumption of HANA information models.
Where can I find detailed information about the supported integration of SAP BusinessObjects Explorer with BW on HANA?
Have a look at the attached white paper and OSS note 1764251.
There is also a paper available that describes the positioning of this new BW model import functionality and what it is intended for.