Drill-up/Drill-down on Crosstab report

[mel4363]

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

[MFGF]

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.

[mel4363]

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.

[MFGF]

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.

[mel4363]

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

[MFGF]

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.

[mel4363]

Thanks Meep.

This has worked..


Thank you

Mel