sap bo olap universe creation step by step1
TRANSCRIPT
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 1
SAP BO OLAP Universe Creation
Step By Step
Prepared By: Ramarao G
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 2
Creating a OLAP Universe on top of SAP BW For this example we will use a SAP BW Query based on the “SAP Demo Scenario “ cube which includes the characteristics:
Product Customer Calendar Year Calendar Month Product Group Region Code Distribution Channel and the keyfigures
Net Sales Lost Deals Billed Quantity
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 3
To create a new OLAP Universe 1. Start the Universe Designer (Start > Programs > Business Objects XI Release 3 > Business Objects Enterprise > Designer).
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 4
2. Enter the User Name and Password. 3. Click OK. 4. Select the menu File > New.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 5
5. Click New to create a new connection
6. Click Next.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 6
7. Select SAP Business Warehouse from the list.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 7
8. Enter a Connection Name. 9. Click Next.
10. Enter the required details.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 8
11. Set the Authentication Mode to Use Single Sign On when refreshing reports at view time.
Using single-sign-on in combination with an SAP system requires the SAP authentication to be configured for the SAP system in the Central Management Console of BusinessObjects Enterprise. 12. Click Next.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 9
13. Open the list of available cubes by clicking the plus sign next to OLAP Cubes.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 10
14. Navigate to the required cube. 15. Open the list of available queries for the selected cube by clicking the plus sign next to the cube.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 11
16. Select the required query and click Next.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 12
17. Click Finish.
18. Enter a name for the Universe into the field Name. 19. Navigate to the Controls tab.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 13
20. Uncheck all Query Limits.
21. Click OK. 22. Select the menu File > Export.
The Universe needs to be saved before it can be exported.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 14
23. Click Save.\
24. Select a Domain. 25. Select the Groups that should be assigned to the Universe.
SAP BO OLAP Universe Creation – Step by Step http://saptrainingsonline.com
Prepared By: Ramarao G [email protected] Page 15
26. Click OK.
27. Click OK.