MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Advanced Analysis Services

Course Summary

This course covers advanced design topics related to dimensions and partitions. It explains how to utilize Analysis Services features for parent-child hierarchies, financial analytics, referenced dimensions and many-to-many relationships. It also demonstr

  • +

    Course Syllabus

    ● Advanced Design Techniques Part I
        ◦ Introduction
        ◦ Financial Parent-Child Hierarchy
        ◦ Demo: Creating the Account Dimension
        ◦ Account Intelligence
        ◦ Demo: Defining Account Intelligence
        ◦ Unary Operators
        ◦ Demo: Working with Unary Operators
        ◦ IsAggregatable Property
        ◦ Demo: Configuring the IsAggregatable Property
        ◦ Naming Template
        ◦ Demo: Working with the Naming Template
        ◦ Default Member
        ◦ Demo: Defining a Default Member
        ◦ Custom Rollup
        ◦ Demo: Configuring a Custom Rollup
        ◦ Parent-Child Hierarchy Considerations
        ◦ Summary
    ● Advanced Design Techniques Part II
        ◦ Introduction
        ◦ Referenced Relationship
        ◦ Demo: Creating a Referenced Relationship
        ◦ Many-to-Many Relationship
        ◦ Demo: Creating a Many-to-Many Relationship
        ◦ Many-to-Many Considerations
        ◦ Summary
    ● Writeback
        ◦ Introduction
        ◦ Writeback Concepts
        ◦ Dimension Writeback
        ◦ Demo: Dimension Writeback
        ◦ Cell Writeback
        ◦ Demo: Cell Writeback
        ◦ Summary
    ● Aggregations
        ◦ Introduction
        ◦ Aggregation Concepts
        ◦ Query Processing
        ◦ Aggregation Usage
        ◦ Demo: Aggregation Usage
        ◦ Aggregation Wizard Optimizations
        ◦ Demo: Aggregation Wizard Optimizations
        ◦ Aggregation Designer
        ◦ Demo: Aggregation Designer
        ◦ Usage Based Optimization
        ◦ Demo: Usage Based Optimization
        ◦ Summary
    ● Partitions
        ◦ Introduction
        ◦ Partitioning Strategy
        ◦ Partition Storage
        ◦ Demo: Configuring Storage Modes and ROLAP Dimensions
        ◦ Demo: Adjusting ROLAP Dimension Settings for Deployment
        ◦ Demo: Adding Records to a ROLAP Partition and ROLAP Dimension
        ◦ Partition Design
        ◦ Demo: Using the Partition Wizard
        ◦ Merging Partitions
        ◦ Demo: Merging Partitions
        ◦ Summary
    ● Deployment
        ◦ Introduction
        ◦ Deployment Considerations
        ◦ Demo: Change Management and Deployment
        ◦ Dynamic Partitioning
        ◦ Demo: Dynamic Partitioning Implementation
        ◦ Processing Strategies
        ◦ Database Relocation
        ◦ Demo: Backup and Restore a Database
        ◦ Summary
    ● Advanced Security Topics
        ◦ Introduction
        ◦ Dynamic Security
        ◦ Demo: Dynamic Security Preparation
        ◦ Demo: Dynamic Security Implementation
        ◦ Parent-Child Hierarchy Security
        ◦ Demo: Parent-Child Hierarchy Security Implementation
        ◦ Writeback Security
        ◦ Demo: Writeback Security Implementation
        ◦ Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top