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 » BISM   (RSS)
Showing page 2 of 2 (20 total posts)
  • Optimize Table and Column Size in #PowerPivot and #BISM #Tabular #SSAS #VertiPaq

    When you create a PowerPivot workbook or a BISM Tabular model (new in Analysis Services 2012), you store data by using the VertiPaq engine, which is an in-memory columnar database. Instead of considering the row of a table as the main unit of storage, it considers every column as a separate entity and stores data for every column in a separate ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 26, 2012
  • Pre-Conference Seminar at #TechEdEurope: #ssas #bism #tabular

    The Microsoft TechEd Europe 2012 will be in Amsterdam this year on June 26-29. The day before (25 June 2012) there are several pre-conference seminars and I’m glad to announce that I and Alberto Ferrari will deliver this one: Using BISM Tabular in Microsoft SQL Server Analysis Services 2012 […] After an initial introduction of the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 10, 2012
  • The Many-to-Many Revolution 2.0 #ssas #mdx #dax #m2m

    In September 2006 I had announced in this blog the release of the first version of The Many-to-Many Revolution, a whitepaper that describes how to leverage the many-to-many dimension relationships feature that had being available since Analysis Services 2005. The paper contains many generic patterns that can be applied in many common data ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 9, 2011
  • Separate date and time in #powerpivot (and #bism tabular)

    In PowerPivot you can import data from several sources and it is often the case that you import a DateTime column from a database. From an analytical point of view, you usually make analysis over dates (day/month/year/quarter/week) and over time (hour/minute) but to do that it is often useful to have two independent set of attributes: one for the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 1, 2011
  • Importing tables from #BISM Tabular model in #PowerPivot

    A BISM Tabular model can be browsed in Excel by using just the standard PivotTable like it was a regular Analysis Services cube (that now we call a Multidimensional model). If you are used to PowerPivot, this seems a limitation, because you cannot interact with your data by adding linked tables and modifying the data model. Moreover, because you ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 19, 2011
  • Drillthrough for #BISM Tabular and attribute keys in #SSAS #Denali

    In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL 2005 and now it will be available in both BISM Multidimensional and BISM Tabular in the next version of SQL Server “Denali”. In the current CTP3 you can already use the drillthrough on a Tabular model: by default, all the columns of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 17, 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
  • Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

    If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 19, 2011
  • #BISM Introduction and #PowerPivot Advanced Data Modeling #sqlbits video available

    As Chris announced in his blog, some of the sessions from the SQLBits 8 in Brighton are already available (for free!). Yesterday I watched more than half of my BISM Introduction session just to check that no NDA was broken. And, believe it or not, the session had to be really “balanced” in order to not disclose anything of the news announced at ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 28, 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