This page presents a practical step-by-step example for using SAP BusinessObjects Universes with SAP Analytics Cloud.
Please use this page in conjunction with the best practices which presents the theory and more explanations which help answer the 'why' questions
This page provides a step-by-step example to create a dedicated Universe for consumption with SAP Analytics Cloud.
Create dedicated (derived) Universe
- Start SAP BI Platform client tool 'Information Design Tool'. Login
- Create a new folder in the Repository
- Call the folder 'SAP Analytics Cloud' (or another name. The name should correspond to the boe.compatibleUniverseFolder property held in the boe.properties file. The boe.compatibleUniverseFolder property, if set, will limit the universes listed within SAP Analytics Cloud to only those in that folder and subfolders.
An example boe.properties is:
- Restart the webapp ‘cs_ina_agent’ once the boe.properties file has been updated. i.e. restart Tomcat.
- Select the universe you'd like to re-use in SAP Analytics Cloud for live connectivity. Right click to select 'Create Linked Universe'.
- This example uses the BI Platform Audit Analysis Universe
- Select Next to use the same connection with the core universe.
- Select a folder to store your project
- Provide a Business Layer Name, Data Foundation Name and a Description.
- Press Finish
- Open the Business Layer
- Only a single run-time context is supported
- Hide all the objects that generate more than 1 context. Hide universe folders:–‘Specific Event Types (multiple values per event),–‘Audit Details (multiple values per event)’,–‘Advanced Query Objects’
- Hide objects using unsupported data-types–'Start datetime'
- Hide all measure objects (unless they already in the root of the universe folder structure)
- Create a new measure in the root for each measure object.
- For each object use @SELECT and optionally @WHERE to re-use the SELECT and WHERE clauses of the original measure object
- The result will be a set of measures all defined in the root of the universe folder, but all based off, the now hidden, original measure objects.
- Publish the Universe to the folder you created earlier, 'SAP Analytics Cloud' in this example
- Resolve any issues identified with the integrity check
Validate and Optimise
- Logon to BI Launchpad and login as the user you will use later to connect to the BI Platform from within SAP Analytics Cloud.
- Select Applications-Web Intelligence, to launch Web Intelligence
- Start Web Intelligence Rich Client
- Select new document
- Select Universe and press OK
- Select the universe you published in an earlier step and press OK
- Add all the objects (every single object, all measures and all dimensions) into the Results Objects pane.
- Ensure there are no filters applied
- Press the 'show script' to show the SQL
- Validate the SQL is a single statement and it has NO 'multiple paths' (i.e. no join and no merging of separate SQL statements). If the are multiple paths then the universe will not be compatible for consumption with SAP Analytics Cloud live universe connector.
- Press Close
- Press Run Query
- Add a new report (tab) by selecting 'Page Setup' - 'Add Report'
- In the new report, add the 'Query Summary', by selecting 'Report Elements' - 'Cell' - 'Query Summary' and then adding that into the report by clicking on it.
- Validate the query duration and number of rows returned.
- Press the Save icon
- Select the 'Favorites Folder', give the document a name and press Save.
- Delete the document after you have saved it.
- If you are unable to successfully save the document then SAP Analytics Cloud will generate errors to the user.
Create Model is SAP Analytics Cloud
Create New Connection
- Login to SAP Analytics Cloud, but very importantly:
- If you are using a reverse proxy (which will require a 'PATH' connection) then you must login via the Reverse Proxy.
- If you are using CORS (which will require a 'DIRECT' connection) then you can login directly to the cloud application.
- Be sure to login with a user that has administration rights to create connections and models.
- Select 'Connections' from the menu
- Add a connection by selecting '+' - 'Live Data Connection' - 'SAP Universe'
- Give the connection a name and description. Importantly note, the name cannot be changed once created.
- Select the Connection Type, either 'Path' (for use with a Reverse Proxy), or 'Direct' when using CORS.
- If using a Reverse Proxy, the name of the Path Prefix must match that of the path statement as defined in the Apache httpd.conf file.
- The application will add a '/' to the path if one is not entered. So in this example 'myBIP' and '/myBIP' are both valid and have the same effective value.
- Select Authentication Method 'User Name and Password' and enter the corresponding details. The username and password are not stored.
- One language per connection.–The default language you select here will not be dynamic, it will be fixed. @Variable('PREFERRED_VIEWING_LOCALE’) will not change.–It means all models created with this connection will content to the BI Platform with the locale you select here.
- Press OK, to save the connection
Create New Model
- Select 'Create' - 'Model''
- Select 'Use a datasource' and then 'Live Data connection'
- Select the 'System' to the connection you created earlier
- Select the Universe you published earlier
- Give the model a name and description
- Press OK
- The model will be created (the Universe metadata is uploaded to the Cloud)
- Select the spanner icon and then 'Dimension Settings'
- Remove the folder name ('Time' in this example') from the 'Description' of each object, and add it to the 'Group' column.
- You will notice a folder structure appearing on the right hand side.
- Once this has been completed for each object, the final result will look like above.
- Press OK to return to the model structure
- Press Save
Process Flows for creating a new model
Create New Story
- Select 'Create' - 'Story'
- Select 'Access & Explore Data'
- Select the option 'Data Acquired from an Existing Model'
- Select the model you created earlier
- Select at least one measure and add dimensions as you see fit
- Use the Explorer interface to filter, sort, rank, change chart types, add/remove measures and to look at the data by different dimensions
- Copy the visualisation to a Story Page
- Within a few minutes you can build yourself a dashboard with an input control to filter the charts as you please.
Process Flows for create a new visualisation are available
This wiki is referenced by a blog. Typically please comment on the blog, not directly on these wiki pages.