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 |
|
mind_invader
Starting Member
24 Posts |
 Posted - 2008-02-21 : 04:35:14
|
| how do i create a parameter in hierarchy?SAMPLEbilling period: YEAR 2007 1st quarter jan feb mar 2nd quarter april may junesomething like that.... if the user chose the 1st quarter the report will generate a sum-up report for the 1st quarter of 2007...kindly reply asap.. i really need to get this report working..thanks! |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2008-02-21 : 07:51:17
|
| Is this an analysis server question or reporting server question? Building a time dimension in SSAS is really pretty straight forward; I believe there is even a wizard to help you with it ...Jayto here knows when |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-21 : 12:15:53
|
| Do you mean population of parameter combos? or presentation of report results? Please explain. |
|
|
|
mind_invader
Starting Member
24 Posts |
Posted - 2008-02-21 : 15:50:08
|
| this is on the reporting services... i want a parameter selection for the user.. im wondering if i can create a parameter that in hierarchy.. year--quarter--month just in one parameter drop down box...desired report will be a matrix that can be drill down into months...im sorry.. im just new to this SSRS and SSAS so i dont really know if my question even make sense... but im just looking at the possibility that my desired result can be achieved using SSRS... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-22 : 01:54:30
|
| I think your scenario can be achieved by three parameter dropdowns.First one allows you to select a year(containing 2007,2008,...). Second one will contain periods(quarter,halfyear,fullyear).and third one with months.You can use the combination to generate you summary data in report. If you have a calendar table, you can use it for population of values inside combo. If you want to make these parameters dependent, you can do that too by passing high level paramters selected value as a parameter for population of next params dataset. |
|
|
|
mind_invader
Starting Member
24 Posts |
Posted - 2008-02-22 : 15:48:04
|
| okay... but how about if i want to make a matrix with drill down details of month's data?for example, i will use three parameters... year, quarter, month... but if the user chooses to select on the year parameter only i want the report to be a matrix with drill down column per quarter and months.... and if the user chooses year and quarter, drill down for months only... |
|
|
|
|
|
|
parameter hierarchy