Tuesday, 29 September 2020

Oracle Fusion BIP Report Questions with Answers

 Q) Navigation to build the BIP Report in Oracle Fusion.

-> 

Navigation to Build the BIP Report in Oracle Fusion.

Data Model Navigation.

Tools -> Report and Analytics -> New -> Data Model

Data Template Navigation.

Tools -> Report and Analytics -> New -> Report.

Q) What is Data model?

->  Data Model is a object which contains set of instructions for BI Publisher to retrieve data and structure data for report. Data Model defines data source, data structure and parameter for the report.

Q) What are the Components of Data Model?

->  Components of Data Model.

1. Data Set

2. Event Triggers

3. Flexfields

4. List of value

5. Parameters

6. Bursting.

Q) What is Data Set?

-> Data Set contains logic to retrieve the data from the single data source. A data set can retrieve the data from variety of data sources like database, existing data file, web service call etc.

Data Set



Q) Can we use Triggers in BIP Report?

-> Yes, we can use Event Triggers in BIP report. The Data Model supports before data and after data triggers as well as schedule triggers.

Before Data and After Data triggers consists of a call to execute a set of functions defined in PL/SQL package stored in oracle database.

Schedule Trigger is executed for a scheduled reports.

Q) What is split by and deliver by?

-> Split by - Choose how you want to split the data. 

Deliver by - Choose to whom you want to deliver the data.

Q) How to generate multiple language report in BIP ?

-> We can use translation feature to generate the report in multiple language repot. Template can be translated from the properties page from the properties you can generate XLIFF files for the single template. Click extract translation to generate the XLIFF files.

Q) How to schedule the BIP reports?

-> 

1) In report and analytics -> New -> Report Job

2) In Create Section -> Published Reporting -> Report Job

3) In Catalog -> Select Report -> More-> Schedule

4)  You can schedule the report using ESS Job also.



For more Oracle Fusion HDL Videos  please click here

For more Oracle Fusion Extract PDF Output Videos  please click here

8 comments:

  1. Managing your career should be treated like handling a one-man business. Hannah Morgan, job search strategist, shares her insights and advice on navigating through the arena of job seeking through these uncertain times. https://www.peoplehum.com/blog/job-seeking-tips-and-tricks-a-talk-with-hannah-morgan

    ReplyDelete
  2. Hiring right goes further than the onboarding process. Here’s how you can focus on constant improvement and talent engagement, in this concise blog.https://www.peoplehum.com/blog/a-continuous-improvement-process-of-hiring-right

    ReplyDelete
  3. Xét nghiệm ADN huyết thống là phương pháp xác định chính xác mối quan hệ của Cha (Mẹ) với Con cái được sử dụng phổ biến trong y khoa.
    >>> Xét nghiệm ADN được thực hiện nhằm mục đích gì ?

    ReplyDelete
  4. Thank you for sharing wonderful information with us to get some idea about that content.
    Workday Online Training in India
    Workday Training in Ameerpet

    ReplyDelete
  5. I Like to add one more important thing here, The Data Fusion Market is expected to be around US$ 22 Billion by 2025 at a CAGR of 16% in the given forecast period.

    ReplyDelete
  6. Watch and Download world's famous drama series Kurulus Osman in English on link below
    👇
    Kurulus Osman in English

    📢Get high quality backlinks for your
    Website with BacklinksIndexer
    BacklinksIndexer

    Crypto trading online course
    Join on link below
    Crypto quantum leap

    📒 Read Home doctor book online
    Then you will be a doctor for your family
    Home Doctor Book

    Join online YouTube course
    And be a professional YouTuber
    Tube Mastery and Monetization by matt

    🦷Steel Bite Pro
    Best product for
    Teeth pain, cavities,teeth whitening and other oral health issues with money back guarantee
    Steel Bite Pro

    ReplyDelete
  7. Have tried to run report job using schedule trigger and it worked fine. But while submitting ESS job, it's not working as expected as it executing report even if there is no data from the query which used in schedule trigger

    ReplyDelete
  8. Please let me know if anything has to be done in ESS Job

    ReplyDelete

How to sort data in rtf template

  How to sort data in rtf template Sort the data in Data model is the recommended approach. But if you want to sort the data in rtf template...