Skip to Main Content
Forums

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!

period rolling function in obiee

875299Aug 20 2015 — edited Aug 26 2015

I want to get a period rolling for past 3 months in a report and i get below results when using period rolling function.

i have 2 hiearachies in date dimension for calendar & fiscal,so i have used below fx in period rolling

PERIODROLLING("Fact - Sales"."Amount", -2 ,0,"Sales"."Dim - Date"."Dim - DateDim - Year").

Please let me know,if ia ma missing something.

image.PNG

thanks
This post has been answered by Gianni Ceresa on Aug 22 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2015
Added on Aug 20 2015
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
7 comments
3,596 views