SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services /: more than 100 recipes to develop business intelligence solutions using analysis services. (2013)

• Record Type: Book
• Further Information: Note: Baya Dewald, Steve Hughes, Paul Turley.
• Other Names: Dewald, Baya; Hughes, Steve; Turley, Paul, 1962-
• Contents: 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 views. Defining 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 structures. Partitioning 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 options. Learning 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 functionality. Monitoring 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 session.
• Publisher Details: Birmingham : Packt Publishing
• Publication Date: 2013
• Extent: 1 online resource (370 pages)
• Subjects: 005.7585; COMPUTERS -- Networking -- Intranets & Extranets; COMPUTERS -- Programming -- Microsoft; Business intelligence; Data mining; Database management; MDX (Computer program language); Business intelligence; Data mining; Database management; MDX (Computer program language); Client/server computing; Computer networks -- Security measures; SQL server; Web servers; COMPUTERS -- Programming Languages -- SQL; COMPUTERS -- Databases -- General; Business intelligence; Data mining; Database management; MDX (Computer program language); COMPUTERS -- Programming Languages -- JavaScript; COMPUTERS -- Networking -- Vendor Specific; COMPUTERS -- Networking -- Local Area Networks (LANs); Electronic books
• Languages: English
• ISBNs: 9781782170679
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.