<p>Hi All,</p>
<p> </p>
<p>Let me put my requirement first:</p>
<p> </p>
<p>Create a common data model with direct/calculated measures and dimension.</p>
<p>1 report which uses the above model and has a Crosstab along with 50+ filter prompts and 2 dropdown selections.</p>
<p> </p>
<p>Let me explain the dropdowns first:</p>
<p>The first dropdown, D1, will comprise of all the dimensions names i.e. Age, Gender, Country, Employer Name etc.</p>
<p>The second dropdown, D2, will comprise of time dimensions i.e. Year, Quarter and Month.</p>
<p> </p>
<p>The crosstab will run on a default value from D1 and D2. For example, if D1 default = Year and D2 default = Gender, then the crosstab rows should have all the year values i.e. 2012, 2013, 2014 and the crosstab columns should have all the gender values i.e. Female, Male and Others. And the fact cells will have direct and calculated measures.</p>
<p> </p>
<p>Now, the D1 i.e. Gender and D2 i.e. Year box should be parameterized. I mean, when I select Gender in D1, the crosstab should get cut on all gender values. When I select Country in D1, then the crosstab should get cut on all the country values. Similarly for dropdown D2. If I select Quarter, then the rows should change from Year to Quarter values. User should be able to do this on the report screen.</p>
<p> </p>
<p>Also, the 50+ filters should be all multi-select list boxes present on the report page where user can filter values.</p>
<p> </p>
<p>These two are my basic requirement. Develop multiselect filter list boxes and create dropdowns to dynamically change rows/columns dimensions in the crosstab.</p>
<p> </p>
<p>Looking forward to some suggestions/advice from this community.</p>
<p> </p>
<p> </p>
<p>Best Regards</p>
