Жыл бұрын
Пікірлер
@robbyl12 Ай бұрын
Outstanding Job, Keep it up!! I have sent the request for the file for further study. Thank you
@datainkanalytics Ай бұрын
Thanks for your support. Access Shared.
@67giridhar Ай бұрын
Excellent Information sir, but I have one question, In AR View Image is there, If I click it will open, my question is How to open the view image through Excel Report, I have n number of Invoices in Excel, If I click on any Transaction, It has to open View Image. Do you have any Idea? Please
@cedrikb7124 2 ай бұрын
when I do that with jbips in the url, the connection fails. If I dont put jbips, I arrive on the classic analytics screen but within the login screen in excel and I'm stuck here.
@datainkanalytics 2 ай бұрын
Please ensure that your are copying url from analytics home page. I will recommend to watch video step, just to recheck no step had been missed out.
@kauanbohn 2 ай бұрын
Hello, can you gently share with me too?
@datainkanalytics 2 ай бұрын
Link for the file is available on the KZbin video description.
@howtolearnexcel 3 ай бұрын
This tutorial is criminally underrated. It deserves 1M views at least ;) Thank you, sir!
@datainkanalytics 2 ай бұрын
Glad to hear that you liked it... Hope it reaches to the audience to whom it will be helpful.
@jonathancook2750 4 ай бұрын
How could I use this process to subtract a current weeks sales by the previous weeks sales?
@jussymust 4 ай бұрын
This is what I was looking for. Easy to understand and follow. Thanks!
@rajbhoop9355 4 ай бұрын
Hi, I want that excel, how i can get that from you. please help
@datainkanalytics 4 ай бұрын
Link is available in the KZbin video description.
@believerinalmighty1641 5 ай бұрын
Can you share the file please
@datainkanalytics 5 ай бұрын
Access Shared.
@believerinalmighty1641 5 ай бұрын
Can u share the file please
@datainkanalytics 5 ай бұрын
Link for the file is available in the KZbin video description.
@ebfull901 5 ай бұрын
Hello! I would love to test your template. Can I have access?
@datainkanalytics 5 ай бұрын
Access Shared.
@UlrikHansen-e6k 5 ай бұрын
Thanks for a good and educational movie! I have, without luck, tried to connect my data table with a date table, trying to create a measure to see YTD figures and comparison with last year. I that possible in the way you create this P&L Statement?
@datainkanalytics 5 ай бұрын
Yes, it is possible to create measure of YTD and compare with last year in excel. Co-pilot and Chat GPT will be helpful to write Dax measure.
@deepaliwadate5885 6 ай бұрын
Hello, please provide the access
@datainkanalytics 6 ай бұрын
Access Shared
@ramachandrann121 7 ай бұрын
Excellent !!!!
@datainkanalytics 5 ай бұрын
Many thanks!!
@ramachandrann121 7 ай бұрын
excellent
@datainkanalytics 5 ай бұрын
Thanks. Glad you found it helpful.
@ramachandrann121 7 ай бұрын
excellent
@ramachandrann121 7 ай бұрын
excellent.
@ramachandrann121 7 ай бұрын
Excellent. Can you please share the Excel. Sent email for Access. thank you so much !!
@ramachandrann121 7 ай бұрын
Excellent. Can you please share the Excel. Sent email for Access. thank you so much !!
@ramachandrann121 7 ай бұрын
Excellent
@luciusyau1107 7 ай бұрын
Hi, I clicked on both links and it needs the access confirmation. Can you please help?
@datainkanalytics 7 ай бұрын
Access Shared. You can download the files
@luciusyau1107 7 ай бұрын
@@datainkanalytics thank you but I got error msg and fail: Initialising of the data source failed. Check your database server or contact database administrator. Make sure rhe external database is available and try again the operation. If you see this message. Create new data source to connect to the database. Still thanks for sharing :)
@espialidoucious 8 ай бұрын
This looks very helpful. I have requested access to the file in Google Drive. I kindly ask that you approve access.
@datainkanalytics 8 ай бұрын
Glad you found it helpful... Access approved for the file.
@bhaskarr4056 9 ай бұрын
Can we download account analysis report for different ledger at one shot
@bhaskarr4056 9 ай бұрын
Hi Can you Provide access
@neelimagoyal 9 ай бұрын
Please give me access for excel
@datainkanalytics 9 ай бұрын
Access Shared
@kathypotzkee8925 11 ай бұрын
Hello. I'm having this problem right now as we moved to Oracle Fusion. Do you have that file that you use in order to format the Asset Register Report? I am really spending too much of time formatting the report with thousands of sheets. Hope you can help me
@datainkanalytics 11 ай бұрын
Link to Excel file is shared on KZbin video description.
@kathypotzkee8925 11 ай бұрын
@@datainkanalytics thank you. Will this work even if we have some differences in the Asset Register?
@datainkanalytics 11 ай бұрын
Excel is designed to work on Standard Asset Register Report available in built from Oracle. It will not work on any Custom Report developed for your own specific need, even if it have similar structure of Standard Asset Register. I Hope this helps..
@jayeshkori7708 11 ай бұрын
Nice explanation
@believerinalmighty1641 Жыл бұрын
Really great effort... Please provide access to file
@believerinalmighty1641 Жыл бұрын
Very useful file... Can u pls give access to file?
@datainkanalytics Жыл бұрын
Access Shared
@sankalppatwa3332 Жыл бұрын
Superb stuff as usual 👌
@TheVirkk Жыл бұрын
Very helpful thanks for sharing
@datainkanalytics Жыл бұрын
Glad you found it useful...
@JaimP Жыл бұрын
It is very useful. Can you please grant the access?
@datainkanalytics Жыл бұрын
Access Granted.
@shirefahmed9034 Жыл бұрын
url not matched in excel (Error)
@datainkanalytics Жыл бұрын
If issue still persists, we can connect over email or skype on [email protected]
@sanjeevtanti7920 Жыл бұрын
Pls share the file and grant access
@datainkanalytics Жыл бұрын
Please click on the file link in KZbin description to request access, as I don't have your email address, will not be able to share without the same
@RaviSharma-tg1um Жыл бұрын
Thank you - please provide access
@datainkanalytics Жыл бұрын
Access Shared. Kindly share your experience..
@daschenji3895 Жыл бұрын
Amazing work. Thanks for sharing
@datainkanalytics Жыл бұрын
Glad you found it useful...
@ankitsrivastava1382 Жыл бұрын
Nicely put sir !! Do we have such similar reports for security and roles etc ?
@datainkanalytics Жыл бұрын
Unable to understand your question Ankit. In the current Video, we are drilling back to System for actual transaction using Deep link functionality, I am unaware, whether deeplink is available for Security and roles. If the same is available, then you should be able to create hyperlink using the same. Hope, I had answer your question, if not, feel free to connect. I will be happy to hear from you.
@shanmugarajasenathipathy772 Жыл бұрын
Very good.. requesting other such reports like Balance sheet, Statment of Retained Earnings and Cash Flows
@datainkanalytics Жыл бұрын
Thanks for your feedback. In process of finalizing a Format that will be helpful for most business. Awaiting for collective feedback on this Video. Based on the learning from Profit and loss, I will improvise for other Financial Statement. Kindly share your experience, were you able to develop the report as promised in the Video.
@graftedbranch7246 Жыл бұрын
Helpful, but you did not demonstrate what you can do with the extracted query. Is there a part 2?
@datainkanalytics Жыл бұрын
Thank you for your feedback! We're delighted to hear that you found the video helpful. The main purpose of this video was to show, that using SQL extraction gives you a strong starting point for your data work. It ensures that important things like security and connecting different pieces of data are ready to go. This sets the stage for doing more advanced data analysis and making better reports. Your interest is duly noted, and we'll make sure to cover those in upcoming videos.
@ketulpatel8646 Жыл бұрын
Great one Dagra Sir
@datainkanalytics Жыл бұрын
Thanks Ketul for taking time to share your feedback. Glad to know, that you found it useful
@PranavIyer5 Жыл бұрын
Hello, Thank You for uploading, was searching for exactly this
@datainkanalytics Жыл бұрын
Glad to hear that, Welcome Pranav
@autoholic_rider Жыл бұрын
Very informative..thank you sir
@mayurvaghani5107 Жыл бұрын
Your videos are very informative and will definitely helps many in Oracle engagements. Keep it up Sir!!
@datainkanalytics Жыл бұрын
Thanks Mayur for your encouraging feedback...
@dharmendersingh8832 Жыл бұрын
HARDCODE VALUE
@datainkanalytics Жыл бұрын
Enter hardcode text in value box
@dharmendersingh8832 Жыл бұрын
Hi, Nice to have helpful video , Let me give a situation. what if we want to fetch values for a column based on another column's value. please let me know
@shashankrrathi Жыл бұрын
Brilliantly presented. Thank you for this.
@mrcpavan Жыл бұрын
Can you please share the excel template?
@datainkanalytics Жыл бұрын
Access Shared
@balajir9334 Жыл бұрын
I am a functional consultant. Is there any document for me to do this excel macro as our clients are different and I can do the needful. Thanks in advance
@datainkanalytics Жыл бұрын
We regret to inform, that for excel macro, we are not maintaining any documentation that is available for sharing.
@OleCanada Жыл бұрын
This is excellent. Thanks for sharing! 🫡
@datainkanalytics Жыл бұрын
Thank you so much for sharing your view! I'm glad you enjoyed the video.
@hanymansour2217 Жыл бұрын
How to get the file path , Thanks
@datainkanalytics Жыл бұрын
I believe, you are asking for Report file downloaded from Fusion environment. It is path of folder in which you have downloaded the xml file. Hope this helps.
@masterarjun8050 2 жыл бұрын
Pls let me knkw how to resolve this
@datainkanalytics 2 жыл бұрын
Pls share your Skype id at [email protected], we will connect and resolve the same.
@masterarjun8050 2 жыл бұрын
@@datainkanalytics I have zoom id. I can't install Skype in office laptop
@masterarjun8050 2 жыл бұрын
Wil Tey to install the Skype in personal laptop and share the Skype ID in 1 hr.
@masterarjun8050 2 жыл бұрын
I sent email with Skype invite link
@masterarjun8050 2 жыл бұрын
I joined the meeting.