05349nam 2200685 450 991046329870332120200520144314.01-78217-091-X(CKB)2670000000569443(EBL)1800645(SSID)ssj0001375115(PQKBManifestationID)11770270(PQKBTitleCode)TC0001375115(PQKBWorkID)11335556(PQKB)11775347(MiAaPQ)EBC1800645(CaSebORM)9781782170907(PPN)228019214(Au-PeEL)EBL1800645(CaPaEBR)ebr10944926(CaONFJC)MIL647868(OCoLC)892044296(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 databasesElectronic books.Database management.Relational databases.658.472Mahmoud Taha M889716MiAaPQMiAaPQMiAaPQBOOK9910463298703321Creating universes with SAP BusinessObjects1987840UNINA