Search Results: mdx

• 
  Reporting on an SSAS Cube with SSRS 2008

  In this article, Dustin gives you an introduction on building a report on a cube using the MDX Query Designer.

  Author:  DustinRyan     Date: 5/7/2010     Section: Article

  tags : MDX query, MDX query designer, SSRS cube report, SSRS 2008
• 
  Writing Parametrized MDX for Reporting Services

  In this article, you will learn how to write your own MDX inside of Reporting Services and actually add parameters to the your query. No longer will you be forced to use the Query Designer!

  Author:  DevinKnight     Date: 9/30/2010     Section: Article

  tags : MDX, SSRS
• 
  How to permanently display a hidden data set

  So if you have ever worked with reporting from a cube you should know that the query designer will create and hide a dataset if a parameter is created. One option to display this dataset is by right clicking on the datasets in the 'Report Data' tab and ch

  Author:  ChrisAlbrektson     Date: 10/13/2010     Section: Blog

  tags : MDX, Show Hidden Datasets
• 
  MDX Parameter Suppress Auto Update

  I discovered this issue the other day while creating a report from a cube. I used the query designer to build a report with a few parameters. The query designer did a great job of building the MDX for me but the client wanted something a little bit more c

  Author:  ChrisAlbrektson     Date: 10/26/2010     Section: Blog

  tags : MDX, Parameters, SSRS, SuppressAutoUpdate
• 
  SSAS Calculation Formatting Not Showing in Excel 2007 or Excel 2010

  Occasionally in SQL Server 2005 and 2008 Analysis Services, you'll build a cacluation and set the formatting to be a value like a currency and are surprised that in Excel 2007 and 2010 the formatting does not carry over. The "randomness" of this actually

  Author:  BrianKnight     Date: 10/1/2010     Section: Blog

  tags : calculation, excel 2007, excel 2010, mdx, ssas
• 
  MDX Puzzles: First Strike

  So today I start posting the weekly MDX puzzles I mentioned last week . And like I had also mentioned, each correct answer to an MDX puzzle will get you an entry into the end of the month drawing for a prize. What will that prize be? Well at this point, I

  Author:  DustinRyan     Date: 10/25/2010     Section: Blog

  tags : MDX puzzles, MDX
• 
  MDX Puzzles: Double Deuce Action

  Well last week's MDX puzzle showed us how to use the Ancestor function to navigate the levels of a hierarchy. This week's MDX puzzle is all about navigating within a single level of a hierarchy. If you need a referesher on a hierarchy and how the levels f

  Author:  DustinRyan     Date: 11/1/2010     Section: Blog

  tags : MDX puzzles, MDX