Drilldown from slice report to cube view

[ajt]

Hi,

I wonder if anyone has a resolution to the following challenge I am having...

I am using Xcelerator 9.5 and am trying to drilldown from a excel slice to another report (either active form or cube view). The report I am drilling down from has a dimension for account code and the consolidated elements are used in the report. I am trying to drill to a subsequent report that displays the childen of the cell I am drilling down from on the row dimension. i.e. Total income would show on the main report but the drill down report needs to show the account codes that make up this number in the row dimension of the next report.

The problem is that I can pass the title elements and filter that way but I can't dynamically filter by the same row dimension.

I have created a drill process that dynamically populates a subset from the children of the cell i have selected. The problem with this is that this need to be used in a multi user environment and if user A drills down and sets the subset elements then user B drills down on a different cell, the subset will change for user A is they refresh the report.

If anyone has any ideas it would be much appreciated

Thanks