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   (RSS)
Showing page 1 of 15 (146 total posts)
  • Power Query now connects to Analysis Services #ssas #mdx #dax

    The last update of Power Query finally supports Analysis Services Multidimensional and Tabular. I waited this version for a very long time, but now it's finally here! Chris Webb already wrote an interesting blog post with several useful link and informations.  You can connect to both Multidimensional and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 26, 2014
  • What are useful tools and resources for DAX developers? #dax #powerpivot #tabular

    At the last PASS Summit I received an interesting question: is there a list of all the useful (I would say necessary…) tools for DAX developers? My answer was… “no, but this is an interesting topic for a blog post”. In the meantime, I thought that a page to keep updated would have been better, and of course an easy-to-remember URL is equally ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 20, 2014
  • Don’t use SUMMARIZE to sum your data–or just be careful #dax #ssas #powerpivot

    During the last PASS Summit I and Alberto Ferrari had long discussions at SQL Clinic with some of the developers of our loved tools. Sometime you really have to dig in the internals of certain feature to understand why there are some “unexpected” behaviors for certain functions. One of the discussions was about SUMMARIZE. This function can be very ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 18, 2014
  • BI Announcements at PASS Summit 2014 #sqlpass #powerbi #powerpivot

    This morning the PASS Summit 2014 started in Seattle and during the keynote there was several announcements from Microsoft. I’m considering here only the ones about Business Intelligence (you will find other blogs around about SQL Server). In the coming months, Azure SQL Database will get new features such as column-store indexes, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 5, 2014
  • Power Query support for Analysis Services (MDX)

    Today at TechEd Europe 2014 Miguel Llopis made the first public show of Power Query support for Analysis Services. This is still not available, but it should be released soon (hopefully it will be our Christmas gift!). Here is a list of features shown:It should be able to query both Multidimensional and TabularGenerates query in MDX (no DAX by ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 28, 2014
  • A strange behavior of AutoExist for MDX on Tabular models #powerpivot #ssas #tabular

    Alberto Ferrari wrote an interesting article about a strange behavior of AutoExist in normalized data models. I always say that a star schema is the best practice in Power Pivot and Tabular data modeling. The issue described by Alberto is another good reason to avoid snowflake schemas. I think that an example is better than many words. Consider ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 21, 2014
  • Questions and Answers about SSAS Tabular Models #ssas #tabular

    I recently delivered the online session Create your first SSAS Tabular Model at 24HOP Pass Summit, which recording is now available here. I received many questions and did not have enough time, so I answer now in this blog post. How do you prevent a user from aggregating certain measures where the result would be invalid (example: unit margin %)? ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 7, 2014
  • Advanced DAX Workshops in the upcoming months –#dax #tabular #powerpivot

    The adoption of DAX is slowly growing and we can see that from comments to article, blog posts, web site traffic (including DAX Formatter usage). For this reason, the demand for more advanced training about DAX is also increasing. We had great feedback from our last white papers (Using Tabular Models in a Large-scale Commercial Solution and SSAS ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 30, 2014
  • Simulate the SQL WHERE condition in DAX–#dax #powerpivot #ssas

    I recently wrote a short article about filtering data in DAX. In the last month I’ve seen a growing number of people with a SQL background going to Tabular, without having a previous experience of MDX. In my opinion, learning DAX is easier if you try to match its features to SQL rather than to MDX. The reality is that DAX is somewhere in the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 29, 2014
  • MDX Studio refresh

    If you work with MDX, using MDX Studio is a must, but it has not been updated for years. But community is great and Ihor Bobak has been able to apply two fixes: performance counters work with named instance and there is a single version regardless of the client libraries, so you have only one executable working with all available versions of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 11, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement