Tags » Multidimensional

2018 Multi-Dimensional Quantum Energy Report – Part 1: Overview | Lisa Transcendence Brown

Artist appreciation

******

2018 Multi-Dimensional Quantum Energy Report – Part 1: Overview

1/2/2018

As I did for the 2017 Multi-Dimensional Quantum Energy Reports, these will be broken down into 2-3 parts, because there is so much. 2,085 more words

Using the Resource Usage Profiler Event For SSAS Multidimensional Query Performance Tuning, Part 3: Aggregations And Indexes

Building aggregations in your SSAS Multidimensional will make your queries faster, right? While that’s true, they will only make a noticeable difference to performance if your query has Storage Engine-related problems rather than Formula Engine-related problems. 721 more words

Analysis Services

Using the Resource Usage Profiler Event For SSAS Multidimensional Query Performance Tuning, Part 2: Many-To-Many Relationships And Non-Materialised Referenced Relationships

You probably know that using many-to-many relationships or non-materialised referenced relationships can be bad for Analysis Services Multidimensional query performance. How can you measure their impact, though? 739 more words

Analysis Services

Mothering is Supposed to be Both Messy and Sweet (and So Are You!)

I spend a lot of time talking about the sticky parts of motherhood. That’s mostly because I’m all about showing my junk. I show my junk so you know you’re not the only one with junk. 239 more words

Motherhood

How To: Get data from OLAP cubes

Today I had to read some data from different OLAP cubes and show this information in our application. This could be accomplished using ADOMD.NET client library, which is the multidimensional equivalent to the ADO.NET libraries. 419 more words

English

Using the Resource Usage Profiler Event For SSAS Multidimensional Query Performance Tuning, Part 1: Rows Scanned And Rows Returned

If you’re performance tuning SSAS Multidimensional Storage Engine issues, the Resource Usage Profiler event can provide a lot of useful information about what’s going on behind the scenes when you run a query. 580 more words

Analysis Services

Build a Performance monitoring tool for SSAS using Power BI

I had the honor of speaking at PASS summit this year and I had a great experience. Thank you PASS organizers, board and volunteers for managing and running this event. 7,691 more words

Analysis Services