Home » Fusion Middleware & Colab Suite » Business Intelligence » Calculating Ageing fields - OBI Answers (OBIEE 11g 11.1.1.1.7)
icon5.gif  Calculating Ageing fields - OBI Answers [message #607655] Mon, 10 February 2014 11:29
mcintyresteven
Messages: 1
Registered: February 2014
Location: Walsall
Junior Member
Hi

The standard OBIA reporting for AR/AP Ageing is not reporting correctly therefore we have attempted to recreate the Ageing fields ourselves to reconcile with current reporting totals.

In terms of calculating the ageing fields for '1-30,'31-60′ etc we have had to hard code the dates

ie for December Fiscal Period selected or filtered the calculation for 'Ageing 1-30′ is : ifnull(FILTER("Facts AR Transactions"."AR Amount" USING ("Payment Due Date"."Payment Due Fiscal Day Date" BETWEEN timestamp '2013-12-01 00:00:00′ AND timestamp '2013-12-31 00:00:00′)),0)

How do we replace the dates in this expression to look at the Fiscal Period selected and filter the 'Payment Due Fiscal Day Date' accordingly?

The dates would need to move in each Ageing field based on the Fiscal Period that the user selects.

Thanks
Steve
Previous Topic: rpd password recovery in offline mode
Next Topic: Issue while creating total amount in etext xml publisher report
Goto Forum:
  


Current Time: Fri Mar 29 07:22:28 CDT 2024