Facts Design Device in SAP BO
Facts Design Device in SAP BO
A universe is an prepared collection of metadata items that enable business customers to analyze and record on company information in a non-technical language. These objects include dimensions, measures, hierarchies, attributes, pre-described calculations, features, and queries. The metadata object layer, called the enterprise layer, is constructed on a relational database schema or an OLAP cube, so the gadgets map at once to the database systems thru square or MDX expressions. A universe includes connections figuring out the data assets so queries may be run on the data.
The function of the universe is to offer the commercial enterprise consumer with semantically understandable commercial enterprise items. The consumer is unfastened to investigate facts and create reviews the usage of relevant enterprise language no matter the underlying information assets and structures.
Universes created the usage of the facts design tool may be used by the following SAP Hana Administration records evaluation and reporting applications starting with version BI four:
-SAP BusinessObjects internet Intelligence
-SAP Crystal reviews for business enterprise
-SAP BusinessObjects Explorer
-SAP BusinessObjects Dashboard layout
To enable the fashion designer to create universes, the facts design tool provides the sources vital to do the subsequent:
Create connections to information resources.
Extract a entire OLAP dice schema.
Extract tables and joins to build a relational schema known as a information basis.
Create metadata gadgets from the dice or the data foundation. those gadgets are contained and organized in a business layer. The square and MDX expressions inside objects may be proven and queries run against the target databases to check the commercial enterprise layer.
percentage assets to allow multiple designers to work on the same resources concurrently.
post a universe, which compiles the business layer, the statistics foundation, and the
connections into a unmarried universe file (.unx):
post a universe to a repository to be implemented in deployments of SAP BusinessObjects facts analysis and reporting programs.
submit a universe regionally, to be carried out by patron programs in standalone mode (for instance internet Intelligence wealthy customer).
Create protection profiles to outline person get admission to to universe data and metadata.
Who makes use of the facts layout tool?
The universe clothier can be a database administrator, an programs supervisor or developer, a task supervisor, or a document writer who has obtained sufficient technical abilities to create universes for other customers. A protection administrator additionally makes use of the facts design tool to define universe security profiles.
There can be a couple of universe designer in a company. The variety of universe designers relies upon on the employer’s information requirements. as an example, one universe clothier could be appointed for every software, assignment, department or functional region.
beginning the statistics layout tool
The statistics design device is established with the SAP BusinessObjects commercial enterprise Intelligence platform purchaser equipment. For greater data on installing the BI platform purchaser equipment, see the SAP BusinessObjects enterprise Intelligence Suite four.zero grasp guide, or the SAP Crystal Server 2011 Getting began guide.
as soon as the customer gear are established in your device, as an instance in a home windows installation of the BI platform, you could begin the statistics layout tool with the command: start > All
applications > SAP BusinessObjects BI platform four > SAP BusinessObjects BI platform client tools > information layout tool.
No authentication is required to apply the data layout device in offline mode (not related to a repository). you may start creating and enhancing neighborhood resources.
setting options for test integrity
in the check integrity desire web page, you can pick out rules to be run automatically whenever you shop a resource. you could also trade the severity of the messages again by each rule.
From the records design device primary menu, choose Window > options.
within the “options” conversation container, increase the data design device node and select take a look at Integrity.
To pick policies to be run mechanically while you keep a resource:
pick out the allow history test integrity on keep alternative.
choose the policies to encompass in the heritage take a look at.
The value column suggests the relative processing time required to execute the rule of thumb.
To exchange the severity of the messages returned with the aid of a rule, click on inside the Severity column for the rule. pick out a severity from the list.
To repair the default values for check integrity possibilities, click repair Defaults.
To shop the modifications and retain editing choices, click apply.
To keep the adjustments and close the “options” dialog field, click on adequate.
The history test takes effect straight away.