mdx unplugged
Skip this Video
Download Presentation
MDX Unplugged

Loading in 2 Seconds...

play fullscreen
1 / 22

MDX Unplugged - PowerPoint PPT Presentation

  • 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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
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
  • 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