General OBIEE

Get Involved. Join the Conversation.

Posts

  • 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
  • Rob Stahly
    BI Scheduled Report Job and Daylight Savings Time15.0
    Topic posted November 6, 2019 by Rob StahlySilver Medal: 2,000+ Points, tagged OBIEE Answers, OTBI, Report Delivery 
    Title:
    BI Scheduled Report Job and Daylight Savings Time
    Summary:
    We had a scheduled that ran an hour early after daylight savings time ended
    Content:

    There is a scheduled report job that runs at 5:30am each wednesday.  With daylight savings time ending this past weekend, the job ran at 4:30am instead of 5:30am.  The schedule was set up to run at 5:30 Eastern Time, but it doesn't say EST/EDT.  I did update the start date to next week in an effort to get it to run back at 530am but wasn't sure if anyone had any advise to ensure that the system runs this at the same time no matter daylight savings time.

    This report is based off of an HCM extract in the system, and that process worked as expected with the daylight savings time change, only BI had the issue.

    Version:
    19C
    Image:
  • May Smith
    Data Model Parameters4
    Topic posted November 1, 2019 by May SmithRed Ribbon: 250+ Points 
    Title:
    Data Model Parameters
    Summary:
    Data Model Parameters
    Content:

    I am building a data model for an RTF letter using ‘Oracle BI EE’ as the Data Source. The data model requires
    parameters but when I try to add the SQL code, I get no results. Are there any
    examples of how to write the SQL for parameters when using
    Oracle BI EE as the data source?

    I have attached a simplified version of the report with the SQL that I have tried for the parameters. I do not get any error messages but no data is returned.

     

    Image:
    Code Snippet:
  • 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:
  • Farooq Haider Syed, PMP
    Unable to connect to BI Publisher4
    Topic posted October 29, 2019 by Farooq Haider Syed, PMPBlack Diamond: 60,000+ Points, tagged BI Publisher, BI Publisher Report Templates, OTBI 
    Title:
    Unable to connect to BI Publisher
    Summary:
    Unable to connect to BI Publisher
    Content:

    I am trying to connect BI Publisher but unable to connect, I have download the BI publisher and while opening the word file to connect it with Oracle it is not giving me the tab to connect with Oracle.

     

    Any idea or steps to connect with BI publisher.

  • 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

  • Gaston van de Weijer
    Reference Relationship in BI Publisher4
    Topic posted October 22, 2019 by Gaston van de Weijer, tagged BI Publisher, BI Publisher Report Templates, Report Output 
    Title:
    Reference Relationship in BI Publisher
    Content:

    Hi,

    I created an interview which loads data about a certain order - it then needs to go into boxes and I need to create shipping labels

    1. The user adds an instance 'the box' and enters dimensions and more information. 

    2. I created a relationship from 'the box' to 'the item' called 'the debrief item in the box'

    3. I added this relationship to the entity collect screen, so you can check which items will be in the box.

    4. The data overview displays exactly what I want:

    5. However, I cannot get this in BI publisher. I want an overview of items per box, however, I can't seem to pull this off. Once I create a 'for each' for every box, I can't add another 'for each' in there. I can't seem to add the items in this overview..

    How do I create a report with BI publisher with a page for a box and a list of items in the box below? 

    Version:
    19B
  • 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?

     

     

  • GIUSEPPE IACONO
    Oracle Business Intelligence 11g installation65.0
    Topic posted October 11, 2019 by GIUSEPPE IACONOBronze Trophy: 5,000+ Points, tagged BI Publisher 
    Title:
    Oracle Business Intelligence 11g installation
    Content:

    I Guys,

    I want to install Oracle Business Intelligence 11g, I Just download the 5 file.zip from https://www.oracle.com/middleware/technologies/bi-downloads.html

    I unziped the files in a folder and executed: C:\Users\Desktop\bishiphome\Disk1\install\win64\setup.exe.

    I arrived to the steps 8, but now I don't know where I can find the value of the field to continue.

    Can Someone helps me?

    Best Regards

    Giuseppe

    Image: