OBI Reports from SAP BW Cube

OBIEE has the capability to build repository by importing a MOLAP Cubes. Let's see the steps to build OBI Repository and develop Reports from a SAPBW cube.

1. Open an instance of the OBI Adinistration tool
2. Click File--> New and give a name like SAPBW to the repository
3. Click File--> Import from Multi-Dimensional
4. In the Import from Multi-Dimension dialog box provide the parameters for connection to the XMLA Data structure



















5. This is the imported SAP Cube structure



















6. Create a new Logical Model with necessary logical joins as per requirements














7. Create the Presentation Layer as per requirements
















8. Make the necessary updates to the configuration files and starting the OBI services

9. Logon to OBI Presentation services and create a sample report to validate the data