ms ssas 2008 & mdx reports
TRANSCRIPT
MS SSAS 2008 & MDX Reports
BYOkoro Sunny U
1
Contents
SQL Server Management Studio..................................................................................................................3
Microsoft PowerPivot................................................................................................................................15
Microsoft Report Builder...........................................................................................................................23
Microsoft Power Query.............................................................................................................................29
SQL Server Reporting Services (SSRS 2008)...............................................................................................33
Tableau......................................................................................................................................................42
2
3
SQL Server Management Studio
4
5
6
Results Abbreviated
SQL Server Management Studio
Microsoft Visual Studio 2010
7
To eliminate empty or null columns use non empty in MDX query
8
9
10
11
12
13
Results Abbreviated
14
15
Microsoft PowerPivot
16
Microsoft SSMS MDX version
17
Microsoft PowerPivot Format
18
19
20
21
22
23
Microsoft Report Builder
24
25
26
27
28
29
Results Abbreviated
Microsoft Power Query
30
31
Canada
32
France
33
SQL Server Reporting Services (SSRS 2008)
The original report created by Report Builder earlier was imported into SSRS using the same SSAS data connection to create the data source.
34
For this report to be deployed to SSRS 2008 server, a SQL Server based authentication has to be used.
35
36
37
Results Abbreviated
38
39
40
41
42
Tableau
43
44
Report 2
45
46
47
48
49
50