General OBIEE

Get Involved. Join the Conversation.

Posts

  • Rohan Lobo
    R13.19C Introducing OTBI Metadata Independent Mode Using BI...55.0
    Topic posted June 20, 2019 by Rohan LoboBlue Ribbon: 750+ Points, tagged Analyses, BI Cloud Connector, Discussion Forums, Fusion, OTBI, Reports, Upgrades 
    Title:
    R13.19C Introducing OTBI Metadata Independent Mode Using BI Cloud Connector (BICC)
    Summary:
    Opt in to use the OTBI Metadata Independent Extract Mode in BICC introduced in R13.19C.
    Content:

    What is the Change?

    Starting in Release 13.19C, BICC will no longer be dependent on the OTBI metadata repository, and the extract mode by default will use the OTBI metadata independent mode. Data Stores (or BIVOs) can be extracted independent of OTBI Metadata (RPD). The new BIVOs introduced in future releases of Oracle Applications Cloud will use OTBI metadata independent mode. The new mode eliminates the dependency on the existence of a BIVO in the OTBI metadata.

    How to Opt In to use the OTBI Metadata Independent Mode for Extraction?

    Refer to the attached document for detailed steps to opt in.

    Future Product Direction

    The OTBI metadata (RPD) dependent mode is going to be deprecated in Release 20C. Oracle Development strongly recommends that you switch your BICC extracts to use OTBI metadata independent mode by 20C. Refer to the attached document for more detailed information.  If you have further questions, contact Oracle Support.

  • Senthilrajan Vaithianathan
    Oracle Fusion OTBI Direct Database Query/Report95.0
    Topic posted February 4, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged Analyses, BI Publisher Data Models, Customizing Reports, Data Models, Discussion Forums, Fusion, OBI Answers, OTBI, Report Output, Reports, Setup/Administration, SQL 
    Title:
    Oracle Fusion OTBI Direct Database Query/Report
    Summary:
    Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releases
    Content:

    Creating Reports with Direct Database Query in Oracle Fusion OTBI is being deprecated for CLOUD environment from 19A releases.

    Refer Doc ID 2141412.1

    Regards

    Senthil

    Image:
    Code Snippet:
  • Rohan Lobo
    R13.x Deprecated Business Intelligence View Objects...13.0
    Topic posted September 20, 2018 by Rohan LoboBlue Ribbon: 750+ Points, tagged Analyses, Discussion Forums, Fusion, OTBI, Reports 
    Title:
    R13.x Deprecated Business Intelligence View Objects (BIVOs) that are Unavailable for Extraction Using BI Cloud Connector (BICC)
    Summary:
    This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle Applications Cloud.
    Content:

    This posting is applicable to customers using BI Cloud Connector (BICC) to extract data from Oracle Applications Cloud. The spreadsheets in this posting are published by Oracle BI Cloud Adapter Development. The spreadsheets document the Business Intelligence View Objects (BIVOs) and BIVO Columns that have been deprecated or inactive, which are unavailable for extraction using BI Cloud Connector (BICC) in Oracle Applications Cloud. Customers can use these spreadsheets to research deprecated or inactive VOs to exclude them from BICC extracts.

     

  • Kevin Lee Choon
    Deferred Termination field in OTBI25.0
    Topic posted September 17, 2018 by Kevin Lee ChoonGreen Ribbon: 100+ Points, tagged Analyses, Core HR, Customizing Reports, Data Models, Discussion Forums, Global HR, OBI Answers, OBIEE Answers, OTBI, Report Output, Reports 
    Title:
    Deferred Termination field in OTBI
    Summary:
    looking on how to determine a deferred termination
    Content:

    Hello,

    I have been asked to create a report showing the associates with a deferred termination. When they do a termination transaction, a selection box showing the processing options pop up on the interface with the choice of Immediate or Deferred.

    I tried to look but could not find the field in OTBI related to it. Anyone knows which field to use of if there is another way to determine this type of termination?

    thank you!

  • Juan Miguel Isip
    Use ESS to run a BI Publisher job that transmits reports via...75.0
    Topic posted September 5, 2018 by Juan Miguel IsipSilver Medal: 2,000+ Points, tagged BI Publisher, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, Report Delivery, Scheduling or Agents, Setup, Setup/Administration 
    Title:
    Use ESS to run a BI Publisher job that transmits reports via SFTP
    Summary:
    Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP?
    Content:

    We have built some Custom Reports in BI Publisher that extract data to a CSV file using a simple SQL script.
    This is scheduled running every hour and automatically transmits the file to a vendor's SFTP Server.

    However, I'm wondering if its possible to call these jobs from the Enterprise Scheduler (ESS) so that we can maintain it from there?
    Is this possible? I don't see any option for ESS jobs to transmit reports to a external SFTP server.

    Please advise.

    Version:
    Oracle Business Intelligence Publisher Enterprise
  • Raghuram Nanda Krishnamachary
    Reporting Options for data source in PaaS and SaaSAnswered1
    Topic posted May 9, 2018 by Raghuram Nanda KrishnamacharyGreen Ribbon: 100+ Points, tagged BI Publisher, Core HR, Discussion Forums, Fusion, Global HR, OBIEE Answers, OTBI, Payroll 
    Title:
    Reporting Options for data source in PaaS and SaaS
    Summary:
    Reporting Options for data source in PaaS and SaaS
    Content:

    I understand we have OTBI and BI tools available to report out of SaaS Data Source. Similarly,

    1. What are the options to report data out of DBCS – PaaS?
    2. What are the options to report data out of two data sources combined - DBCS and SaaS? I understand we can move data from SaaS to DBCS and then report out of DBCS. But what about without data movement?
    3. What are the options to report data out of three data sources combined – DBCS, SaaS and On Premise Data Store?

    Kindly share your thoughts.

    Thanks,

    Raghu

  • Doron de Jong
    How to create a custom read online role to allow users to...
    Topic posted April 5, 2018 by Doron de JongRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Discussion Forums, Fusion, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Scheduling or Agents, Setup, Setup/Administration, SQL 
    Title:
    How to create a custom read online role to allow users to self serve reports that are segregated
    Content:

    Hi All

     

    I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segregated to themselves/their own cost centre.

     

    The reports I am looking to do is a procurement requester report I have build, and I want users to be able to see all POs that they have raised and are requester for. What custom role/seeded role is their so they can have a view of this report (I also want to pin this report onto there oracle homepage - is this possible?)

    Another role I want to create is so that cost centre managers can see all POs raised to their cost centre only. How can I do this?

    Finally I want to create a role for expenses where a manager can see a report of all expenses that their team (Line manager hierarchy) have raised. Is this easy to do?

     

    Thnx

  • Doron de Jong
    How to do an average days to approve formula?
    Topic posted February 19, 2018 by Doron de JongRed Ribbon: 250+ Points, tagged Analyses, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, SQL 
    Title:
    How to do an average days to approve formula?
    Content:

    Hi all,

     

    I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it was approved in so I can create a trend analysis, I am struggling to create the average formula. I need to use this formula for many other OTBI dashboards (date of submitting expenses to approval for example). Any ideas please?

     

    My Excel dashboard that I use macros from OTBI for which I am trying to replicate is below, as are my subject areas.

     

    Thanks

    Document:
    Doc2.docx (644KB)
  • Graeme Thomson
    Contract Changes in HCM Cloud
    Topic posted February 9, 2018 by Graeme Thomson, tagged Core HR, Discussion Forums, Setup 
    Title:
    Contract Changes in HCM Cloud
    Summary:
    How to handle changes to contract using HCM Cloud
    Content:

    Hi, We are using HCM Cloud and one of our areas we are falling down on is changes to peoples contracts I.e. changes to hours, location/job changes etc.

    At present we do not have a facility setup for these changes to be sent automatically by letter to the employee. One option I have explored is creating a report to show those who have had changes in the past week and using a mail merge to send letters out. However this still requires manual intervention to run each week.

    I was wondering if there is a facility on HCM Cloud to send out a new contract whenever new changes are made.

    Thanks

    Graeme

  • Islam Abu Khamseh
    mapping between EBS tables and oracle fusion cloud tables
    Topic posted January 24, 2018 by Islam Abu Khamseh, tagged BI Publisher, Discussion Forums, Fusion, Reports 
    Title:
    mapping between EBS tables and oracle fusion cloud tables
    Summary:
    mapping between EBS tables and oracle fusion cloud tables
    Content:

    Hi Team , 

     

    as the schema changed from EBS to oracle fusion cloud so Is there any document that map between EBS tables and oracle fusion cloud tables ?