Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rolling 12MTD ( 12 months to date)

user10441472Mar 17 2011 — edited Mar 18 2011

my requirement is i have to display total , Pass and Fail records from rolling 12 months to to_date for every region.

Can i create one logical column in BMM layer for 12 months to date as time dimension . (i don't know how to create with AGO and Todate combination) .
(FYI: already i have time dimensions like year > quarter > month> date. )

Please help me to solve this issue.
Thanks in advance for your help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2011

Added on Mar 17 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

1,416 views