reporting services - Include Empty Values in SSAS MDX query to use in SSRS -
i have cube derived 1 fact table has key , 3 other attributes
fact_event (eventid, ageband, location, type)
i want use reporting services create report following layout
select [event].[location].members on columns, [event].[type].members on rows, [event].[ageband].members on pages [events] [measures].[event count]
reporting services likes query flattened , measure in column such as
select [measures].[event count] on columns { [event].[location].members * [event].[type].members * [event].[ageband].members } on rows [events]
but when performed rows , columns not contain value removed. age band "[0-30]" might have "new york", "london", "sydney" "[31-60]" have "new york", "sydney"
i have mdx query return 0 london month.
the same goes event type event types mightn't occur particular month row of zeros appear month.
create dimensions based on attributes want slice by. once done ensure have "show empty cells" checked in query designer (or don't use non empty in mdx query). query should end like
select [measures].[event count] on columns { [location].[location].members * [type].[type].members * [ageband].[ageband].members } on rows [events]
Comments
Post a Comment