General OBIEE

Get Involved. Join the Conversation.

Posts

  • Donald Ferreira
    BI Publisher Excel - How to get multiple horizontal...
    Topic posted Yesterday by Donald FerreiraRed Ribbon: 250+ Points, tagged BI Publisher Data Models, BI Publisher Report Templates, Customizing Layout, Customizing Reports, OBI Answers, OBIEE Answers, Report Delivery, Report Layouts, Report Output, Reports 
    Title:
    BI Publisher Excel - How to get multiple horizontal repeating groups working?
    Content:

    Hello There,

    I would like to know how can I get the below output using BI Publisher for Excel.

    I have three groups in the xml file.

    G_1  ->  G_2 ->  G_3

    Below expected output:

    G_1 G_2 G_3
    Segment1 Creation_Date Line_Num Item_ID Quantity_Ordered Quantity_Delivered
    10001008 08 11 2019 10 300000013603844 200 100
        20 300000013612944 300 200
        30 300000013615636 10 5
        40 300000013626474 20 1
        50 300000013676169 2 2
    10001009 22 11 2019 10 300000014432708 11 11
        20 300000014437123 25 25
        30 300000014434715 6 6
               

     

    The output I am getting now is as below:

    G_1 G_2 G_3
    Segment1 Creation_Date Line_Num Item_ID Quantity_Ordered Quantity_Delivered
    10001008" rowMark="2 2019-11-08T04:35:17.000+00:00" rowMark="2 10" rowMark="3 300000013603844" rowMark="3 200 100
        20" rowMark="3 300000013612944" rowMark="3 300 200
        30" rowMark="3 300000013615636" rowMark="3 10 5
        40" rowMark="3 300000013626474" rowMark="3 20 1
        50" rowMark="3 300000013676169" rowMark="3 2 2
    10001009 22 11 2019 10" rowMark="3 300000014432708" rowMark="3 11 11
        20" rowMark="3 300000014437123" rowMark="3 25 25
        30" rowMark="3 300000014434715" rowMark="3 6 6
             

     

    Please find attached the sample xml, output and the excel template file for your reference.

    Look forward to hearing from you.

    Thank you & regards,

    Donald

    Document:
    Document:
    Document:
  • Neha Takkar
    Reports Run Count25.0
    Topic posted December 5, 2019 by Neha TakkarSilver Trophy: 7,500+ Points, tagged OBIEE Answers, OTBI, Reports 
    Title:
    Reports Run Count
    Content:

    Is there a way to find out how many times a report was run and who ran it? Like we may have 10 reports and want to find out which is the report that is used the most and how many people have used it. Thank you!

  • 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
  • Janko Jovicic
    ORA-03113: end-of-file on communication channel error -...15.0
    Topic posted November 28, 2019 by Janko JovicicBlue Ribbon: 750+ Points, tagged OBIEE Answers, OTBI, Report Output, Reports 
    Title:
    ORA-03113: end-of-file on communication channel error - Please Help
    Content:

    Hi All,


    In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are facing following error message and code:

    We had technical SR (3-20715306161) where we bounce the server at one point of time which still didnt fix the issue. Issue was gone after 3,4 days.

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

    State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

    State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

    State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 3113, message: ORA-03113: end-of-file on communication channel Process ID: 246507 Session ID: 6224 Serial number: 29851 at OCI call OCIStmtExecute: BEGIN fnd_session_mgmt.attach_session('9861821953AF9216E0534C8D630A8F6D'); END;. (HY000)

    State: HY000. Code: 17011. [nQSError: 17011] SQL statement execution failed. (HY000)

     

    Now we are having the same problem, it does impact less people  accross the globe (Germany, UK, Singapore) than the previous time, but at still reports are erroring quite randomley and also some users cannot run any. Clearing cache/ logging in out does not solve a problem.


    Users on the front end are just sseeing error - Please contact your system Adminsitrator where back in the logs we are seeing the error from above.

    Did anyone face similar issue in the past or at the moment and are there are any recommendation/ ideas how to solve it and what could be the rootcause?


    Regards,
    Janko

  • 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:
  • Ling Xiang
    OTBI Customer Survey5.0
    Topic posted November 18, 2019 by Ling XiangGold Trophy: 10,000+ Points, tagged OTBI, Reports 
    Title:
    OTBI Customer Survey
    Content:

    Oracle BI development is planning OTBI feature improvements.  To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting an OTBI customer survey.  Please take 10-minutes to complete this 10-question survey to share your feedback, thoughts and ideas ->   https://cloudcustomerconnect.oracle.com/pages/d549eddf75

     

    Thank you for your time!

     

    Ling Xiang

    Oracle OTBI Product Management

  • Prudence Kruchten
    Custom Sort - BIP Pivot15.0
    Topic posted November 15, 2019 by Prudence KruchtenSilver Crown: 22,500+ Points, tagged BI Publisher, Reports 
    Title:
    Custom Sort - BIP Pivot
    Content:

    Hi - I have a pivot table I am using through BIP and I need to apply a custom sort to it.  I added an Order By to the DM, but it's not applying that to the pivot, maybe because I don't have that field displayed in the pivot?  

    Any help on this would be appreciated, thank you!

    Image:
  • Shashi Kiran Vishwamurthy
    Can Oracle supports the subdomain email option (using...15.0
    Topic posted November 11, 2019 by Shashi Kiran Vishwamurthy, tagged BI Publisher, Report Delivery, Reports 
    Title:
    Can Oracle supports the subdomain email option (using custom mailfrom)?
    Summary:
    Can Oracle supports the subdomain email option (using custom mailfrom)?
    Content:

    Hi,

    we are getting undelivery notifications when we are using company domain email address in from email.
    Ex: abcd@company.com

    in Sr suggested that add oracle.com in company email domain server. we have conclusion from network team that we don't touch the SPF record of company domain email server as suggested in the SRs .

    So we are trying to use email address which is subdomain of company.
    Ex:Example email: infmhcm@hcm.company.com

    Our network team need confirmation about below points.

    • Whether Oracle supports the subdomain option (using custom mailfrom)
    • Are these mails purely inbound ?

    Please let us know if anyone knows about above two points.

    Regards
    Shashi Kiran
     

  • 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
  • Joy Hanneman
    Trailing Spaces in OBIEE2
    Topic posted October 30, 2019 by Joy HannemanGreen Ribbon: 100+ Points, tagged BI Publisher, OBIEE Answers, OTBI, Reports, SQL 
    Title:
    Trailing Spaces in OBIEE
    Summary:
    formatting question
    Content:
    Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish.

    I have a report where I need to create trailing spaces and have fixed character length columns. I have leveraged casting as VARCHAR, overriding the default value to plain text (don't break spaces) and using the prefix in the advanced tab of

    SET VARIABLE DISABLE_RIGHTTRIM_FOR_VARCHAR=1,

    DISABLE_RIGHTTRIM_ON_LENGTH_FOR_VARCHAR=1;

    I'm still not getting the results I am expecting. When I export it no matter the file type, its still trimmed and the trailing spaces are gone.

    Do you know what I am doing wrong?

    I really appreciate any advice! I haven't had much luck with the knowledge database and using on site resources to get this figured out.
     
    The specificity of this formatting is due to a file we are sending off to a vendor where they have fixed character length columns included in the requirements.

    Thanks!

    Joy Hanneman
    Code Snippet: