Hi All,
I have a RS report based on a Dynamic Cube.
In the Rows of the Crosstab I have a Data item that is called [Rows] which has the folling expression:
filter(#'[CUBE].'+prompt('Rows', 'token','[Dimension].[Dimension].[Company]')# ,[Measure] is not null)
Then in the report I have a Value Prompt that has the following values:
Use Value Display Value
[Dimension].[Dimension].[Company] Company
[Dimension].[Dimension].[Supplier] Supplier
[Dimension].[Dimension].[Product] Product
I run my report and when I change the value in the prompt the rows change accordingly which is perfect.
However if I then drill down on a Company to see the departments under that company and then change the Prompt to Supplier then the rows no longer change. If i click Rerun at the top then it does but I dont want to have to add a refilter button, I want the auto submit to do it.
Any advice?
Cheers,
AM.