Skip to content
  • Twitter
  • Linkedin
  • Pinterest

Devin Knight

  • Home
  • Training
  • Services
  • About Me

Tag: MDX

Analysis Services Dynamic Security

September 3, 2014 devinknight

Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted

Continue reading

MDX Time Calculations Built to Scale

August 14, 2014 devinknight

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS they likely have spent several

Continue reading

Writing Parametrized MDX for Reporting Services

August 4, 2014 devinknight

Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long.  If all you need is the Query

Continue reading

MDX – Color Formatting on All Measures at Once

November 4, 2010 devinknight

In a post a while back I wrote about how you can create conditional color formatting on the Analysis Services measures you create.  Recently I

Continue reading

MDX Aggregate Named Set Than Others

September 17, 2010 devinknight

In this quick post I wanted to provide some code that’s been useful to me recently.  This MDX statement creates a named set of the

Continue reading

MDX – Calculating the Percent of a Named Set

September 8, 2010 devinknight

Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic is needed to be built

Continue reading

Using SSAS MDX Calculation Color Expressions

March 17, 2010 devinknight

Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also have another little feature that

Continue reading

Solving All Versus (Select All) SSRS End User Confusion

March 12, 2010 devinknight

When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in

Continue reading

MDX Utility Belt of Calculations Part 4

December 7, 2009 devinknight

This is part four in the series of blog posts that will help in building a library of calculations you can use as a reference

Continue reading

MDX Utility Belt of Calculations Part 3

December 3, 2009 devinknight

This is part three in a series of blog posts that will help you build an arsenal of MDX calculations that you can have ready

Continue reading

MDX Utility Belt of Calculations Part 2

December 1, 2009 devinknight

This post is a part of a series of blog posts I am writing to give you a Batman-like Utility Belt of MDX calculations.  With

Continue reading

MDX Utility Belt of Calculations Part 1

December 1, 2009 devinknight

Developing MDX calculations is one of the most confusing and time consuming pieces of building an Analysis Services cube.  That is why I have accumulated

Continue reading

SSRS – Setting Default Parameter Values for Analysis Services Datasets

October 23, 2009 devinknight

When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult to dynamically set default parameter

Continue reading

Search

Devin Knight

SQL Server MVP

Follow me on Twitter

My Tweets

Categories

  • Azure (5)
  • Books (2)
  • Data Mining (1)
  • Excel (7)
  • MDX (7)
  • PerformancePoint (5)
  • Power Automate (16)
  • Power BI (12)
  • Power BI – Problem, Design, Solution (3)
  • Power BI Custom Visuals (118)
  • Power BI Interview Questions (3)
  • Power BI Monthly Digest (31)
  • Power BI Q&A (7)
  • Power Map (3)
  • Power Platform Quick Tips (4)
  • Power Query (13)
  • Power View (10)
  • Power Virtual Agents (4)
  • PowerApps (1)
  • PowerPivot (18)
  • Scripts (1)
  • Social (2)
  • Speaking (42)
  • SSAS (24)
  • SSIS (33)
  • SSRS (26)
  • T-SQL (5)
  • This Week in Data (16)
  • Training (2)
  • Uncategorized (1)
  • Visio (1)
  • Visual Studio (2)
  • Windows (1)

RSS Feed

RSS Feed RSS - Posts

Create a website or blog at WordPress.com
  • Follow Following
    • Devin Knight
    • Join 156 other followers
    • Already have a WordPress.com account? Log in now.
    • Devin Knight
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...