Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
doodles
Starting Member
8 Posts |
 Posted - 2011-02-03 : 11:00:53
|
| Hi thereI need to build a report that allows users to choose two months for month on month comparisions (so two columns would appear on the report, for example, January and February). The data source is an SSAS cube.I got this working by having one multi-valued parameter on the report, bound to the CalendarMonth attribute in my time dimension. The user ticks two different months in the parameter list and the two columns appear on the report side by side. However, there is nothing stopping the user from selecting a third column which would mess up some other logic I have in my report. So basically i want to allow them to pick only two months (doesn't matter which) to compare.I assume I need two parameters (Month1, Month2) for example, and I need to bind both of these to my dataset somehow.Any assistance would be greatly appreciated!!ThanksDoodles |
|
|
kiruthika.P.
Starting Member
5 Posts |
Posted - 2011-02-04 : 04:19:34
|
| hi imagine ur gonna compare jan with feb.. for this create tables t1(to display jan details) and t2(to display feb details), dataset d1(for jan details) ,d2(for feb details) and d3(prompt values) and prompts p1(to select jan) and p2(to select feb).now populate the t1 with month attribute from dataset d1 and t2 with month attribute from dataset d2. for the prompt p1(here jan is selected) and p2(feb is selected) get the values from the dataset d3. apply the prompt p1 for dataset d1 and prompt p2 for dataset d2. don allow multiple values for the prompts..now ur user can select only one value from each prompts ..kirthi:) |
 |
|
|
|
|
|
Binding two separate parameter values to the same