05316nam 2200673 450 991078781080332120200520144314.01-78217-091-X(CKB)2670000000569443(EBL)1800645(SSID)ssj0001375115(PQKBManifestationID)11770270(PQKBTitleCode)TC0001375115(PQKBWorkID)11335556(PQKB)11775347(Au-PeEL)EBL1800645(CaPaEBR)ebr10944926(CaONFJC)MIL647868(OCoLC)892044296(CaSebORM)9781782170907(MiAaPQ)EBC1800645(PPN)228019214(EXLCZ)99267000000056944320141016h20142014 uy 0engur|n|---|||||txtccrCreating universes with SAP BusinessObjects create and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool /Taha M. Mahmoud1st editionBirmingham, [England] :Packt Publishing,2014.©20141 online resource (310 p.)Professional expertise distilledIncludes index."Professional Expertise Distilled." -- Cover.1-78217-090-1 1-322-16611-0 Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to BI and the Semantic Layer; What is Business Intelligence?; Business Intelligence concepts; The knowledge pyramid; Hindsight, insight, and foresight; BI and DWH; BI reporting tools architecture; The one-tier architecture model; The two-tier architecture model; The three-tier architecture model; What is a semantic layer?; Introduction to Universes and the Information Design Tool; History of SAP Business Objects; SummaryChapter 2: Aligning BI Solutions with Business DemandsNorthwind; The BI Maturity Model; Configuring and setting up Northwind''s database; Getting the Northwind sample database; Creating the ODBC Connection; The Northwind data model; Dimensional modeling terminologies; Order information; Inventory information; Summary; Chapter 3: Creating Our First Universe; Information Design Tool; The main features of the IDT; Information Design Tool interface; Local Projects; Repository Resources; Security Editor; Project Synchronization; Check Integrity Problems; Creating your first Universe step by stepCreating a new projectCreating a new data connection; Creating a new Data Foundation; Creating a new Business layer; Saving and publishing the Northwind Universe; Finding help while creating a Universe; The Universe wizard; Cheat Sheets; Summary; Chapter 4: Creating the Data Foundation Layer; Working with data connections; The relational connection; The OLAP connection; Building the Data Foundation layer; Types of Data Foundation; Single Source; Multisource-Enabled; Physical tables and views; Alias tables; Derived tables; Using the @Prompt functionality in a derived tableNested derived tablesList of derived tables; Joining tables; Cardinality; Key types; A primary key; A foreign key; Join types; Equal joins; Theta joins; Outer joins; Self joins; Data Foundation menus and functions; Detecting joins; Detecting cardinalities; Detecting the row count; Refreshing the structure; Managing families; Save the view as an image; The search panel; Auto-arranging tables; Controlling the Data Foundation display; Insert View; Data Foundation visualization; Data Foundation object manipulation; Insertion; Table manipulation; Add to View; Edit; Merge; Delimit; Set Case ToReplace byDetect; Change Qualifier/Owner; The table''s values and display; Count Rows; Show Table Values; Select Related Tables; Highlight Related Tables; Display; Centre on Selection; Show Local Dependencies; Highlight Aliases; The table''s basic functions; Summary; Chapter 5: Creating the Business Layer; Gathering requirements; The Business layer''s main window; The left panel; The Properties panel; The Data Foundation panel; Business Layer; Managing Business layer views; Showing/hiding the search panel; Expand and collapse all; Display Options; Inserting objects; Business objects; FoldersDimensionsThis book is aimed at both new developers as well as experienced developers. If you are a new SAP BusinessObjects Universe developer who is looking for a step-by-step guide supported with real-life examples and illustrated diagrams, then this book is for you. If you are a seasoned BusinessObjects Universe developer who is looking for a fast way to map your old experience in Universe designer to the newer Information Design Tool, then this book is for you as well.Database managementRelational databasesDatabase management.Relational databases.658.472Mahmoud Taha M1529468MiAaPQMiAaPQMiAaPQBOOK9910787810803321Creating universes with SAP BusinessObjects3773718UNINA