Most end-users use Excel as a very generic tool, because of their familiarity and the control in analysing data using the power of MS Excel.
Customers request converting lot of reports to excel.
As you can imagine, converting all reports to excel is a mammoth task using BI (XML) Publisher.
There is a trick to capture Oracle Reports output (text output) into a excel sheet.
This trick uses the power of XML and MS Excel to format the data. This is trick is a simple and effective work around.
Basic Steps :
1) Set the output format for the report to XML
2) Run the report to generate output.
3) Save the output file locally as a XML file.
4) Open the file using MS Excel.
5) To make it more beautiful, you may use a MS Excel Template.
The Excel Templates can be used to do complex data analysis and formatting. Displayed example below is a simple excel template, to make the point.
Example :
Requirements :
Report to convert to Excel : Active Users Report
Expected Output :
Steps :
1) Set the output to "XML".
(In this case, to keep the sanctity of the system, I have created a new concurrent request with a different output type)
New Report with Output as XML :
2) Run the Report and Display the output
3) Lets save the XML output file in local PC. ( File->Save As).
Make sure the file is saved as a <file name>.xml file.
4) If we open the file using MS Excel, you can see the output.
5) To make it more to look like the Requirement, I first created a MS Excel Template ( *.xlt file) .
6) Apply the template to the excel output. Data->XML-> Import.
The Excel Template can be used to do comprehensive data analysis and formatting. Displayed above is a simple excel format to make the point.
Author : SUDEEPT MAHARANA
Comments
Thanks for the article. I have got a doubt, I'm clear till point #4, where we open the .xml file using excel. After this using excel template..I'm a little confused. And also won't it be cumbersome if each and every report we need to do this manual procedure of opening with excel. I'm not aware of generating reports with excel output. Please guide me.
Thanks
Ash wini
SUDEEPT
The parameters of concurrent program "GLACTANP180XML " of application "General Ledger" use features which are only supported in Oracle Forms. This concurrent program may not be submitted from other environments such as OA Framework or PL/SQL APIs.
The number of warning messages: 2.
------------ --------------- --------------- --------------- -----
The parameter "Accounting Flexfield From" uses value set "GL_SRS_LEDGER_ FLEXFIELD" with validation type "Pair".
This type of value set is only supported in Oracle Forms.
-------- --------------- --------------- --------------- ---------
The parameter "Accounting Flexfield To" uses value set "GL_SRS_LEDGER_ FLEXFIELD" with validation type "Pair".
This type of value set is only supported in Oracle Forms.
---
An y idea how this can be resolved?
The article is good. Thanks for sharing. But this article is missing an important thing which everyone is struggling to get to - An Excel output based on Microsoft Excel via XMLP.
Any ideas on that?
Regards,
Jithendra
Try to use native Excel templates :)
Welcome to xlspe.com
Hope this helps
Have you solved the question?
i also have this problem ,would you share the solution?
thank s
This takes more time the larger the organization is, sometimes even weeks.
Yet sometimes the business needs the report "right away".
I came up with a way to generate Excel output by creating the query and pasting it int the concurrent request definition.
No messy files, registrations, etc. It opens right in Excel and it takes as long to build as it takes to come up with the query.
Watch it at:
http://www.more4apps.com/demos?DemoName=EO&ProductName=Excel-Out
for more details see
http://piotrbelter.blogspot.com/
I have a issue with bursting the Excel formatted output of BI publisher report. If the size is less than everything works fine. If the output file size is 33 MB, i am not able to view the output in the request form and also bursting is not working. Can you please let me know if there is any restriction in the size of excel output for bursting.
Than ks in Advance
I have an rdf file. I created a concurrent request with output as XML.
I save the the output file as XXX.xml and open with excel. I get the data but I dont get the column headers.
Thank s,
AK
When i ran the Excel format Report through Oracle Apps R12 Application images are not displaying but data is coming properly.Please can any body tell why this images or logos are not displaying... :(
clear idea concerning from this piece of writing.
site: http://www.easy-top.sfc-forma.net/community/profile/anjamatthews28/
that before. So good to find another person with some unique
thoughts onn this subject. Seriously.. thank you for
starting this up. This sife is something that is required on the web, someone with
a bit of originality!
webpage: https://grannyflatchat.com.au/community/profile/adelltuckett40/
homepage: https://moveproject.eu/community/profile/willardeller387/
I seriouslyy appreciate people like you! Takee care!!
Casino za prawdziwe pieniadze site: http://www.futbol7andujar.com/component/kide/historial/-/index.php?option=com_kide kasyno
za pieniadze
now. (from what I've read) Is that what you're using on yor blog?
Bonus w kasynie bez depozytu homepage: http://abel.14.free.fr/modules/profile/userinfo.php?uid=2442 gry
casino na pieniądze
with?I'm planning to start my own blog in the near future but I'm
having a difficult time making a decision between BlogEngine/Word press/B2evoluti on and Drupal.
The reason I ask is because your layou sesms different then most
blogs and I'm looking for something unique. P.S My apologies for getting off-topic buut I hadd to ask!
Sòng bạc tiền thật web site: https://vhub.swegonnorthamerica.com/community/profile/karmayzo2630430/ cờ bạc
web page, I truly appreciate your way of writing a blog. I saved as a
favorite it to my bookmark website list and ill be checking back soon. Please
check out my web site too and let me know how you feel.
homepage: https://wikicampedia.com/index.php?title=%C3%90%C2%A1%C3%91%E2%80%9A%C3%90%C2%B0%C3%91%E2%80%9A%C3%91%C5%92%C3%91_N62_%C3%90%C5%B8%C3%91%E2%82%AC%C3%90%C2%BE_%C3%90%C5%A1%C3%90%C2%B0%C3%90%C2%B7%C3%90%C2%B8%C3%90%C2%BD%C3%90%C2%BE_-_%C3%90%C3%A2%E2%82%AC%E2%84%A2%C3%90%C2%B8%C3%90%C2%BA%C3%90%C3%90%C2%BF%C3%90%C2%B5%C3%90%C2%B4%C3%90%C2%B8%C3%91
keep it up all the time.
webpage: https://smartpreneur.ng/community/recent/recent/profile/torstenstephens/
homepage: https://lawreform.us/forum/profile/delhaj59399699/
Roxy Palace casino prompt play requires no software download in any way.
Once you have a very good really feel for the slot, it’s time
to start to wager barely greater amounts, making sure to take advantage of any given slots multiple paylines.
Previous analysis has shown that an illusory perception of
patterns in random sequences fuels chance matching: People have the false
impression that they "know" during which trials they should wager
on which slot machine - which is after all impossible given the
random order.
back too your webpage? My bloog site is in the very same niche as yours and my users
would definitely benefit from some of the information you provide here.
Please let me know if this okay with you. Many thanks!
website: http://www.tsebhatu.com/community/profile/sheilad76738237/
A superb vary of real cash deposit and withdrawal choices is vital to UK players.
The standard of a few of these playing online games which are extremely in style throughout Uk.
You can even order UFC using your PlayStation 4 to watch the combat
or stream utilizing the UFC app in your Xbox One.
or not this post is written vvia him as no one else understand ssuch distinctive approximately
my problem. You're amazing! Thanks!
homepage: http://izmitescortbank.com/author/gustavo25q/
Roxy Palace will 100% match your first deposit, up to £150, and then provide you with a 25% return in your second bonus, as much
as £800. One of the very first things a
participant has to do even before enjoying video poker slots or any on line casino game for that matter is, calculating their
bankroll. If you want to take pleasure in the complete suite of video games
then consider downloading this system to your mobile devices and take pleasure in great graphics and efficiency.
write. The sector hopes for even more passionate writers like you who aree not
afraid to say how they believe. All the tine follow your heart.
Gra z kasyna website: http://www.sa-mp.ugu.pl/member.php?action=profile&uid=234162 legalne kasyno online
They're very convincing and can definitely work.
Still, the posts are too brief for beginners. Could you please lentthen them a little from subsequent time?
Thanks for the post.
Casino online bonus bez depozytu web page: http://clbx.eu/index.php?title=Uwaga_N_7_8_Plany_Obstawiania_Rozda%C5%84_W_Blackjacku online kasyna
in quality?
Gry hazardowe kasyno homepage: http://dammwild.net/wiki/index.php?title=Artyku%C5%82_N_4_5_:_Bitwa_P%C5%82ci:_Czy_M%C4%99%C5%BCczy%C5%BAni_S%C4%85_Lepsi_Od_Kobiet_W_Kasynie_Yeticasino kasyno online bonus
bez depozytu
Do you have any tips on how to get listed in Yahoo News?
I've been trying for a while but I never seem to get there!
Appreciate it
this site.
I needs to spend some time learning more or understanding more.
Thanks for great information I was looking for this info for my mission.
my know-how.
homepage: http://miamigaspe.ecrituresnumeriques.ca/index.php/Utilisateur:MilagrosI88
sure whether this post is written by him as
no one else knoww such dettailed aabout my problem.
You're amazing! Thanks!
การเดิมพันแมทช์ webpage: http://fearlessguardians.cba.pl/index.php?action=profile;u=175887 การพนันมวย
for a fantastic post and a all round entertaining blog
(I also love the theme/design), I don't have time to look over it all at the
minute but I have bookmarked it and also added in your RSS feeds,
so when I have time I will be back to read more,
Please do keep up the fantastic job.
and thought I might check things out. I like what I see so now i am following you.
Look forward to looking over your web page repeatedly.
writing is actually a fastidious piece of writing, keep it up.
save refuges: https://www.aid4ue.org/about/
this web page and be updated with the hottest information posted here.
save refuges: https://www.aid4ue.org/articles/
Is it very hard to set up your own blog? I'm not very techincal but I can figure things out
pretty fast. I'm thinking about creating my own but I'm not sure where to begin. Do you
have any ideas or suggestions? Thanks aid
ukraine: https://www.aid4ue.org/articles/
oof unique content I've either created myself or outsourced but itt seems a lot of it is popping
it up all over the web without my authorization. Do you know any
techniques to help reduce content from beingg ripped off?
I'd truly appreciate it.
Btting parimatch odds web site: http://rollshutterusa.com/?option=com_k2&view=itemlist&task=user&id=1443976 sports betting parimatch
Reading through this post reminds me of my old room mate!
He always kept chatting about this. I will forward this article to him.
Pretty sure he will have a good read. Thank you for sharing!
save refuges: https://www.aid4ue.org/articles/
comment to support you. aid ukraine: https://www.aid4ue.org/articles/
this sector do not notice this. You must continue your writing.
I'm sure, you've a huge readers' base already!
homepage: http://thatnerdshow.com/site/discussion/profile/halv7382153467/
Keep up the superb works guys I've you guys to our blogroll.
save refuges: https://www.aid4ue.org/about/
website: http://wiki.asexuality.org/User_talk:BradlyBushell85
the web site, that's what this web site is providing.
website: https://neuroboxing.cl/community/profile/emeryzie5881533/
who had been doing a little homework on this. And he actually bought me dinner because I stumbled upon it for him...
lol. So leet me reword this.... Thank YOU forr the meal!!
But yeah, thanks for spending some time to discuss this subject herte on your web page.
web site: https://classifieds.miisbotswana.com/apartment/zametka-n24-stavki-na-kibersport-luchshie-stavki-na-dengi-na-sajte.html
be renowned, due to its quality contents.
wordpress themes: https://celebhairjunkie.net/__media__/js/netsoltrademark.php?d=www.blogexpander.com
wp plugins: http://www.b4busty.com/cgi-bin/ext2/out.cgi?od=3&c=1&s=50&u=https://www.blogexpander.com/
RSS feed for comments to this post