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!

Run analysis for the previous month data only

user1106547Jul 25 2016 — edited Jul 27 2016

i want to run an analysis that displays data for the previous month.

so if i set up an agent to run say 1st day of every month, the data would display for the preceding month only.

i have created this field TIMESTAMPDIFF(SQL_TSI_MONTH,"Date (procedure)"."Date",CURRENT_DATE) which returns a value i thought i could filter on but the value returned isn't accurate.

For example if i run the report today to include data up to 26th july , early July values are 1 while later july values are 0. i would expect all july values to be 0, all june 1 etc.

Anyway above is probably not the right approach. Is there a simpler and accurate way to achieve this?

Any help appreciated

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2016

Added on Jul 25 2016

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

2 comments

1,245 views