Great Job ! Quality and precise content !! Gonna recommend many more peers in my company.
@atarunraj
3 жыл бұрын
Thank you. Much appreciated. :)
@vakeeshganeshar9623
Жыл бұрын
Thank you Arun. This is really helpful and well explained
@RonaJ
3 жыл бұрын
This is terrific! Thank you
@atarunraj
3 жыл бұрын
Thank you for the feedback.
@SachinSurendranwhaleshark
4 жыл бұрын
This is greater than great
@mahmoudhamdy9550
Ай бұрын
awesome thank you
@visitermanvisiterman8513
2 жыл бұрын
This is greater tutorial,lot of thanks,plz do you have any toturials about Order management Setup recorded by you , also even if it costed
@vpilanbr
3 жыл бұрын
Excellent! That has helped me a lot! Thanks!
@atarunraj
3 жыл бұрын
Great to know. Appreciate the feedback
@vivekclement
4 жыл бұрын
Very Nice ! Keep up the good work !
@danfreeman6096
4 жыл бұрын
Dude! Good to see ya
@ahmadfathy8660
3 ай бұрын
Thaaaaaaaaaaaaaaaaaank you
@hthyagar
7 ай бұрын
Great video Arun. Do you have recommendations on how to create a drill through from a GL Balances Subject area to Accounting Hub or supporting references?
@atarunraj
7 ай бұрын
I will have to check this one. Never ran into this scenario.
@suzannefreeman7556
3 жыл бұрын
Good stuff I could not figure out how to filter on the Summary column. I thought prompted was only for Dashboard Prompts. Thanks!!!
@atarunraj
3 жыл бұрын
Glad it helped.
@binniesaini8804
4 жыл бұрын
This is great!
@mohamedrehan4256
Жыл бұрын
Excellent work !! but what if we need to show the subtotal amounts just in case we click on the supplier from the summary report and not to be shown in the original detailed analysis, could you please suggest a solution?
@atarunraj
Жыл бұрын
Not sure i truly understood the question. From Summary report you want to click on supplier and then you should be able to see the total for that supplier? But you don’t want to see the amounts in the detailed analysis? What does the Summary report consist of? Just the supplier details and no amounts? You could link two different analysis in the Summary analysis. One where you click on supplier and show the amounts. One detailed. Or you could have the following drill down navigation. Summary - analysis 1 (with sub totals)- analysis 2 (detailed). Essentially 3 different analysis.
@RaghavendraM
2 жыл бұрын
Hi Arun, great videos. Can we add back button in details page so that I can go back to sumary page and come back to details page again
@atarunraj
2 жыл бұрын
Thanks for the feedback. Appreciate it. If you use a dashboard the back button is already there. If you are just using an analysis you can click the browser back button to go back. Let me check if there is a way to include a html link in the analysis page.
@DiegoFernandoZegarra
9 ай бұрын
Hello Arun, I have created a Report based on data model after it was added to the landed page into a box(With sandbox) the report templeate is a circular graphic and its Interactive by default, Can I add and action link to press there and be redirect to a bigger report?
@AlexandreDoNascimento-f5j
Жыл бұрын
Arun, thanks for all the great content! Is it possible to navigate to the actual transaction? For instance, if my analysis provides a list of supplier invoices... can I enable to option to click on the invoice number and open the actual transaction in AP?
@atarunraj
Жыл бұрын
It is possible. You can enable drill through to view AP Invoices
@aidacodrington8842
Жыл бұрын
Hi Arun, how are you? I have a question about the drill down function. Can you also do this with two reports from different subject areas for example with a report from subject area ‘General Ledger Transactional Balances real time’ and ‘General Ledger Jounals real time’?
@atarunraj
Жыл бұрын
Hey Aida. That’s possible. I have currently implemented something similar. Payments subject area to Invoices transactions subject area. We need common elements in both subject areas for this to work
@diyaplaysroadto3018
2 жыл бұрын
Do the field names must match on both summary and detail analyses; to which you are trying to prompt on?
@evangelinaaceituno6220
3 жыл бұрын
Thank you it was very helpfull. I have a questions is there any possibility to create a calculated field to this analysis? for example calculate the percentage of efficiency between invoice date and payment date?
@atarunraj
3 жыл бұрын
Glad this was helpful. Yes, you can create calculated fields. If you check my latest video I show one example of creating the calculated field. You can skip to the GL example that I have shown in the latest video. Let me know if you still have questions and I will be happy to help.
@adnanalrashed9477
3 жыл бұрын
Very good .. if you can help me . I want to create OTBi from Central planning module
@AbouZaidou
3 жыл бұрын
Awsome ! Is there any way to go directly to the details just in one click ( on the party name ) ?
@atarunraj
3 жыл бұрын
Hi Khalil. You have to select "Do not display in a pop up if only one action link is available at runtime". You will find this option in Column Properties > Interaction. I have explained it in this video - kzitem.info/news/bejne/mKN404d6rnWndII
@testsm5277
3 жыл бұрын
One simple question, I want to resize the detailed report on the infolet. It is coming in the center of the page, i need it to fit to the screen so that there will not be a need to scroll to see more columns or records. Please answer if anyone knows
@testsm5277
3 жыл бұрын
And yes this because i have some filters which are not resulting in any data for admin user with which i am updating the analysis.
@testsm5277
3 жыл бұрын
@@atarunraj sure will try it and update you! By the way all your videos are very helpful and thanks for creating such content for us👍🏻
@evangelinaaceituno6220
3 жыл бұрын
Is it possible to insert a formula to the column so that it adds '0' where it does not bring values? something like NULL value?
@atarunraj
3 жыл бұрын
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.
@evangelinaaceituno6220
3 жыл бұрын
@@atarunraj Thank you so much! Your are very kind. I was trying but I cudn´t get it . IFNULL("Payables Payments - Payment History Real Time"."- Payment Information"."Check Date",'0') My problem is the check date have some null values (from invoices that weren´t paid) and if I want to create a callculus betweem Due date and Check date I need the '0' in rows that are empty. (I apologize my english is not good)
@atarunraj
3 жыл бұрын
@@evangelinaaceituno6220 Happy to help. The formula you wrote looks right. Let me work out an example and will message you. If you are on LinkedIn, connect with me here www.linkedin.com/in/sarunraj/ It will be easier to communicate.
@atarunraj
3 жыл бұрын
@@evangelinaaceituno6220 I have send you details on LinkedIn
@OzieeMate
3 жыл бұрын
How to return from detail view to summary view?
@OzieeMate
3 жыл бұрын
@@atarunraj But in standard drill down reports ...we the return link in the bottom. However your videos are really easy to understand & learn...keep posting new stuff!
Пікірлер: 44