Monthly Archives: February 2013

Parametrized 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 MDX | Leave a comment

Microsoft Business Intelligence at a Glance Poster

The poster summarizes the benefits of Microsoft’s BI technologies and depicts them by layer: client (such as BI in Excel), the presentation subsystem (such as SharePoint 2013), information sources (such as Reporting Services), and data sources (such as relational databases). … Continue reading

Posted in SQL Server features | 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

SSIS for Azure and Hybrid Data Movement

SQL Server Integration Services (SSIS) can be used effectively as a tool for moving data to and from Windows Azure SQL Database, as part of the total extract, transform, and load (ETL) solution and as part of the data movement … Continue reading

Posted in SQL Server features | Leave a comment

SQL Server 2012 Edition Highlights

Image | Posted on by | 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

Microsoft BI Solution Builder

Using an interactive matrix, this tool enables you to see the BI capabilities in the products you own and shows you the additional products you will need to get BI capabilities you want. The tool also converts information such as … Continue reading

Posted in MISC | Leave a comment