Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Filtration by Using Two Promps from Data Source SSAS Expand / Collapse
Author
Message
Posted Wednesday, October 30, 2013 2:59 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 6:47 AM
Points: 56, Visits: 184
Direction:
Display correct list of data based on two prompt, year and month, to filtrate the list by using SSRS.

Obstacle:
The data source is SSAS and I do not know how to create filtration based on year and month in SSRS?

Information:
*You must select year and then you can select month
*The year and month are filtration.
*It is a report created in SSRS.
*The environment is SQL server 2008
Post #1509950
Posted Wednesday, October 30, 2013 3:20 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:22 AM
Points: 12,206, Visits: 9,170
Define Parameters in the MDX Query Designer for Analysis Services (Report Builder and SSRS)



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1509955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse