Dynamic Parameters in Excel Cubes
 

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

Dynamic Parameters in Excel Cubes
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Erwin" wrote:

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

Dynamic Parameters in Excel Cubes
 

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

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Erwin" wrote:

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