Hello all, I need help in designing my Framework model;
I have a detail table and a aggrgate table. i am building a model using both aggregate and detail table in framework manager. my cube is based on the aggregate table. i have a requirement that when a user drills down on a column like "YTD " for a measure "Sales", it should drill down and show the respective YTD values at each level he drill down to. As he drills down and gets to the details, the data is fetched from the detail table. Now how do i implement this into my model, so that when a user drills down through cube (which is built using aggregate table) to the detail table. I want to get YTD values at each level he drills to.
Lets say, for example, like in Crosstab, we have time mapped to ROWs,
Column as YTD
Measure as Sales Amount.
Now when i drill down on YTD value for YEAR, to Quarter" level, I should get the YTD value of sales amount at the Quarter level,
and so on.
I hope I have made myself clear.
Let me know if u hav e come across anything of this sort.
Any ideas/suggestions would be highly appreciated.
Thanks..