Dynamic Parameters in Excel Cubes

  • Thread starter Thread starter Erwin
  • Start date Start date
E

Erwin

Hi all,
I am trying to build a report in Excel connected to a cube, using dynamic
parameters. My problem is that the parameters can't be made dynamic. I would
like to do 2 things that I can do in SSRS Reports:

1. I would like to make my time parameter dynamic so that opening the report
automatically adjusts the parameter to the current month.

2. I would like to have parameters which filter other parameters. For
example selecting a region would limit all lower lying parameter values to
that region.

Anybody done things like this?

Thank you!
Erwin Velthuis
 
Hi Luke,
Thank you for your quick reaction, I have found these solutions on several
sites but I don't see how you apply them to a PivotTable connected to an SSAS
Cube. I can't find any way of changing parameters, other than changing them
in the cube.

Greetingss,
Erwin
 
Back
Top