THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSAS » MDX   (RSS)
Showing page 2 of 2 (19 total posts)
  • The Microsoft BI Roadmap: BISM, UDM and Beyond

    Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 15, 2010
  • Using Dynamic MDX in Reporting Services: Part 2

    In this post, I continue my exploration of approaches to working with dynamic MDX in a Reporting Services dataset when you are using Analysis Services as a data source. I began this series with a look at string conversion functions in Part 1. In Part 1, the dynamic MDX relied on parameters that work as a filter on the query results. But what if ...
    Posted to Stacia Misner (Weblog) by smisner on October 8, 2010
  • Using Dynamic MDX in Reporting Services: Part 1

    If you're using Analysis Services as a data source for Reporting Services reports, you can build a simple dataset using the graphical query designer, but you'll want to switch to the generic query designer to create the MDX query string manually when you have more advanced requirements. Using the generic query designer, you can:· Impose greater ...
    Posted to Stacia Misner (Weblog) by smisner on October 7, 2010
  • PASS Workshop “Creating a BI solution from A to Z” - Interview

    If you’re still unsure if the workshop I’ll deliver at PASS Summit the next November - “Creating a BI solution from A to Z” - is a good choice for you or not, you can get some more details reading the brief interview here: PASS Summit Post-Con Preview - Davide Mauri Where you’ll find answers to the following questions: Is there an audience ...
    Posted to Davide Mauri (Weblog) by manowar on September 16, 2010
  • 24 Hours of Pass Summit Preview: Introduction to MDX

    Many thanks to everyone who attended my session today, Introduction to MDX. There was so much more I wanted to say, but the constraint of an hour required me to be very selective and, as you might have noticed, to sacrifice the demos. After all, how exciting can it be to watch me execute a query? I thought it more important to provide you with ...
    Posted to Stacia Misner (Weblog) by smisner on September 15, 2010
  • Reporting Services, MDX and the (unwanted) cascading parameters

    Reporting Services can be used in conjunction with Analysis Services, creating powerful reporting solution that can satisfy almost  any customer needs for “standard” reporting. For “standard” I mean solutions that has not be created using Excel and a Cube to give the user complete freedom (and responsibility) over data. In one of our current ...
    Posted to Davide Mauri (Weblog) by manowar on August 10, 2010
  • Get most out of partition slices

    Setting partition slice has always been an important optimization technique in Analysis Services. Every presentation talked about it and every whitepaper mentioned it, for example the Microsoft SQL Server 2000 Analysis Services Performance Guide contains a chapter appropriately named “Define the Data Slice for Each Partition”, here is a quote from ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on October 14, 2008
  • Notes about Notes from Microsoft BI Conference

    I was reading the blog post ''My notes from Microsoft BI Conference'' by Vidas Matelis. It is a collection of notes recorded at different presentations, chalk talks etc. I felt that I agree with some of them, disagree with some, and have no opinion about some. I felt like it would be useful to write down my thoughts about these notes. Of ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on June 2, 2007
  • SSAS Performance Tools

    Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer. It's a really interesting idea that will save me (and you) a lot of time trying to understand the root of a performance issue into an MDX Script of a cube. Thank you Chris, if I only had this tool three months ago! :-) Chris has also posted the news of an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 28, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement