Dynamic Parameters in Excel Cubes

[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

 

[Luke M]

First problem, you could setup a cell with formula
=MONTH(TODAY())

Second problem, you can use dynamic validation
http://www.contextures.com/xlDataval02.html

Then, setup your query to reference the appropriate cells and use them as
parameters.

 

[Erwin]

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