LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating OLAP cubes in Excel 2007 Resh Excel Discussion (Misc queries) 4 May 6th 08 01:04 PM
Newbe trying to do Dynamic Parameters from a Worksheet Sean Cooper Excel Discussion (Misc queries) 0 January 22nd 07 02:56 PM
Can somebody help me to create offline cubes Rej Excel Discussion (Misc queries) 0 December 17th 05 12:56 PM
OLAP Cubes Steven Cheng Excel Discussion (Misc queries) 1 September 16th 05 05:46 AM
Excel pivottable with OLAP cubes saves names, not keys jerome Excel Discussion (Misc queries) 0 April 13th 05 07:49 AM


All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"