Mdx unplugged
Download
1 / 22

MDX Unplugged - PowerPoint PPT Presentation


  • 128 Views
  • Uploaded on

MDX Unplugged. Nauzad Kapadia [email protected] Scenarios for using Calculated Members . What are Calculated Members When will you use calculated members What are the drawbacks of calculated members. Considerations for using calculated members. Scope of calculated members

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' MDX Unplugged' - starr


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Scenarios for using calculated members
Scenarios for using Calculated Members

  • What are Calculated Members

  • When will you use calculated members

  • What are the drawbacks of calculated members


Considerations for using calculated members
Considerations for using calculated members

  • Scope of calculated members

  • Use of NON_EMPTY_BEHAVIOUR

  • Ordering expression arguments

  • Eliminate the code of computing formatted values

  • Use IS instead of =

  • Consider moving calculations to the relational engine


Scenarios for using named sets
Scenarios for using Named Sets

  • What are named sets

  • When would you use named sets


Considerations for using named sets
Considerations for using Named Sets

  • Joining sets

  • Filtering Sets

  • Ordering Sets


When to use dynamic named sets
When to use Dynamic Named Sets

  • What are dynamic named sets


What is solve order
What is Solve Order

  • What is solve order or formula precedence

  • Situations where solve order is critical

  • Specifying the solve order in queries


Considerations for working with solve order
Considerations for working with Solve Order

  • Solve order priority

  • Same solve order

  • Solve order only affects priority of calculations between dimensions

  • Leave gaps in solve order


Handling boundary conditions
Handling Boundary conditions

  • Handling division by zero

  • Handling insufficient range size

  • Handling insufficient hierarchical depth



What are sub cubes
What are sub-cubes

  • What are Sub cubes

  • Creating Sub cubes


Considerations for using sub cubes
Considerations for using sub-cubes

  • When are sub cubes preferred over slicer axis

  • How does the presence of sub cubes affect the outcome of a query

  • Sub cubes are scoped at the connection level


Identifying performance bottlenecks
Identifying performance bottlenecks

  • Determine if a unique design is involved

  • Determine if a poorly performing query always performs inadequately

  • Determine if the performance bottleneck is within the formula engine or storage engine


Query execution analysis tools
Query Execution analysis tools

  • SQL Server Profiler

  • System Monitor

  • Kernrate and Kernrate Viewer

  • MDX Script Performance Analyzer


Analyzing query execution
Analyzing Query Execution

  • Cache matching, filtering and perfetching

  • Prefetching and Request Reordering


Storage engine bottlenecks and solutions
Storage Engine bottlenecks and solutions

  • Reduce Disk I/O

  • Using partitions and aggregations

  • Manually warming the cache


Formula engine bottlenecks and solutions
Formula Engine bottlenecks and solutions

  • Common causes

  • Dealing with CASE, IIF and NON_EMPTY_BEHAVIOR


Using stored procedures with mdx
Using Stored Procedures with MDX

  • What are MDX Stored Procedures

  • When would you create your own stored procedures

  • Deploying a .NET Assembly containing MDX Stored Procedures


Working with adomd server objects
Working with ADOMD Server Objects

  • Using ADOMD in .NET Assemblies

  • Common ADOMD objects



Amo net management stored procedures
AMO.Net Management Stored Procedures

  • What are AMO stored procedures

  • Advantages of AMO stored procedures


Considerations for extending mdx
Considerations for Extending MDX

  • Static and non-static functions

  • Handle null values appropriately

  • Performance


ad