I would like to develop FDI table visualization that has DSO using 12 months and Rolling 12 months Revenue using Fiscal Period. Relative time function is not available for Fiscal period. How to calculate DSO and 12 months revenue.
Hi @Rupali V
What Subject Area are you using for this? As far as I am aware, all the OOTB subject areas have a relative time function.
If you create a custom calculation, there is a PERIODROLLING function that might help.
I am using Financials: AR Revenue, AR Transactions.
@Rupali V in that case try the periodrolling function above for your rolling 12 month calculation. In fiscal period there is also a trailing fiscal period column you could use for average using a filter statement where trailing period between 0 and 11.
Yes, I used trailing period number using filter from 0-11. what are corresponding fields from AR Revenue and Transactions to calculate DSO. Please refer if I need to use any other subject area.
Thank you!
@Rupali V in either AR Balance or AR Aging there is an Original Amount field. You could try that.
I am using PERIODROLLING function to get 3 months rolling revenue. I am getting correct values under column 'Total 3 M Rolling Revenue' except for last month Jan 26(Trailing period number=1) getting calculation wrong.
it should sum(revenue amt) for trailing period number =1,2 and 3 but it is skipping trailing period number =3 below is query for calculated field and screenshot with highlighted wrong value (87,418,618.43) . correct value highlighted green. I am using AR Revenue subject area.
CASE WHEN "Financials - AR Revenue"."Time"."Trailing Period Number" <= 10 THEN PERIODROLLING("Financials - AR Revenue"."Facts - Document Currency"."Revenue Amount", -2, 0,"Financials - AR Revenue"."Time"."Fiscal Calendar") END
@Rupali V - Can you provide me the Calculations you have used to Calcualate Total 12 M Rolling Revenue
@Rupali V that seems a strange one. If your year end is December it could possibly be something to do with adjustment periods in which case you would need to go to -4 for the first 3 months of the year or exclude them from the analysis somehow.
I tried with case statement for each period, and it worked.
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Hello Team, In the fusion source, we have the records maintained in multiple language say in english as well as in arabic.. ex: dept name is stored in both english and arabic in oracle fusion source with 2 records with different language code like EN and AR. But the same data in FDI is getting extracted only with the…
Hi Team, can oracle provide a standard decks to have a demo and presentation with new customer? Please share any links or attachments if available. Thanks, Manoj
All, I don't see there is a pre built data lieneage which gives more spectrum of solutions or answers for the BI leadership. 1.How many reports each users are owner and what is its path 2.Is these insights are sourced by Subject areas , data sets , Local Subject areas etc 3.Which content duty roles are associated to each…
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
hello, Is there a way to hide the "back" button in the FDI menu bar? Thank you in advance for your help!
