THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Analysis Servic... » Excel   (RSS)
Showing page 1 of 2 (14 total posts)
  • 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
  • Community Events in Köln (October) and Copenhagen November #ssas #tabular #powerpivot

    Short update about community events in Europe where I will speak. On October 11 I will present DAX in Action in Köln - all details in the PASS local chapter here: I will be speaking at a community event in Copenhagen on November 21, 2012. The session will be Excel 2013 ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 12, 2012
  • 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
  • Using SSAS 2005/2008 as PowerPivot Data Source: Dimensionality Lost

    This topic is general and not related to a specific feature of PowerPivot. In the way it is designed today, when data are imported from a SSAS cube into PowerPivot, the dimensionality of the original cube is lost and a flat table is imported as the result of a single MDX query. This approach should work in PowerPivot considering the way data are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 31, 2010
  • Using SSAS 2005/2008 as PowerPivot Data Source: Measures Are Imported as Text Columns

    Every measure imported from a SSAS cube is imported as a Text column instead of as a Numeric column. This is very annoying because users are used to use SSAS data with rich metadata, and a measure is usually numeric. Moreover, the standard aggregation used by PowerPivot for a Text column is Count - whenever the measure is a real count (thus, an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 30, 2010
  • Using SSAS 2005/2008 as PowerPivot Data Source: Direct MDX

    If you write direct MDX queries using SSAS 2005/2008 as a PowerPivot data source, it is better if you prepare your MDX query by using another editor. For example, write and test your MDX query by using SQL Server Management Studio and then copy & paste your query into the user interface provided by the Table Import Wizard. The remaining part ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 26, 2010
  • Using SSAS 2005/2008 as PowerPivot Data Source: Query Designer

    The query designer in PowerPivot has a few limitations that require the manual modification of the MDX query to get data that are often needed to create a PowerPivot model that compares data from cube with data from other sources (like Excel workbooks or external databases). For example, it is not possible to import the attribute key (the MDX ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 24, 2010
  • Using SSAS 2005/2008 as PowerPivot Data Source: Calculated Members

    A general problem of any cube is the way PowerPivot handles calculated members. From a technical point of view, it is absolutely correct that PowerPivot imports the result of a calculated member evaluated at the granularity of the query result. However, from the user point of view, it is not pretty clear why importing a calculated member it ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 19, 2010
  • Importing data from Analysis Services 2000 to PowerPivot

    Companies that have cubes on Analysis Services 2000 and still have not completed a migration to SSAS 2005/2008 might be interested in connecting to AS2000 from PowerPivot. Unfortunately, there are several limitations about using AS2000 as a data source for PowerPivot. Connecting issues The client PC where PowerPivot for Excel runs requires the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 17, 2010
1 2 Next >
Privacy Statement