I have 2 questions.
1. How do i represent non-fact attributes in measures area without aggregating the values. For instance I need to display Month in the Column Area and Application ID in the Measures level and Department in the Rows Area. Is there any option to achieve this.
2. For rolling Months i have checked the previous questions. But Moving Sum is not a feasible solution. If i am reporting from Apr 2010, then for Apr 2010 i need to display (Feb+Mar+Apr) for it. What is the function to achieve this. Can i do it with To_date. IF so, can anyone illustrate with an example.