Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
how to create map report using dynamic mdx?
11 views
Skip to first unread message
halid laguide
Jan 27, 2013, 7:16:00 PM1/27/13
to
Hi All
I would like to enquire, is there a way to generate dynamic map report. My scenario is as follows:
I use SSRS 2008R2 and my data is in a cube.
In my cube I have 3 dimensions:
Geographic Dimension with hierarchies (country -> Department -> Towns)
Activity with hierarchies (group - > Subgroup -> Family)
Time with year
And a Measure: Value
I want to build a report which displays in a map the measure value in function of parameters.
I want that the users select one (or more) member is the dimension geographic whatever the hierarchy( country and towns for example)
and select one (or more ) member in the dimension Activity (1 group and 1 sub-group for example)
The difficulty is to navigate between the geographic hierarchy and Activities for the same dataset.
Do you have any idea ?
Thank U
I would like to enquire, is there a way to generate dynamic map report. My scenario is as follows:
I use SSRS 2008R2 and my data is in a cube.
In my cube I have 3 dimensions:
Geographic Dimension with hierarchies (country -> Department -> Towns)
Activity with hierarchies (group - > Subgroup -> Family)
Time with year
And a Measure: Value
I want to build a report which displays in a map the measure value in function of parameters.
I want that the users select one (or more) member is the dimension geographic whatever the hierarchy( country and towns for example)
and select one (or more ) member in the dimension Activity (1 group and 1 sub-group for example)
The difficulty is to navigate between the geographic hierarchy and Activities for the same dataset.
Do you have any idea ?
Thank U
0 new messages