Category Archives: SSAS

How to restore PowerPivot excel file as a SSAS Database.

Basically PowerPivot stores the data inside the In memory analysis services (Vertipaq). You can restore the inside database into the SSAS tabular or SharePoint instance. Following are the easy steps to get the inside database from the PowerPivot file: 1. … Continue reading

Posted in PowerPivot, SSAS | Leave a comment

SSAS NameColumn Property format Issue :

I am trying to format the Name column through the format property. Rather than to create the named calculation in the DSV and then use it as a name column. I did this test both in 2008 r2 and 2012 … Continue reading

Posted in SSAS | Tagged , | Leave a comment

Gartner releases 2013 BI Magic Quadrant

As a follow-up to the data warehouse Magic Quadrant, here’s a roundup of Gartner’s annual Business Intelligence Magic Quadrant report. Gartner releases 2013 BI Magic Quadrant

Posted in SSAS | Leave a comment

Common Analysis services design mistake how to avoid them by -Chriss web.

I like this presentation that’s why i want to share with you guys as well as. Common Analysis services design mistake how to avoid them by -Chriss web. i hope you enjoy this presentation by Chriss Web.

Posted in SSAS | Leave a comment

Enterprise Data Warehouse Bus Matrix

When you combine the list of EDW subject areas with the notion of conformed dimensions, a powerful diagram emerges, which we call the enterprise data warehouse bus matrix. A typical bus matrix is shown in following figure: At the beginning … Continue reading

Posted in SSAS | Tagged , | Leave a comment

Using DirectQuery in the Tabular BI Semantic Model.

This paper introduces DirectQuery, a mechanism for directly querying a SQL Server data source for Analysis Services tabular models. Readers will learn when and how to use DirectQuery in SQL Server 2012. https://zaimraza.files.wordpress.com/2012/07/directquery20in20the20tabular20bi20semantic20model1.docx

Posted in SSAS | Tagged | Leave a comment

Parameterized MDX.

When you are building SSRS reports from cube and in your reports you have certain number of parameters and you want to verify  MDX before putting into the report. Like SQL you can create parameterized query in MDX using the … Continue reading

Posted in SSAS | Leave a comment