- Contents
Dashboard Help
Raw MDX Data Source
The Raw MDX data source allows you to define an MDX query statement to retrieve data from the database specified in the connection string in the Dashboard Web.config file.
Example
WITH
MEMBER [Measures].[SumOfAG] AS
'( Sum({[Time]}, [Measures].[RunningTotalSubs]))'
MEMBER [Measures].[SuperSum] AS
' (Sum({[Age Group].[13 and 17],[Age Group].[18 and
24],[Age Group].[25 and 34],[Age Group].[35 and 44],[Age Group].[45 and
54],[Age Group].[over 55],[Age Group].[less than 13],[Age Group].[UNKNOWN]
},[Measures].[SumOfAG] ))'
MEMBER [Measures].[GMale] AS
'( Sum({([Time],[Gender].[Male])}, [Measures].[RunningTotalSubs]))'
MEMBER [Measures].[GMalePer] AS
' ([Measures].[GMale] / [Measures].[SuperSum])'
MEMBER [Measures].[GFemale] AS
'( Sum({([Time],[Gender].[Female])}, [Measures].[RunningTotalSubs]))'
MEMBER [Measures].[GFemalePer] AS
' ([Measures].[GFemale] / [Measures].[SuperSum])'
MEMBER [Measures].[GUnknown] AS
'( Sum({([Time],[Gender].[Unknown])}, [Measures].[RunningTotalSubs]))'
MEMBER [Measures].[GUnknownPer] AS
' ([Measures].[GUnknown] / [Measures].[SuperSum])'
select {[Measures].[SumOfAG], [Measures].[GMale],
[Measures].[GMalePer], [Measures].[GFemale], [Measures].[GFemalePer],
[Measures].[GUnknown], [Measures].[GUnknownPer] }
on Columns, { ([Age Group].children) } on Rows from
[consumers] where ([Zone Id].&[501])