LEADER 05316nam 2200673 450 001 9910787810803321 005 20200520144314.0 010 $a1-78217-091-X 035 $a(CKB)2670000000569443 035 $a(EBL)1800645 035 $a(SSID)ssj0001375115 035 $a(PQKBManifestationID)11770270 035 $a(PQKBTitleCode)TC0001375115 035 $a(PQKBWorkID)11335556 035 $a(PQKB)11775347 035 $a(Au-PeEL)EBL1800645 035 $a(CaPaEBR)ebr10944926 035 $a(CaONFJC)MIL647868 035 $a(OCoLC)892044296 035 $a(CaSebORM)9781782170907 035 $a(MiAaPQ)EBC1800645 035 $a(PPN)228019214 035 $a(EXLCZ)992670000000569443 100 $a20141016h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aCreating universes with SAP BusinessObjects $ecreate and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool /$fTaha M. Mahmoud 205 $a1st edition 210 1$aBirmingham, [England] :$cPackt Publishing,$d2014. 210 4$dİ2014 215 $a1 online resource (310 p.) 225 1 $aProfessional expertise distilled 300 $aIncludes index. 300 $a"Professional Expertise Distilled." -- Cover. 311 $a1-78217-090-1 311 $a1-322-16611-0 327 $aCover; 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; Summary 327 $aChapter 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 step 327 $aCreating 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 table 327 $aNested 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 To 327 $aReplace 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; Folders 327 $aDimensions 330 $aThis 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. 606 $aDatabase management 606 $aRelational databases 615 0$aDatabase management. 615 0$aRelational databases. 676 $a658.472 700 $aMahmoud$b Taha M$01529468 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910787810803321 996 $aCreating universes with SAP BusinessObjects$93773718 997 $aUNINA