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 derfloh 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
Joined
Oct 19, 2002
Messages
1,982
Location
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 Question
SSRS2019 not able to connect Oracle19
Replies
0
Views
1K
dbsql
dbsql
DamienTaylor2021
  • Locked
  • Question Question
SSRS - Datasource - Update Credentials from Powershell or .rds file
Replies
0
Views
1K
DamienTaylor2021
DamienTaylor2021
Vasu100
  • Locked
  • Question Question
Populate Dynamic table columns based on parameter drop down values selection in SSRS report
Replies
0
Views
1K
Vasu100
Vasu100
Spunny
  • Locked
  • Question Question
SSRS Shared Dataset - send parameter values from actual report not working
Replies
0
Views
971
Spunny
Spunny
SandeA
  • Locked
  • Question Question
Using multi-select Parameter values in a text box
Replies
3
Views
721
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top