‘Analysis Services’ Archives
sql server 2008 adventureworks – cannote deploy Cube
This post is response to problems in deploying Adventureworks 2008 cube. I faced connectivity issues to Analysis services on deploying Cube, when I only have the SQL Server 2008 Express edition. It is not clear what exactly can be achieved with SQL Server 2008 Express edition only. So I downloaded the Sql Server 2008 evaluation edition and [...]
MDX query Builder in Sql Reporting services 2008
I would like to share my hands on experience of Query builder in SQL Reporting Services 2008. We created a report in Sql Reporting Services 2008 utilizing Analysis Services Database. We can create MDX queries by drag and drop Dimension and measures in their respective areas. MDX code will be automatically generated and can be viewed by pressing [...]
