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 » DAX » BISM   (RSS)
Showing page 2 of 2 (18 total posts)
  • Converting #MDX to #DAX and PowerPivot Workshop online #ppws

    I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already know MDX, you might wonder how to “translate” your MDX knowledge in DAX. I think that this ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 7, 2011
  • #BISM, Measures and a new blog from a #ssas development team member

    In the PowerPivot book and in the PowerPivot Workshop I mentioned the difference between implicit and explicit measures. The use of implicit measures might be confusing because at the end they are automatically created and maintained by the user interface of PowerPivot, but in reality the “real engine” doesn’t know the difference between ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 16, 2011
  • A #DAX training day and other sessions at #SQLBits

    It seems that the next SQLBits will be larger than ever! The SQLBits 9 will take place in Liverpool from 29th September to 1st October 2011. It will be hard to get a nicer weather than in Brighton, but we will try to bring a bit of sun from Italy! I and Alberto will deliver a whole training day on September 29th: DAX Deep Dive will be a full ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 11, 2011
  • Parent-child special calculations in #BISM #Tabular #Denali

    Alberto Ferrari published an interesting blog post regarding how to write particular calculations over a parent-child hierarchy in PowerPivot Denali (and in BISM Tabular, of course). One case is the Sum of Leaves (summing only the leaves of a parent-child hierarchy) and the other is the Sum of Children (computes all the nodes that are descendants ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 22, 2011
  • DAX Deep Dive at #sqlbits9

    I and Alberto Ferrari will present a DAX Deep Dive training day at SQLBits 9 in Liverpool, on September 29th. The conference will continue on September 30th and October 1st. Registrations are not yet open, but you should definitely save the date for SQLBits! The goal of our session will be to cover all of the aspects of DAX, starting from the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 4, 2011
  • PowerPivot, basket analysis and the hidden many to many

    Surfing on the web, here, I came into this intriguing question: How do we ask something like ''Show me how many customers have an iPad but don't have a book?'' We are speaking about a sales analysis where the canonical entities are Customers, Products and Sales. Moreover, because we have been used to speak about cycles since many years ago, ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on May 19, 2011
  • Microsoft updates its BI Roadmap - #ssas #bism #teched #powerpivot

    During TechEd 2011, Microsoft announced an important update to its BI roadmap. The reason why this is important is related to the previous announcement, which I discussed in November 2010 by including links to several sources and comments. At PASS Summit 2010 the announcement regarding the next version of SQL Server, codenamed ''Denali'', ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 18, 2011
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement