Posts

Posts

  • Ling Xiang
    R11 ERP OTBI Subject Area Mapping to Fusion Database Tables144.9
    Topic posted June 6, 2016 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI in Reporting and Analytics for ERP public
    Title:
    R11 ERP OTBI Subject Area Mapping to Fusion Database Tables
    Summary:
    Release 11 ERP OTBI subject area database table mapping spreadsheet
    Content:

    This spreadsheet is published by Oracle OTBI Development.  This spreadsheet documents Fusion ERP OTBI subject areas, columns and the corresponding HCM database tables and columns.  Customers can use this spreadsheet to search for subject area reporting content or trace the corresponding database table and column for a subject area reporting field.

    The spreadsheet applies to Fusion ERP Release 11.

     

  • Wendy Ware
    SQL to Report on List of User Logins Per DayAnswered135.0
    Topic posted January 28, 2019 by Wendy WareBronze Crown: 15,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    SQL to Report on List of User Logins Per Day
    Summary:
    seeking a listing of unique user logins
    Content:

    Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion?  Thanks, Wendy

  • Dustin Grabowski
    Sample Report: Project Financial Management Cloud: Project...125.0
    Topic posted November 15, 2016 by Dustin GrabowskiGold Medal: 3,500+ Points, tagged Fusion Project reporting, OBIEE Answers, OTBI, Sample Reports in Project Management public
    Title:
    Sample Report: Project Financial Management Cloud: Project Budget vs. Actual
    Summary:
    This dashboard displays Budget details for a specific project.
    Content:

    The attached sample dashboard displays budget vs. actual cost and commitment details for a specific project.  Drill down pages show details of the actual costs and commitment transactions.

     

    To add this report to your environment:

    1. Save the catalog to a local folder

    2. Unarchive it to the OTBI web catalog under Shared Folders - Custom - Projects

    3. In the folder called ''Budget vs. Actual Reports', open the dashboard called 'Project Budget vs Actual'

     

    Fusion Applications: 11.1.1.11.0+

    Subject areas used: Projects - Cross Subject Area Analysis Real Time

                                  Project Costing - Actual Costs Real Time

                                  Project Costing - Commitments Real Time

    5 minutes to copy into your environment.

    Image:
  • Geetha Devi
    how to connect to Bi publisher administer console in fusion...Answered113.0
    Topic posted October 15, 2019 by Geetha DeviBlue Ribbon: 750+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Fusion, OBIEE Answers in General OBIEE public
    Title:
    how to connect to Bi publisher administer console in fusion 19C?
    Summary:
    How to access the bi publisher administer console in fusion 19c?
    Content:

    I  have added some roles to my fusion account. But, I cannot see the bi publisher administrator console offering in fusion 19c

    Could anyone please help with this?

     

     

  • Stephanie Gott
    Showing '0' for Null Value11
    Topic posted May 10, 2018 by Stephanie GottSilver Medal: 2,000+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI in General OBIEE public
    Title:
    Showing '0' for Null Value
    Summary:
    How do you show a 0 value in place of a blank value on an analysis?
    Content:

    Hello,

    We want to show the total number of something on an analysis (in this case Leads). If there were no Leads created on a day, we want to show '0' but instead our analysis is showing a blank value. I checked the box to "Include Null Values" and tried a case statement. It still shows blank value. See attached screen shots. Also, we need the actual value of 0 rather than just a cosmetic formatting issue. We need to be able to show the average number of Leads at the end of the analysis.

    Any thoughts?

    Thanks, Stephanie

    Document:
  • Kim Welker
    Return Candidate Name only for Specific CSW Selection...114.0
    Topic posted March 2, 2017 by Kim WelkerBlue Ribbon: 750+ Points, tagged Analyses, Customizing Reports, OBI Answers, OBIEE Answers, SQL in General OBIEE public
    Title:
    Return Candidate Name only for Specific CSW Selection steps/statuses
    Summary:
    How to modify my SQL statement to remove redundancies
    Content:

    Hi!  I've created a report to return all Open Requisitions as well as Filled Requisitions for the past year.  The report filters work well, however I have additionally created a field using the following SQL statement in an attempt to display Candidate Name only when they match specific Steps and Status conditions:

    CASE WHEN "Submission CSW Status - Current"."Current Step Name" IN ('Offer', 'Pre-Hire') AND "Submission CSW Status - Current"."Current Status Name" IN ('Accepted', 'Extended', 'Approval in Progress', 'Approved', 'Draft', 'Offer to be made', 'Candidate Record to be updated', 'Integration To WorkDay') THEN "Candidate Identification"."Name" ELSE ' ' END

    The names are populating as desired, however I am getting an additional row for Requisitions that not only have an Offer/Hired Candidate against them, but also have other Candidate submissions which simply aren't named based off the above SQL statement.  Basically the extra row is representing a placeholder for all the other Candidates that have applied but do not meet the conditions of the SQL statement. 

    Any ideas on how to suppress those extra blank rows?  If a Req does not have anyone in the Offer/Hire process, then I would still want the Req. to be displayed.  In that case the Candidate Name should be blank.

    Below is a sample of what's happening, however the attached doc is a littler easier to read.  Thanks in advance for any advice!

    Requisition Number_Position Number Name
    0044262_P0048293 John Smith
    0044262_P0048293  
    0044360_P-0019999 Jane Doe
    0044360_P-0019999  
    0044365_P0048452 Charlie Johnson
    0044366_P0048453 Sally Thomas
    0044367_P0048454 John Doe
    0044372_P0048457 Jeff Johnson
    0044372_P0048457  
  • Robin O'Connor
    Any way to bypass the row LimitationAnswered113.5
    Topic posted February 8, 2017 by Robin O'ConnorBronze Crown: 15,000+ Points, tagged Analyses, OBIEE Answers, OTBI, Report Output, Reports in General OBIEE public
    Title:
    Any way to bypass the row Limitation
    Summary:
    Bypass Row Limitation
    Content:

    Is there anyway to bypass the row limitation?  There are times I need to be able to analyze more than 25,000 rows of data.  This is causing a lot of work to divide reports up to be able to get to all of the information needed. 

  • Ujas Bhatt
    Due Date Calculation Formula based on Terms Date and Terms...105.0
    Topic posted May 7, 2019 by Ujas BhattSilver Trophy: 7,500+ Points, tagged OBI Answers, OBIEE Answers, OTBI, Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Due Date Calculation Formula based on Terms Date and Terms Name in OTBI Report
    Summary:
    Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI Repoert
    Content:

    Hi All,

    I have a requirement to derive Invoice Due Date based on Terms date and terms name.  I am using following subject area which has Terms Date and Terms Name

    OTBI Subject Area :-  [Payable Invoices - Transaction Real Time]

    I want to calculate Invoice Due date based on Terms Date and Terms name on the Payable invoices. Please suggest the formula or custom SQL to achieve this.

    Appreciate your help !!!

    Example:-

    Terms Date  =  05/07/2019 (MM/DD/YYYY)

    Terms Name = Net30  (Or can be Net15, Net60, Net90, Immediate etc,.)

    Result:-  Due Date = 06/06/2019

     

  • Aaron Leggett
    What is the Data Model that runs the 'General Ledger and...Answered105.0
    Topic posted October 18, 2018 by Aaron LeggettGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBIEE Answers in Reporting and Analytics for ERP public
    Title:
    What is the Data Model that runs the 'General Ledger and Subledger Account Analysis' Report?
    Content:

    Hi All,

    There is a report run via a scheduled process called 'General Ledger and Subledger Account Analysis'. The report is extremely useful and we would like to re-use the code to create an altered version of the report, however, we cannot seem to find the underlying data model. Does anyone know where it is/what it could be named?

    Thanks

    Aaron

  • MShrini
    How to show the grand total with group by option ?10
    Topic posted September 30, 2017 by MShriniBronze Crown: 15,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Project reporting, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    How to show the grand total with group by option ?
    Summary:
    How to show the grand total with group by option ?
    Content:

    Can you please help us how to show the grand totals with group by option. I am trying to bring the report as below but i am not able to see option to bring the below bold values.  Please provide any hints to achieve the below requirement.

     

    Period Period wise Value Totals by Group by
    Jan-17 100 100
    Feb-17 200 300
    Mar-17 300 600
    Apr-17 400 1000
    May-17 500 1500
    Jun-17 600 2100
    Grand Totals 2100 5600