General OBIEE

Get Involved. Join the Conversation.

Posts

  • David Rabalais
    BI Publisher, First Time Setup, Report ServerAnswered5
    Topic posted December 3, 2019 by David RabalaisBlue Ribbon: 750+ Points, tagged BI Publisher, Setup/Administration 
    Title:
    BI Publisher, First Time Setup, Report Server
    Summary:
    I cannot find a clear guide to where I get the report server URL.
    Content:

    The URL I tried it with is: https://podurl.fa.us2.oraclecloud.com:9704/xmlpserver/

    I've done several variations of this, but nothing seems to work. Is the above URL the correct format? Is the port correct?

     

    Thank you,

    David Rabalais

    Version:
    19D
    Image:
  • Sian Summers
    Custom BI Webcat Reporting Duty55.0
    Topic posted November 29, 2019 by Sian SummersRed Ribbon: 250+ Points, tagged Fusion, OTBI, Public Sector, Report Delivery, Reports, Setup, Setup/Administration, Tip 
    Title:
    Custom BI Webcat Reporting Duty
    Summary:
    Trying to hide seeded reporting folders and understand the updated options within 19D
    Content:

    We are keen to have the option to hide seeded folders from users. Changing permissions on seeded report folders comes up with the following error:

    "In-place customizations are not allowed on factory delivered content. Save your customizations in /shared/custom"

    ***

    We were really pleased therefore to see the following release notes for 19D:

    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19D/19D-common-wn.htm#F10098

    However, I am trying to understand how it works. Has anyone used these roles yet?

    The BI Consumer role still has traverse permissions to these seeded folders, therefore struggling to understand how assigning another role counters this. 

    Also - the Custom BI Webcat Reporting Duty, which is the Duty Role that it is advised we edit put into a role and assign, is unable to be copied. Is this what people would expect?

    If anyone can give any further detail on how this works, it would be much appreciate. Keen to lock down some of these seeded reporting folders.

    Kind regards,

    Sian.

     

     

    Version:
    19D
  • nathan morgan (at Client)
    What is catalog folder Extension?5.0
    Topic posted November 20, 2019 by nathan morgan (at Client)Silver Medal: 2,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, Setup, Setup/Administration 
    Title:
    What is catalog folder Extension?
    Summary:
    Does anyone know the purpose of the empty shared folder Extension in the catalog?
    Content:

    The folder is empty.

    A duty role exists for it, BI_EXT_REPORTING_DUTY, but unlike the other folders, the permissions on this folder have not been updated so that only people with that role see this folder.

    I had been doing the following configuration to assign folder reporting duty roles to role

    Custom BI Webcat Reporting Duty

    CONFIGURE NEW BI REPORTING DUTY ROLES TO HIDE THE FACTORY CATALOG FOLDERS

    Cloud Readiness Common Technologies and User Experience
    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19D/19D-common-wn.htm#F10098

    Nathan

    Version:
    19C (11.13.19.07.0)
    Image:
    Code Snippet:
  • Nivya Mathire
    Need to remove delete option of report from BI Abstract role
    Topic posted November 11, 2019 by Nivya MathireGold Trophy: 10,000+ Points, tagged Reports, Setup/Administration 
    Title:
    Need to remove delete option of report from BI Abstract role
    Content:

    Hi,

    We have created BI abstract roles for giving access to reports.
    how to remove delete option of report for those users in BI catalog?

    Regards,
    Nivya

    Version:
    19C
  • Nivya Mathire
    PDF output in IE2
    Topic posted October 8, 2019 by Nivya MathireGold Trophy: 10,000+ Points, tagged BI Publisher, Reports, Setup/Administration 
    Title:
    PDF output in IE
    Content:

    Hi,

    We have created a custom report and rtf output. And the format is defaulted to PDF.

    When we are generating the output, Mozilla and chrome is giving the exact size ie. 100% but IE is more than 300%. How to fix it?

    Regards,

    Nivya

    Version:
    19C
  • nathan morgan (at Client)
    Get privilege to issue logical SQL in OTBIAnswered21.0
    Topic posted September 11, 2019 by nathan morgan (at Client)Silver Medal: 2,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, Report Output, Reports, Setup, Setup/Administration 
    Title:
    Get privilege to issue logical SQL in OTBI
    Summary:
    As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log for diagnostics like physical sql
    Content:

    Hi,

    Does anyone know if in Oracle Cloud Application, we are oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0), does a role exist that has been granted privilege "Admin:General"/"Issue SQL Directly" by person with bi administration privileges who went to the Administration menu then the page "Manage Privileges" to assign that privilege to a role. Our development team who are writing extensions using oracle transaction business intelligence (OTBI) real time subject areas, to be productive, need the ability to issue logical sql, view results with the log level set > 0, then view the log file with rich diagnostics like timings and row counts and the actual physical sql. To achieve this on onpremise projects the administrator had granted the above role to developers. We assume that the bi administrator role is not allowed to be granted in cloud therefore we can not set this up ourselves. In Navigator/Tools/Security Console I have assigned the following roles "BI Consumer Role", "BI Platform Author Role", "BI Publisher Data Model" and even "BI Platform Repository Manager" and "Business Intelligence Content Administrator" but none of these give me the "Administration" menu in /analytis/ nor the ability just to go to "issue sql" saw.dll?issuerawsql or even "Manage Sessions" saw.dll?sessions. Thanks, Nathan  

    Version:
    oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0)
    Image:
    Code Snippet:
  • Stefan Orac
    Where to change file format to UTF-815.0
    Topic posted May 2, 2019 by Stefan OracBronze Medal: 1,250+ Points, tagged OTBI, Setup/Administration 
    Title:
    Where to change file format to UTF-8
    Summary:
    Exports from OTBi must be UTF-8 encoded
    Content:

    Hi everybody,

    I try to find a way to have extracts done by OTBI agents in the UTF-8 encoding format by default. Currently it is UCS-2 LE BOM. I thought that it might be a setting within OTBI administration, but there is none. Does anybody know how to do this? We need all extracted (CSV)Files in UTF-8 in order to extract data towrads our DWH.

     

    Every input on the issue is much appreciated.

     

    Thank you very much in advance.

    Regards,

    Stefan

  • 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:
  • DTCC Admin
    .
    Topic posted January 11, 2019 by DTCC Admin, tagged OBIEE Answers, Setup, Setup/Administration 
    Title:
    .
  • Kingsley
    OTBI: OTBI Agent with SFTP Destination35.0
    Topic posted December 27, 2018 by KingsleyRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Output, Reports, Scheduling or Agents, Setup/Administration, Tip 
    Title:
    OTBI: OTBI Agent with SFTP Destination
    Summary:
    How to Setup OTBI Agent to export report results to SFTP Server
    Content:

    Hello All,

    I have a request to export the result output of an OTBI report to an SFTP server on a daily basis. Unfortunately the delivery Agent for scheduling OTBI reports does not have the FTP as a Destination option. Has anyone some Ideas on how I can go about this? your contributions are highly appreciated.

     

    Regards

     

    Kingsley