Hi:
I apologize if this has already been asked. I could not find something on this topic in the archives.
I need to provide metrics reports across time, and am trying to figure out the best way to design this capability into the universe. I have fact tables for the various metrics that have a date in them. There are objects in the Universe built on the fact tables. For the sake of argument, let's say there is a metric named performance that is captured daily such that there will be a record for performance in the fact table for each day.
What would be the best way to set up objects that would allow a user to create a report that showed avg performance over the last six months, or by quarter in the last year, etc? Or, if this is kinda comlex for the user, how would I create it! <g>
I suspect that this is a typical requirement, perhaps there is a good document reference for this? Otherwise, I'm interested in hearing ideas.
Thanks.
I apologize if this has already been asked. I could not find something on this topic in the archives.
I need to provide metrics reports across time, and am trying to figure out the best way to design this capability into the universe. I have fact tables for the various metrics that have a date in them. There are objects in the Universe built on the fact tables. For the sake of argument, let's say there is a metric named performance that is captured daily such that there will be a record for performance in the fact table for each day.
What would be the best way to set up objects that would allow a user to create a report that showed avg performance over the last six months, or by quarter in the last year, etc? Or, if this is kinda comlex for the user, how would I create it! <g>
I suspect that this is a typical requirement, perhaps there is a good document reference for this? Otherwise, I'm interested in hearing ideas.
Thanks.