Posts

Posts

  • Aaron Leggett
    Two Pivot Tables with Different Values
    Topic posted June 19, 2017 by Aaron LeggettGold Trophy: 10,000+ Points, tagged Analyses, Customizing Layout, Customizing Reports, OBI Answers, OBIEE Answers, OTBI, Public Sector, Report Layouts, Reports in General OBIEE public
    Title:
    Two Pivot Tables with Different Values
    Content:

    Hi 

    I am trying to contain a report that has two pivot tables in it but with different parameters to restrict the results. I am pulling in the Expenditure Type column and want to restrict it by Expenditure Category. I want one table to show Expenditure Types by the 'Labour' value from Expenditure Category and the other table to show Expenditure Types without the 'Labour' value. Now, I can do this but only for one table, if I create another table it automatically restricts it to 'Labour' and if I change it then it changes table 1 to whatever I have changed table 2 too. Is there anyway I can manipulate the selection steps or filter the column so this conflict doesn't occur ?

  • Sujith R
    BI Cloud Extract Issue
    Topic posted April 23, 2017 by Sujith RGreen Ribbon: 100+ Points, tagged Analyses, BI Publisher, Fusion, OBIEE Answers, OTBI, Scheduling or Agents, Setup/Administration in General OBIEE public
    Title:
    BI Cloud Extract Issue
    Summary:
    BI Cloud Extract Issue
    Content:


    Extract ran successfully in BI Cloud Connector Console but unable to view them in Universal Content management.

    As per MOS doc - Fusion Applications BI Cloud Connector Scheduled Extract Ran Successfully But No Files Are Visible In UCM (Doc ID 2231972.1) . Added roles as per given MOS doc.

    For Fusion Application Cloud Extract,the following roles have been added
     
    -ESSAdmin 
    -ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT.

    For downloading the extracted content from UCM, the following roles have been added

    -OBIA_EXTRACTTRANSFORMLOAD_RWD

  • Ellen Manthei
    Issue with Percentage in Pivot Table
    Topic posted February 23, 2017 by Ellen MantheiSilver Trophy: 7,500+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI, Report Layouts, Report Output, Reports, Taleo Enterprise in General OBIEE public
    Title:
    Issue with Percentage in Pivot Table
    Summary:
    Issue with Summarizing Percentages in Pivot Tables
    Content:

    I have a calculation for the fill rate based upon hired vs target.  This is working fine in the details, but when I summarize it in a pivot table the numbers are flat out wrong.  Ideas on how to fix?

    formula:  ((("Candidate Counts"."# Submissions Currently Hired")*1.0)/((CAST("Requisition Flex Fields"."UDF25" AS INTEGER))*1.0))*100

    This formula works correctly in the details table, but the pivot table isn't calculating correctly.

    Images attached

     

    Document:
  • Rohan Lobo
    Project Portfolio Management Cloud OTBI Release 11: Subject...5.0
    Topic posted December 9, 2016 by Rohan LoboBlue Ribbon: 750+ Points, tagged Fusion Project reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Project Portfolio Management Cloud OTBI Release 11: Subject Area Description Document
    Summary:
    This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.
    Content:

    Use this document to obtain a functional understanding of subject areas (SA) in Project Portfolio Management Cloud OTBI - What the SA contains, key business questions that can be answered with the analysis built using that SA, whether the SA supports historical reporting,primary Fusion navigation page for the primary transaction facts in an SA, the Transaction Date the SA is linked to (what does Month, Year, Quarter in the SA mean) and finally any special considerations to be mindful of, while using the SA.

    Feedback on the utility of this document including suggestions if any for improvement is most welcome.

  • Dustin Grabowski
    Sample Report: Project Financial Management Cloud: Cost...5.0
    Topic posted November 4, 2016 by Dustin GrabowskiGold Medal: 3,500+ Points, tagged Fusion Project reporting, OBIEE Answers, OTBI, Reports, Sample Reports in Project Management public
    Title:
    Sample Report: Project Financial Management Cloud: Cost Transaction Import Summary
    Content:

    This dashboard displays a summary of the cost transactions that have been successfully imported after a specific date.  The default is the last 7 days, and this can be changed in the dashboard prompts.  Additional filters can be supplied as needed to further refine the results by Business Unit, Transaction Source or Expenditure Batch.  The view selector allows for various charts and graphs to be displayed

     

    A detailed listing of the transactions is also provided.  The prompts and sections of the detail table can be changed in the base analysis.

    This data is applicable to Project Accountants that have been granted access to at least one Business Unit's project cost data.

    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 'Cost Transaction Import Summary', open the dashboard called 'Cost Transaction Import Summary'

     

    Fusion Applications: 11.1.1.11.0+

    Subject areas used: Project Costing - Actual Costs Real Time

    5 minutes to copy into your environment.

    Image:
  • Dustin Grabowski
    Sample Report: Grants Management Cloud: Federal Awards...5.0
    Topic posted October 26, 2016 by Dustin GrabowskiGold Medal: 3,500+ Points, tagged Fusion Project reporting, OBIEE Answers, OTBI, Reports, Sample Reports in Project Management public
    Title:
    Sample Report: Grants Management Cloud: Federal Awards without CFDA Number
    Summary:
    This analysis displays Federal Awards that do not have a CFDA Number assigned.
    Content:

    The attached sample analysis displays a summary and list of Federal Awards that do not have a CFDA Number assigned.  There are two analysis' included, the first (Federal Awards with CFDA) returns all Federal Awards with a CFDA Number assigned, and the main analysis (Federal Awards without CFDA) returns all Federal Awards that are not returned by the prior analysis, limiting the results to only those where a CFDA Number is not assigned.

    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 ''Federal Awards without CFDA', open the analysis called 'Federal Awards without CFDA'

     

    Fusion Applications: 11.1.1.11.0+

    Subject areas used: Projects - Grants Management - Award Funding Real Time

    5 minutes to copy into your environment.

    Image:
  • Andrews Stanley
    Text Analytics
    Topic posted October 25, 2016 by Andrews StanleySilver Trophy: 7,500+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, OBI Answers, OBIEE Answers, OTBI, Reports in General OBIEE public
    Title:
    Text Analytics
    Summary:
    step by step procedure to proceed Text Analytics in OBIEE 11g
    Content:

    Hi,

    I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to receive a document based on Text Analytics.

  • Prudence Kruchten
    Administration & Recruiting Reporting
    Topic posted September 28, 2016 by Prudence KruchtenSilver Crown: 22,500+ Points, tagged OBIEE Answers in General OBIEE public
    Title:
    Administration & Recruiting Reporting
    Summary:
    I need to union report on these two environments
    Content:

    I have gone through the other postings and from what I can see, I believe this is not possible, but wanted to confirm.  I am trying to report on the job positions data out of the administration universe and to combine the specific data out of that report with the open requisitions in the recruiting universe.  It appears that our version (non-Fusion) of Taleo/OBI does not allow this, unless I use Embedded Reporting - which at this time we have not explored.  So, can anyone confirm that this is/isn't possible to do in OBI and I do need to use Embedded Reporting?  Also, has anyone done something like this and would be willing to assist me?

    Thank you!

  • Terri Allen
    Pivot Table Prompts
    Topic posted September 7, 2016 by Terri Allen, tagged Customizing Layout, OBIEE Answers, Report Layouts, Report Output in General OBIEE public
    Title:
    Pivot Table Prompts
    Summary:
    Multi-tab dashboard based off pivot table prompts
    Content:

    I have a report that displays the market data based on a pivot table prompt. Problem being when there are no results for the market wanting to display a 'no results' type of message. Instead currently it will default to the list of 'available' markets and it defaults to the first view listed. 

    Not sure if there is a way to achieve this any suggestions are welcome!

    Thank you in advance. 

  • Shawn McDonald
    Release 11 view issues
    Topic posted July 27, 2016 by Shawn McDonaldSilver Trophy: 7,500+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI in General OBIEE public
    Title:
    Release 11 view issues
    Summary:
    Two views are not the same in Release 11 as they were in Release 10
    Content:

    We recently were upgraded to R11 and I found two BI Answer views that are not the same as in R10 and causing issues.

    The Performance Tiles; one of the layouts had a line in the middle - in R11 is just a dot on the left side.

    Pie Graph - setting the data labels to 'Always' show data values now overlaps the values when pie sections are closer together

    Is anyone else seeing these issues? Any thoughts on how to reverse them?

    Thank you,

    Shawn

    Document: