When a universe is deployed, you make it available to Web intelligence users for reporting. Universe are deployed when they are exported to CMS repository. When a Universe is exported to CMS repository, a unique system identifier is assigned by the CMS.

To make Universe available to all designers, you have to check if the Universe is not built on a secured connection. Secured connections are used to export Universe to CMS repository.

To save Universe for all users, go to File → Save As or use F12.

sap 183

Select the Save For All Users check box → Click OK.

sap 184

To export a Universe, go to File → Export. You need to select the target Universe domain and a group. If someone else is using Universe, it will be showed as greyed locked. You can double click to lock/unlock a Universe.

sap 185

Managing Access of Universe

You can manage Universe security either in CSM repository or in Universe level. For Universe in CMS, you can define users who can edit and delete based on access rights assigned to their user group. At the Universe level, you can define users who are allowed to use a particular Universe.

The following security level is applied −

CMS

From the Central Management Console you can set restrictions that apply to universes stored in a CMS. You can set what universes users can access, and depending on the rights defined for a user group, you can restrict viewing, editing, deleting, and other actions in a universe. This guide does not cover setting restrictions at the CMS level, see the BusinessObjects Enterprise Administrator’s Guide for information on using the Central Management System.

Universe

You can define restrictions for users allowed to use a universe. A restriction can include object access, row access, query and SQL generation controls, and connection controls. This guide de-scribes the types of restrictions you can define on a universe.

Access to Universe are managed using restrictions and you can apply multiple restrictions to single dashboard. You can also edit and delete restrictions as per access requirement. The following restrictions can be used −

Connection − You can provide an option to use an alternate connection to data source.
Query Controls − This restriction can be used to limit the size of result and execution time of the query.
Access to Rows − With the use of Where clause, you can limit the result set returned and access the rows.
SQL Generation Options − This is used to control generated SQL from query.
Referencing Different Table − You can set a restriction to replace a table with another table in database.
Object Access − This restriction is used to allow users to select objects which are not used in the Universe.

To manage access restrictions, navigation to Tools → Manage Security → Manage Access Restrictions. The dialog box appears.

sap 186

The current restrictions which are applied to Universe are available under available restrictions column. You can find users and user groups that are defined for each restriction under Available Groups and Users pane.

Note − Restrictions can only be applied to Universe which are exported to CMS repository.

sap 187

To add a user or group, click on add user or group button. In next window, you can see list of all available groups/users that can be added to restrictions.

sap 188

You can also define groups with highest priority of restrictions. Click on Priority button and restriction on group name with highest priority will take precedence.

sap 189

To create new restrictions, click on New button on left side. This will open Edit restriction dialog box. You have to enter the restriction name and you can see all restriction control tabs below.

sap 190

From each tab, you can select different restriction types as mentioned above. For example, control settings allow you to limit the size of result set and the execution time of the query.

sap 191

Once you create new restrictions, you can apply to selected user and group. To apply a restriction, select it in left pane and use “Apply” button → to apply on user in right window. Once restriction is applied, it will show restriction name in the right pane.

sap 192

SAP Universe Designer – User and Groups

In the Universe design tool, the access to users and groups are managed using restrictions. To view restrictions for all Universe users and groups, navigate to Tools → Preview Security Restrictions and this will open preview users and groups dialog box.

sap 193

So, this brings us to the end of blog. This Tecklearn ‘Deploying Universe in SAP Universe Designer’ blog helps you with commonly asked questions if you are looking out for a job in SAP Business Object and SAP Domain. If you wish to learn SAP IDT and UDT and build a career in SAP domain, then check out our interactive, SAP Business Objects Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-business-objects-certification-training/

SAP Business Objects Certification Training

About the Course

Business intelligence tools and features are used by multiple companies and firm for the effective results their large flow of data. The completion of this SAP Business Objects training will be helpful in landing yourself a good paying job. With this Business Objects online training, you will gain considerable proficiency in SAP BO architecture, data warehousing, use of Information design tool, create multiple reports and the implementation of Web intelligence and Efficiency in solving the issues of data sources and Crystal dashboard design.

Why Should you take SAP Business Objects Training?

The Average salary of SAP Business Objects Business Intelligence Analyst is $94,000 per annum – PayScale.com
Business Objects is an enterprise reporting tool and Scalability is one of the primary reasons large corporations choose Business Objects for their BI needs.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Introduction to Business Objects

History and Version of Business Object
How Business Objects works in SAP family
SAP BO-Business Intelligence package and tool list
Data warehousing concept from SAP perspective

SAP Business Object Architecture

SAP BO Architecture
Various tiers in architecture: Client, Processing, Intelligence

SAP Web Intelligence

Web Intelligence Overview
Variable in Web Intelligence environment

Using Universe Designer Tools (UDT)

Overview of the Universe Designer Tool
Working with shared, secured and personal connections
Understanding of the Semantic layer

SAP BO Reports

SAP BO Reports
Chart Reports, Table Reports, Sorting and aggregating of Reports
Various elements of Reports, graphs, text elements
Reports and Filters
Section Report
Break Report
Alerts Report
Scope of Analysis Panel
Conditional Reporting
Ranked Report
Drill Report

Advanced Formatting

Advanced methods of formatting in SAP BO
Identifying Chasm trap and resolving Chasm traps with various methodologies
Detection and resolving of loop

Information Design Tool (IDT) Integration

Introduction to SAP BO information design tool
Extracting data from various sources using OLAP methodologies
Creating of Universe with IDT
IDT Vs UDT
Working with IDT as an Integration tool

Getting started with Crystal Dashboard

Data visualization tool for creating interactive dashboards
Point-and-click Features
Various dashboard features and interface

Live Office

Live office
Detailed design of Crystal Dashboard

SAP BO 4.2 Features

Got a question for us? Please mention it in the comments section and we will get back to you.

607