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: Monday, June 9, 2014 1:21 AM
Points: 58, Visits: 191
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 @ 1:55 PM
Points: 13,253, Visits: 11,033
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