Display the MDX query of an Excel 2007 PivotTable
Most of end users navigate into Microsoft SQL Server 2008/2005 Analysis Services Cube with the help of Microsoft Excel 2007. Sometimes they may produce report while browsing Cube data.
Most of them having curiosity about MDX (Multidimensional Expressions) generated by Excel in background. Here is the way to get that MDX out of Excel Sheet. Read more…
SSRS Expressions
Very practical expressions, when you create SSRS Reports in your day to day development.
1. Lets start with the easiest of the expressions i.e. To get Today’s date
=Today Read more…
Connect Analysis Services 2008/2005 from Different Domain Use
In one of my project I was working with Remote client. Basically, SQL Server 2008 Analysis Services Objects were available at Remote server. Me & my team were developing Reports on that SSAS with SQL Server 2008 Reporting Services. Read more…
Comming Soon….!!
Welcome to BIAuthority.
BIAuthority is Blog Related to SQL Server 2005/2008 Business Intelligence.
More Posts are comming soon…..
BI Big Data Authors
Sandip Shinde
Manish Kaushik
Suhas Kudekar(MCC)
Umesh M Patil
YashwantOur Visitors
Big Data, Data Analytics and Data Science | BI-BIGDATA.com 