Information Design Tool User Guide

1 SAP BusinessObjects business Intelligence platformDocument Version: 2015-11-12 Information Design Tool User GuideContent1 What's new in the Information Design Tool User Guide ?..142 Getting started with the Information Design About the Information Design About resources in the Information Design Starting the Information Design About the Information Design tool the user interface Setting preferences in the Information Design preferences for the business Layer preferences for check integrity ..23 Setting connection display preferences for the Data Foundation display preferences for the data foundation table and join detection default join states for performance-related options for the data foundation languages used by the Information Design a link for online middleware for secured relational preferences for showing How to get help using the Information Design Wizards in the Information Design Creating How to create a universe with the Information Design tool.

2 Using SAP BW data InfoProvider objects are mapped in a universes based on SAP Using SAP HANA data relational resources on SAP HANA Information Using SAP ERP data Using Microsoft Analysis Services (MSAS) data Using Essbase data Using SAS data Multilingual universe About the New Universe 2015 SAP SE or an SAP affiliate company. All rights Design Tool User GuideContentSelect or create a project in the New Universe the data source type in the New Universe or create a relational connection in the New Universe or create an OLAP connection in the New Universe or create a data foundation in the New Universe Converting .unv About .unv and .unx About converting .unv universes .. Features supported when converting .unv Tips for resolving check integrity errors after converting.

3 Unv Converting a .unv universe in a Converting a locally-stored .unv Retrieving published Retrieving a published universe from the local file Retrieving a published universe from a Working with About local projects and a local resource universe resources in the local file a local a local for and filtering resources in the Local Projects Recovering universe resources in local projects after workspace About shared a shared project from a local in a shared a shared a shared About project the Project Synchronization a a a changes to shared Saving resources as Finding and replacing object names in a business Working with repository Design Tool User GuideContent 2015 SAP SE or an SAP affiliate company. All rights About managing repository About session a a Running a query on a universe published in a Working with About local secured connection About the Connection Creating a relational a a middleware the connection Creating an OLAP an OLAP middleware login parameters for OLAP data an OLAP cube.

4 Creating a connection Editing local and secured Editing connection Showing values in a relational Showing values in an OLAP Working with data About data data foundation single-source data multisource-enabled data About the Data Foundation How to build a data About connections in the data connections to a data a connection in a data delimitation overrides to for tables in the Connection the tables in the connection by table tables in an SAP HANA connection by Information About tables in the data tables into the data 2015 SAP SE or an SAP affiliate company. All rights Design Tool User GuideContentEditing table case of table and unhiding table column data qualifiers and table and column About table and detecting table About table row About and editing a a column About and setting Inserting a calculated Inserting a time About derived a derived table based on a data foundation and editing a derived table.

5 About alias alias alias the original table of an About and editing Resolving About input columns in the data input About parameters and lists of values in the data About data foundation SQL options in the data SQL generation parameters in the data a data foundation the data foundation description and SAP HANA variable Showing table values in a data Design Tool User GuideContent 2015 SAP SE or an SAP affiliate company. All rights Showing column Profiling column Showing local dependencies in the data About refreshing a data Inserting a custom data foundation Searching for tables and columns in the data Inserting a comment into the data foundation Centering the view on a Changing the display of objects in the data tables in the data foundation table tables using Working with the federation About the federation Building the federation data About federated a federated table a federated table from a data a federated About input tables and input tables to a input meanings of input table joins using core About mappings in the federation columns from the input table to columns of the federated a mapping the SQL Expression

6 A and deactivating About distinct rows on input and deactivating distinct About pre-filters and and editing Showing values in a federated Checking integrity of the federation Inserting a federated table into the data Refreshing the structure of the federation Working with business 2015 SAP SE or an SAP affiliate company. All rights Design Tool User About business About business layer How to build a relational business the type of data source for a business a business a data foundation for a business How to build an OLAP business an OLAP connection for a business a business layer directly on a BEx an Essbase Accounts objects from an OLAP cube for a business About the business Layer display options of the business layer tree About business layer data source query the business layer name, description, and query limits and options in the business the data source of a business SQL generation parameters in the business a business layer About index About analytic functions: syntax and functions.

7 Rules, restrictions, and best analytical functions in a business layer object analytical functions in a derived table About aggregate up aggregate aggregate Working with business layer a and editing dimensions directly from the data keys for dimensions and dimension an attribute or measure into a and editing a dimension or attribute into a and editing a dimension or measure into an and editing Design Tool User GuideContent 2015 SAP SE or an SAP affiliate company. All rights and editing analysis and editing and editing hierarchy and editing named and editing calculated the SQL expression for an the MDX expression for an extra the state of an object: Active, Hidden, or object access where objects can be options for the default list of and editing display formats for business layer source Information for business layer objects.

8 249 Inserting and editing custom associated business layer object for business layer About business layer and editing a business layer by business layer About parameters ..253 Inserting and editing a an index-aware About lists of values ..257 Inserting or editing a list of values ..257 List of values column a list of values with a business a list of values with a prompt defined in the business About navigation paths for a navigation path object into a business About queries in a business and editing a query in the business Reordering objects in the business Layer About refreshing business an OLAP business layer ..265 Inserting candidate About computing statistics for optimized query execution ..266 Computing statistics for a multisource-enabled Linking What are linked universes?

9 2688 2015 SAP SE or an SAP affiliate company. All rights Design Tool User What are the advantages of using linked universes?.. Working with linked a new linked a core universe to an existing are core universe components displayed in a linked universe?..272 Managing core universes from the business Layer core universe components in a linked a core universe from a linked a core universe into a linked Working with the data foundation of a linked ways to view core universe data foundation the display of tables common to multiple core data between core and linked universe Using the Query How to build a About the Member selecting hierarchy the Member Selector in the Query Panel ..281 Selecting hierarchy members by hierarchy relationship.

10 282 Selecting hierarchy members by named calculated for hierarchy hierarchy a prompt to select selected members in the Member hierarchy display estimated child Filtering data in the Query to build a business data using Setting query Viewing and editing the query Profiling column values in the query Refreshing a query containing BEx Checking Running check Reviewing check integrity Design Tool User GuideContent 2015 SAP SE or an SAP affiliate company. All rights Showing dependencies between About resource Showing local Showing repository Publishing About publishing Publishing a a repository a local Publishing a local connection to the Publishing a local universe to the Managing About universe About securing resources in the Information Design CMC rights for Information Design tool About the Security How to secure a universe using security Opening the Security Inserting and editing a Data Security Security Profile Security Profile Connections Security Profile Controls Security Profile SQL Security Profile Rows Security Profile Tables Changing Security Profile Inserting and editing a business Security Security Profile Security Profile Connections