Hi, thank you so much for yours videos, I have one questions,I want to add a calculated column between dates but the invoice date field brings lines without value, it is possible to do some null value changes?
First of all, thank you for the feedback, I appreciate that. Feel free to connect with me on LinkedIn as it might be easier to ask questions. I am assuming you want to check if a column value is NULL and return a value if it is NULL. You could use the IFNULL function. The format is IFNULL(column,value). If the column you are checking is, let's say, "DISCOUNT_AMOUNT". You will have the formula as IFNULL(DISCOUNT_AMOUNT,0). You will be able to do this in the BI Analysis editor. Hopefully that helps.
I am assuming you are asking about demo instance. Some of companies offer access to oracle fusion instance if you subscribe to training from them. If you have access to demo.Oracle.com you should be able to access fusion instances
Great video. Thank you
Thanks for the feedback
thank you sir
This is really helpful 👍
Hi, thank you so much for yours videos, I have one questions,I want to add a calculated column between dates but the invoice date field brings lines without value, it is possible to do some null value changes?
First of all, thank you for the feedback, I appreciate that. Feel free to connect with me on LinkedIn as it might be easier to ask questions.
I am assuming you want to check if a column value is NULL and return a value if it is NULL. You could use the IFNULL function. The format is IFNULL(column,value). If the column you are checking is, let's say, "DISCOUNT_AMOUNT". You will have the formula as IFNULL(DISCOUNT_AMOUNT,0). You will be able to do this in the BI Analysis editor. Hopefully that helps.
How to use this Oracle Vision?? Does it require a licence? I googled about it did not find anything
I am assuming you are asking about demo instance. Some of companies offer access to oracle fusion instance if you subscribe to training from them. If you have access to demo.Oracle.com you should be able to access fusion instances
Please let me know if it will help me to create report now also in 2024?
Yes
Thanks for your reply. You are doing a great job indeed. @@atarunraj
Hi Arun Sir,
Could you please let me know about OTBI Analysis and Reports for HCM?
Hi Farha. Are you looking for specific examples of OTBI reports in HCM?
Please Help me with formula its not working. Where I do mistake.
Without seeing what you did, it will be difficult to help.