Oracle Fusion #43: BIP Reports using Excel Template
ฝัง
- เผยแพร่เมื่อ 7 ต.ค. 2024
- -- Oracle Fusion Video Series : Video 43
#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant
Join Our Telegram Group:
t.me/techtalks...
FOLLOW US :
============
TH-cam : / techtalkwithnaresh
For More details Contact Us:
Email: nareshtech21@gmail.com
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Link for BI Report using Excel Template in Oracle Fusion video: • Oracle Fusion #44: BIP...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Link to download the Excel Template: docs.google.co...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
In this Playlist I had uploaded all the videos which help you to learn the Oracle Fusion BI Reports and Oracle Fusion OTBI Reports which will help you to improve your skills. If you have any doubt's regarding any of the uploaded videos you can write in comment section. If you need more videos on other topics in Oracle fusion you can reach out me at nareshtech21@gmail.com. Please do like, share and Subscribe the channel to get latest videos.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Hi Naresh first thank you for the tutorials! My excel template is not keeping the layout of the template when I run it as a .csv. What could be the issue? I am new at this. Thanks :)
@User Please send the template on nareshtech21@gmail.com to review.
Nice explanation.its a master detail report using excel template.drill down concept little different 😊💐
@Pandit Really you think so. Can you share then the difference and and sample foles on nareshtech21@gmail.com to eleborat more.
Dude you have changed meaning of drill down, Im eagerly waiting for the drill down feature
@Siva I will upload the video on dill down too.
Nice explanation .i want to show the report in .xlsx fromate .can you suggest on this
thank you
@Srinivas Currently in which format you are getting report? And what additional functionality you are looking for.
Lets say you have parameter on this report as PO number.. but PO does exist in the system.. how the report template will react... for now just ignore lov on parameter.. please suggest ?
@User If PO number is parameter and theire is no PO number the report will not run.
@@TechTalkwithNaresh so will the output be black with no headers ? Just blank page/excel ? And what if I want to print the headers in such case.. how that can be done ?
@User It is completely depend on paramater, if your report query is fetching the details with out PO number then it is return or print that data else it will not print.
Thanks for the video. Naresh is there any way to implement running totals in excel template. We are able to achieve the same in RTF template but requirement is to implement the same in excel template.
@Venkatareddy you can use same sum tak which is used in rtf for calculating the total.
@@TechTalkwithNaresh In RTF i am using the variable to store the running total but can we do that in the excel template. I tried it but not working out. Kindly let me know your thoughts
@venkatareddy Share both template on nareshtech21@gmail.com
thank you very much
@Eliel Welcome. Subscribe to get latest updates.
Hi Naresh, please upload videos for fusion form customization
@Venkatesh I will try to upload the video asap
This report is Master detail report, I don’t think we have drill down option.OTBI has drill down options
@Diva Yes OTBI have drill down options.
i have a similar kind of requirement need to print g1,g2,g3,g4 in one row and in 2nd row g1,g2,g3,g4 pls. suggest me
Hi Surya, I won't understand the requirement. In both lines you are saying G1 to G4, whats the difference. Write on nareshtech21@gmail.com with more details so I can help you.
SIR HOW TO GET G1 IN A PARTICULAR SHEET AND G2 IN A PARTICULAR SHEET AUTOMATICALLY
@Dagger we have to create multisheet template for that.
How to copy an existing Data Model and start from there?
@Kaushanmbi You can download the entire data model and upload back to another or same instances to modify. Refer my playlist of fusion I had already uploaded a video on same.
Rig click on the data model,copy and then paste where ever you want
First view, first like, first comment 👍
@Siva Thanks for Acknowledgment.....