General OBIEE

Get Involved. Join the Conversation.

Posts

  • nathan morgan (at Client)
    What is catalog folder Extension?5.0
    Topic posted November 20, 2019 by nathan morgan (at Client)Bronze Medal: 1,250+ 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:
  • Donald Ferreira
    Java.sql.SQLException: Invalid column indexAnswered12
    Topic posted November 15, 2019 by Donald FerreiraRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Data Models 
    Title:
    Java.sql.SQLException: Invalid column index
    Summary:
    Errors out with the mesaage
    Content:

    Hello There,

    We are using Oracle Financials Cloud and BI Publisher. I have a simple WITH Clause sql construct. On execution it gives the below error. .

    Could you please advise on what needs to be corrected?


    oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: Invalid column index
     

    Database Version:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    PL/SQL Release 12.1.0.2.0 - Production
    CORE 12.1.0.2.0 Production
    TNS for Linux: Version 12.1.0.2.0 - Production
    NLSRTL Version 12.1.0.2.0 - Production

    SQL Query:

    WITH  FUNCTION GetValue1 (p_value VARCHAR2) Return VARCHAR2 IS
                      CURSOR c1 IS
                           SELECT 'aa' aa FROM dual WHERE p_value = 'ABC';
          
                  cc VARCHAR2(100);
                BEGIN
                     FOR x IN c1
                     LOOP
                          cc := x.aa;
                     END LOOP;
                     RETURN cc;
                EXCEPTION
                      WHEN OTHERS
                      THEN
                          RETURN 'Error GetValue1: '|| p_value;
                END GetValue1;
    ------------
         PO AS
         (SELECT * FROM po_headers_all)
    ------------
    ,    POLines AS
         (SELECT * FROM po_lines_all)
    ------------
    --Main Query
    ------------
    SELECT po.segment1, polines.po_header_id , GetValue1('ABC') GetValue
    FROM   PO, POLines
    WHERE  polines.po_header_id = po.po_header_id

     

     

    Thank you.

    Look forward to hearing from you.

    Regards,

    Don

  • Sarah Munro
    How can I find all reports using the same BI Publisher Data...4
    Topic posted November 14, 2019 by Sarah MunroRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Data Models, Public Sector 
    Title:
    How can I find all reports using the same BI Publisher Data Model
    Summary:
    I need to be able to identify all the reports that are using a Data Model before I make changes to the DM.
    Content:

    Bi Publisher Data Model has been created, I now need to know all the reports that are using this DM. Is this possible?

    Version:
    Oracle BI EE 11.1.1.9.0
  • Maarten van der Burg
    What application do you use to write your SQL74.8
    Topic posted October 25, 2019 by Maarten van der BurgSilver Medal: 2,000+ Points, tagged BI Publisher Data Models, Data Models, Fusion, Reports, SQL 
    Title:
    What application do you use to write your SQL
    Content:

    I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax).

    I do feel that there could be more software assistance and there might be some more automated applications out there which allow searching the repository, automatic joins, etc. Having a tool like this would speed up my work tremendously.

    Would like to discuss in this topic what you use and what you like/dislike about it.

    Regards,
    Maarten

  • 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 
    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?

     

     

  • nathan morgan (at Client)
    Get privilege to issue logical SQL in OTBIAnswered21.0
    Topic posted September 11, 2019 by nathan morgan (at Client)Bronze Medal: 1,250+ 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:
  • Samrat Chattapadhyay
    Audit History to access changes made in BIP Data Model2
    Topic posted July 25, 2019 by Samrat Chattapadhyay, tagged BI Publisher, BI Publisher Data Models, Customizing Layout, Customizing Reports, Data Models, OBIEE Answers, OTBI, Reports 
    Title:
    Audit History to access changes made in BIP Data Model
    Summary:
    Require table or methods to find out changes done in BIP Data Model
    Content:

    Hi,

    We have encountered an issue recently where the data model query were updated by someone and the reports refering to the same data model started failing because of the changes.

    Is there any way we can have and audit on the BIP Templates or Data models to find out what was the changes done and who incorporated the changes.

    Any help in this is much appreciated.

    Regards,

    Samrat

  • Kunal Daya
    BI Publisher Excel Template13.0
    Topic posted March 27, 2019 by Kunal DayaRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Layout, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, Report Layouts, Reports, Sample Reports, Tip 
    Title:
    BI Publisher Excel Template
    Content:

    Hi All,

    We have a nested table and beacause of this we are receiving this row mark in front of the data

    Printing and Stationery" rowMark="2

    Does anyone know how to workaround this isse when nesting multiple groups in Excel?

    Thanks,

     

     

     

  • Stephanie Gott
    Published Report Schedule - showing message if attachment...
    Topic posted March 5, 2019 by Stephanie GottSilver Medal: 2,000+ Points, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Report Delivery, Report Output, Reports, Scheduling or Agents 
    Title:
    Published Report Schedule - showing message if attachment has nothing
    Summary:
    If the published report attachment has no data, can we put that in the body of the message?
    Content:

    Hello,

    For a personal BIP report schedule, if the attachment has no data on it, is there a way to call that out in the body of the email message to the user? We find that users are opening reports that have no data unnecessarily. Some days the report will have data, sometimes it might not and that could be valid. If there is a way to show the user that they don't need to open the attachment because it doesn't contain data, that would be great. Any thoughts? 

    Thanks,

    Stephanie

  • Senthilrajan Vaithianathan
    New features - BICCC 19A patch
    Topic posted February 13, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Reports, Scheduling or Agents, Upgrades 
    Title:
    New features - BICCC 19A patch
    Summary:
    Document for new features list in BICCC - 19A patch
    Content:

    New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be helpful if we get some document from Oracle explaining the new features within BICCC for every major releases in Advance, Now I am looking for 19A patch new features list for BICCC. let me know if any of you have come across such documentation for BICCC.