Sunday January 21st 2018




How to access mdx query builder

1- In business Intelligence Studio, Start new Report project.
2- On the select data source, name your data source, and select Microsoft SQL Server Analyses Services in the type option box and then press edit connection string button.
3- On Connection Properties enter the name of your server and then select Database Name.
4- On report wizard screen click next.
5- You will be at Query Builder screen where you can use Graphical query builder.
6- Note In the above steps you can select Query Builder in Report Project.
Please see the previous post on the same topic