05437nam 22007453u 450 991045341680332120210114043336.01-84968-981-4(CKB)2550000001179132(EBL)1581056(SSID)ssj0001174058(PQKBManifestationID)11673439(PQKBTitleCode)TC0001174058(PQKBWorkID)11107328(PQKB)10973893(CaSebORM)9781849689809(MiAaPQ)EBC1581056(PPN)228033411(EXLCZ)99255000000117913220140106d2013|||| u|| |engur|n|---|||||txtccrSQL Server Analysis Services 2012 Cube Development Cookbook[electronic resource]1st editionBirmingham Packt Publishing20131 online resource (340 p.)Quick answers to common problemsDescription based upon print version of record.1-84968-980-6 1-306-28020-6 Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source viewsDefining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structuresPartitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing optionsLearning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionalityMonitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a sessionChecking whether cubes are accessibleA practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS.If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.Client/server computingComputer networks -- Security measuresSQL serverWeb serversEngineering & Applied SciencesHILCCComputer ScienceHILCCElectronic books.Client/server computing.Computer networks -- Security measures.SQL server.Web servers.Engineering & Applied SciencesComputer Science005.75005.7585Dewald Baya988193Turley Paul850105Hughes Steve611924AU-PeELAU-PeELAU-PeELBOOK9910453416803321SQL Server Analysis Services 2012 Cube Development Cookbook2259751UNINA