Hi Everyone,
I have a dataItem with the following in it:
set (#promptmany ('Parameter1';'MUN';'[Presentation Layer].[VU Vehicle Business Unit].[Unit].[Unit Desc(All)]->[all]')#)
and another nested to it which concatenates Month and Year. My report works great before nesting the Month-Year data item to it.
Any help would be much appreciated.
Mel
Quote from: mel4363 on 20 Aug 2014 04:32:52 AM
Hi Everyone,
I have a dataItem with the following in it:
set (#promptmany ('Parameter1';'MUN';'[Presentation Layer].[VU Vehicle Business Unit].[Unit].[Unit Desc(All)]->[all]')#)
and another nested to it which concatenates Month and Year. My report works great before nesting the Month-Year data item to it.
Any help would be much appreciated.
Mel
Hi,
I'm sure we'd help if we could, but you haven't actually told us what the issue is???
MF.
I apologise,
The issue is when I drill-up/and or down .. I defined the default drill behavior for both up and down but when I run the report this is just not possible.
Quote from: mel4363 on 20 Aug 2014 05:30:37 AM
I apologise,
The issue is when I drill-up/and or down .. I defined the default drill behavior for both up and down but when I run the report this is just not possible.
Hi,
Sorry - I must be having one of my "dim muppet" days today...
I'm still confused. What's not possible? What is the issue?
MF.
Okay.. I am probably phrasing this all wrong .. i'll start from the very top.
I am reporting off a FM Model using SQL as my datasource. I have then created a crosstab report with a tree prompt filtering on an Organisation Hierarchy i.e.
- Cluster
- Department
- Business Unit
now in my crosstab I have two columns 'Organisation' and 'Month-Year' and a measure on number of vehicles. The user wants to be able to drill-down on 'Organisation' whenever they chose to.
My challenge is when I run the report the drill-down function doesn't work. I tried to remove the nested 'Month-Year' column and noticed that the drill-down function works when I do.
Hope this clears things up.
Mel
Quote from: mel4363 on 20 Aug 2014 06:03:53 AM
Okay.. I am probably phrasing this all wrong .. i'll start from the very top.
I am reporting off a FM Model using SQL as my datasource. I have then created a crosstab report with a tree prompt filtering on an Organisation Hierarchy i.e.
- Cluster
- Department
- Business Unit
now in my crosstab I have two columns 'Organisation' and 'Month-Year' and a measure on number of vehicles. The user wants to be able to drill-down on 'Organisation' whenever they chose to.
My challenge is when I run the report the drill-down function doesn't work. I tried to remove the nested 'Month-Year' column and noticed that the drill-down function works when I do.
Hope this clears things up.
Mel
Hi,
Ok - thanks. I think the key issue here is how you implementsd your organisation filtering?
I just tried a quick test with the sample GO Sales (Analysis) package, which is DMR over SQL Server, just as you have.
I used Retailers instead of organisations, but it's the same concept. In my columns, I have a query calculation for retailers (type "other") with the expression
set([My Retailers hierarchy] -> ?RetailerParam?)
This results in a tree prompt for retailers.
I dragged the Year level of my Time hierarchy in as nested columns underneath this.
I used Product Line for my rows and Quantity for the default measure.
I enabled drill up and drill down for the report
When I run the report, I get prompted for retailer info via a tree prompt,and I can select one or multiple members. The results of this drive the major column headings in my crosstab. I can successfully drill down on any of these members.
I think the key thing we need to understand is what you have done differently?
Cheers!
MF.
Thanks Meep.
This has worked..
Thank you
Mel