Wednesday, April 15, 2015

BI Publisher Report with Excel Template

Step1:Concurrent Program
Create a Concurrent Program with Exceutable File Name as XDODTEXE

Step:2 Data Xml Template
Create a Data Xml Template for the Query

Step:3 Data Definitions
Create a Data Definition under XML Publisher Administrator responsibility with the above XML Template.

Step:4 Excel Template

Define the Tag for Fields in the Excel Template in the following Format:

Data elements: XDO_?element_name?
where XDO_ is the required prefix and
?element_name? is either:
the XML tag name from your data delimited by "?"
a unique name that you will use to map a derived value to the cell

?group_name? is the XML tag name for the parent element in your XML data delimited by "?".
a unique name that you will use to define a derived grouping logic.

Eg:
Tag for AR Invocie Posting Date : XDO_?AR_POSTING_DATE?
Tag for Group : XDO_GROUP_?G_HEADER?

The element name in XML data should match with the field name in the tag.
For group, select the entire record and provide the tag.

Step:5 Templates

Create a Templates under XML Publisher Administrator Responsibility with the type as ‘Microsoft Excel’
Step: 6 Excel Output:

5 comments:

  1. With a commitment to excellence, a focus on practical learning, and a supportive learning environment, WebTrainings remains the go-to destination for the "Best Digital Marketing Course in Hyderabad."

    https://www.webtrainings.in/digital-marketing-course-hyderabad/

    ReplyDelete
  2. Triotech Software Trainings offers comprehensive online training for Oracle Fusion HCM,signed to equip professionals with in-depth knowledge and skills in this powerful human capital management solution. Our expert trainers provide hands-on experience, covering key modules such as Core HR, Payroll, Talent Management, and more. Participants will gain proficiency in configuring, implementing, and managing Oracle Fusion HCM applications, enabling them to streamline HR processes and drive organizational success.


    https://triotechsoftwaretrainings.com/oracle-fusion-hcm-online-training/

    ReplyDelete
  3. Dr. Anubha's Homeopathy Clinic in Hyderabad is a well-known online resource for Classical homeopathy consultation and treatment. You can now access Dr. Anubha's web Homeopathic Clinic from the comfort of your own home, thanks to the convenience of current web technology. Under one roof, this Homeo Care Clinic provides complete solutions to all of your health difficulties. It is well-known as the top homeopathy clinic in Hyderabad, offering effective treatments for a variety of diseases.

    https://www.dranubha.com/

    ReplyDelete