Posts

Posts

  • Santhosh Kumar
    Data Sync licensingAnswered4
    Topic posted June 16, 2017 by Santhosh KumarBronze Medal: 1,250+ Points, tagged OBI Answers, OBIEE Answers, OTBI in General OBIEE public
    Title:
    Data Sync licensing
    Summary:
    Want to know if we need to license data sync separately.
    Content:

    Hi BI Experts,

    I am posting this on behalf of my colleague. We need the below details.

    Do we need to license Data Sync separately if we have subscribed for BICS ? Appreciate if anyone can provide licensing details surrounding BICS and Data Sync. 

     

    Thanks,

    Santhosh

  • Brenda Jacks
    How to do MAX Date Logic less than Prompted AsOfDate in...15.0
    Topic posted June 14, 2017 by Brenda JacksSilver Medal: 2,000+ Points, tagged Analyses, Compensation, Core HR, Customizing Reports, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, SQL in General OBIEE public
    Title:
    How to do MAX Date Logic less than Prompted AsOfDate in Analysis
    Summary:
    Trying to get the maximum Salary Change Date in OTBI Analysis
    Content:

    I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less than or equal to a prompted AsOfDate in an OTBI Analysis.  Here is the filter I am using:

     

    "Compensation - Salary History Details Real Time"."Salary Details"."Salary change date" =
    SELECT MAX("Compensation - Salary History Details Real Time"."Salary Details"."Salary change date")
     FROM "Compensation - Salary History Details Real Time"
    WHERE "Compensation - Salary History Details Real Time"."Salary Details"."Salary change date" <= '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}'

     

    I'm getting error getting drill information and wondering how I can fix this?  I have attached the catalog.

    Thank you!

    Brenda

  • Aaron Leggett
    How to extract Registration Number on OTBI?25.0
    Topic posted June 12, 2017 by Aaron LeggettGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    How to extract Registration Number on OTBI?
    Content:

    Hi

    I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'First-Party Tax Registration Number' and 'Supplier Tax Registration Number'. However, both options return no results. I have attached a screenshot of what we need to extract below. I know that the Registration number in the image is blank, but we are under the impression that it should just return a null value (rather which it just produces an error in the report). 

     

    Image:
  • Aaron Leggett
    Extracting Configuration Options via OBIEE1
    Topic posted June 8, 2017 by Aaron LeggettGold Trophy: 10,000+ Points, tagged Analyses, BI Publisher, Data Models, Fusion, OBIEE Answers, OTBI, Public Sector, Reports, Setup, Setup/Administration, SQL in General OBIEE public
    Title:
    Extracting Configuration Options via OBIEE
    Content:

    Hi All

    I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export the expenses into a report easily, but can't seem to grab the configuration options for each individual expense (not sure if it is even possible!). I've attached an image to show what I am trying to export (basically everything on the image, so Rate Definitions, Rate Determinants etc.) If it is possible, how would I go about doing this?

     

    Image:
  • Vikram Agarwal
    Role Customization to view Procurement and Finance Analysis25.0
    Topic posted May 31, 2017 by Vikram AgarwalBlue Ribbon: 750+ Points, tagged Fusion Financial reporting, Fusion Procurement reporting, OTBI in Reporting and Analytics for ERP public
    Title:
    Role Customization to view Procurement and Finance Analysis
    Summary:
    Role Customization to view Procurement and Finance Analysis
    Content:

    Hi All,

    We have a requirement where Procurement Team will be accessing (only view) customized financial report (analysis prepared through Finance Subject Area) and vice versa (finance team needs to view certain procurement data).

    We are thinking of preparing custom role which contain only view access for procurement and finance. Any leads on which all privilege/seeded role are required are welcome. Also, please let me know if any additional configuration steps needs to be performed.

    Thanks in Advance

    Vikram

  • John Sims
    OTBI Report: Issue Aging Analysis4.0
    Topic posted May 24, 2017 by John Sims, tagged Fusion Project reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Report: Issue Aging Analysis
    Summary:
    PMOs, Project managers and stakeholders want to view their issues and due dates in a summary compressed view initially and then have the ability to drill down to take action
    Content:

    This dashboard includes an issue aging summary analysis with a drill down to a more action-oriented analysis of Issue details and action.

    The Issue Aging Analysis is a summary analysis consisting of a stacked bar of issues counts broken out by Issue Type.  Clicking on any of the stacked bar sections for a given month will drill down to the Open Issues Detail report by Issue Type.   The bottom half of the Issue Aging Analysis summary analysis is a Pivot Chart.  The Pivot chart pivots on Issue Priority and Issue Type

    The drill downs reports include relevant details on the Issues and the corresponding open action items for those issues

    Benefits to using this Dashboard

    • Proactive focus on the highest priority and escalated issues, improving the chances of on time, on cost delivery.
    • Capture issue metrics to improve gating of projects
    • Managers / Governance Board / Stakeholders want to monitor the turnaround time on open issues and take corrective action with project teams

    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. Open the dashboard called “Issue Aging Dashboard”

     

    Fusion Applications: 11.12.1.0.0 +

    Subject areas used: Project Management – Project Issues Real Time

    5 minutes to copy into your environment.

     

    Image:
  • Sudhir K
    Filtering Issue on Data Model125.0
    Topic posted May 19, 2017 by Sudhir KRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Filtering Issue on Data Model
    Summary:
    The results of the data model are not being filtered
    Content:

    we are trying to create a simple data model with a variable. But the data is not being filtered as per the value chosen. attached screen shot has all the detailed steps.

  • Brenda Jacks
    OTBI Variable Presentation Date Prompt Format DD-MON-YYYY1
    Topic posted May 15, 2017 by Brenda JacksSilver Medal: 2,000+ Points, tagged Analyses, Core HR, Customizing Reports, Fusion, OBI Answers, OBIEE Answers, OTBI, SQL in General OBIEE public
    Title:
    OTBI Variable Presentation Date Prompt Format DD-MON-YYYY
    Summary:
    Users need to be able to enter a date in DD-MON-YYYY format at the prompt
    Content:

    Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the report runs is if the date is entered in DD-MM-YYYY format (15-05-2017) at the prompt.  Is there a way to change this so the user can enter dd-MON-yyyy?

     

     

    Image:
  • Peter Kirwan
    report on user account details - Role Names43.0
    Topic posted May 12, 2017 by Peter KirwanBlue Ribbon: 750+ Points, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, SQL in General OBIEE public
    Title:
    report on user account details - Role Names
    Summary:
    SQL for reporting on employees roles
    Content:

    Can someone see how to stop the multiple rows from returning in below SQL?

    select  "PER_USERS"."USERNAME" as "USERNAME",
      "PER_ROLES_DN_VL"."ROLE_NAME" as "ROLE_NAME",
      "PER_ALL_PEOPLE_F"."ATTRIBUTE3" as "ATTRIBUTE3",
      "PER_PERSON_NAMES_F"."FIRST_NAME" as "FIRST_NAME",
      "PER_PERSON_NAMES_F"."LAST_NAME" as "LAST_NAME",
      "PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE" as "EFFECTIVE_START_DATE",
      "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE" as "EFFECTIVE_END_DATE"
     from "FUSION"."PER_PERSON_NAMES_F" "PER_PERSON_NAMES_F",
     "FUSION"."PER_ALL_PEOPLE_F" "PER_ALL_PEOPLE_F",
     "FUSION"."PER_ROLES_DN_VL" "PER_ROLES_DN_VL",
     "FUSION"."PER_USER_ROLES" "PER_USER_ROLES",
     "FUSION"."PER_USERS" "PER_USERS"
     where   "PER_USERS"."USER_ID"="PER_USER_ROLES"."USER_ID"
     and  "PER_USER_ROLES"."ROLE_ID"="PER_ROLES_DN_VL"."ROLE_ID"
     and  "PER_USERS"."PERSON_ID"="PER_ALL_PEOPLE_F"."PERSON_ID"
     and  "PER_ALL_PEOPLE_F"."PERSON_ID"="PER_PERSON_NAMES_F"."PERSON_ID"
      and   "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE" >CURRENT_DATE
    order by "PER_USERS"."USERNAME" ASC

  • new.bi
    Pivot table in analysis - aging buckets1
    Topic posted May 4, 2017 by new.biRed Ribbon: 250+ Points, tagged Analyses, OTBI in General OBIEE public
    Title:
    Pivot table in analysis - aging buckets
    Summary:
    how to create a pivot table with columns as calculated field
    Content:

    i am trying to create date buckets of 0-30 days, 30-60 days in OTBI. I was able to add a calculated column. however when i create a pivot table with the calculated column i get a blank. Is that a bug in OTBI or is that how is it working as designed. I could not get the bucket on the column - the data just show as blank.