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!

Condition Surpression in HFR-----Really Really Urgent

674848Mar 8 2011 — edited Mar 14 2011

Hi All,

we are having a requirement from our client that
If he selelcts the current year then the Scenario shud be Actual, if he selects the next year then the scenario shud be Plan can any one help me in solving this

Actual Requirement from the client

FYadmin = Current fiscal year
MONTHadmin = Current month
LASTQRUPLANadmin = Last scenario (QRU1, QUR2, QRU3, PLAN…)

Current position on the report :
FYreport = Fiscal year selected in the report
MONTHreport = March (default last month of the fiscal year at SOITEC)

Actual_QRU calculation rule:

IF ( FYreport < FYadmin ) OR ( (FYreport = FYadmin) AND (MONTHreport < MONTHadmin) )
THEN Scenario = ACTUAL
ELSE Scenario = LASTQRUPLANadmin

This a really urgent isuee

Regards
Vijay

Edited by: Kumar on Mar 8, 2011 5:16 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2011

Added on Mar 8 2011

#business-intelligence-applications, #business-intelligence-foundation, #hyperion-query-and-reporting

4 comments

180 views