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 » excel » SSAS   (RSS)
  • Common request: export #Tabular model and data to #PowerPivot

    I received this request in many courses, messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature people (including me) would like to see: Create an empty PowerPivot workbook with the same ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 19, 2013
  • DAX Studio for Excel 2013 finally available! #dax #excel #powerpivot #ssas #tabular

    I'm so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog, this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this new release, but unfortunately it will require some weeks because I'm traveling a lot in these ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 4, 2013
  • LASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular

    During a PowerPivot Workshop course we received an interesting question from a student: “Can I use LASTNONBLANK (and FIRSTNONBLANK) with a column which is not a date column?” The reason is that we introduce LASTNONBLANK in the Advanced Time Intelligence module, because its typical use case is on a date column. However, you can use these functions ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 19, 2013
  • Execute a #DAX Query on #SSAS #Tabular in #Excel

    Apparently Excel does not offer a way to import data in Excel by using a DAX query on Analysis Services. The Data Connection Wizard seems to offers only the ability to create a PivotTable when you connect to Tabular, but not a Table (see the Table option disabled in the next picture). However, the workaround is to create a connection file and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 31, 2013
  • Some more comments about XLCubed

    Some weeks after my blog post about Bonavista Dimensions I’ve been able to look at a comprehensive demo of XLCubed, but since then I’ve been too busy to write about that (and in general to blog – I have several topics I will blog about as soon as the job pressure will allow me to do that). And I finally found the time to write this post! First of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 9, 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
  • Microsoft BI Conference 2008 - announcements on stage

    We’ve seen it on stage. It’s Excel on the steroids. I’m talking about “big announcement” here at Microsoft Business Intelligence Conference. The several announcements are: ·         Madison: the announcement of integration between SQL Server and DATAllegro, release expected within 1H 2010. Look at it if you ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 6, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement