Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cascading Prompt or Hidden Parameter

Status
Not open for further replies.
MDXer

MDXer

Technical User
Oct 19, 2002
1,982
US
SSRS 2005
SSAS 2005

I Have a report that uses a SSAS 2005 Cube as it's data source. I have to add 2 prompts with One of the prompt values being based upon the value of the other prompt.


In my cube I have [Date Dimension].[Fiscal MMMYY] which is the basis of the filters. THe need is for the user to select a Month year value and the second report parameter would be a LAG(12) of the users selection.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Status
Not open for further replies.

Similar threads

dbsql
  • Locked
  • Question
SSRS2019 not able to connect Oracle19
Replies
0
Views
663
dbsql
dbsql
DamienTaylor2021
  • Locked
  • Question
SSRS - Datasource - Update Credentials from Powershell or .rds file
Replies
0
Views
743
DamienTaylor2021
DamienTaylor2021
Vasu100
  • Locked
  • Question
Populate Dynamic table columns based on parameter drop down values selection in SSRS report
Replies
0
Views
788
Vasu100
Vasu100
Spunny
  • Locked
  • Question
SSRS Shared Dataset - send parameter values from actual report not working
Replies
0
Views
667
Spunny
Spunny
SandeA
  • Locked
  • Question
Using multi-select Parameter values in a text box
Replies
3
Views
334
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top