Mdx unplugged
This presentation is the property of its rightful owner.
Sponsored Links
1 / 22

MDX Unplugged PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

MDX Unplugged

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

Mdx unplugged

MDX Unplugged

Nauzad Kapadia

[email protected]

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


  • 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

Cell context and resolution order

Cell context and resolution order

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

How to create stored procedures with mdx demo

How to create Stored Procedures with MDX (Demo)

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

  • Login