General OBIEE

Get Involved. Join the Conversation.

Posts

  • Donald Ferreira
    BI Publisher Excel - How to get multiple horizontal...
    Topic posted December 11, 2019 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:
  • Silvia Guido
    Suspended job report5.0
    Topic posted December 9, 2019 by Silvia GuidoBronze Medal: 1,250+ Points, tagged BI Publisher, Report Delivery 
    Title:
    Suspended job report
    Summary:
    Suspended job report
    Content:

    Hi,

    I have a question about using a BIP job report: I have a job report that is scheduled to be sent every night if the day before some users have been registered to a learning element, like a course. Now, I want to suspend this job only for one night, in order for it to not be executed tonight even if today some learners have been registered to a learning course. My question is: if I suspend it, and then reactivate it on Wednesday, it will start to work again on thursday night, referring only to the learners that have been registered on wednesday, is it right? Or there is the risk that the notification that is not sent tonight will be sent later, when the job is reactivated?

    Thank you

    Silvia

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

  • 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:
  • Richard Ribeiro
    Schedule new Report Job for BIP report, Notification tab...
    Topic posted March 11, 2019 by Richard RibeiroBronze Medal: 1,250+ Points, tagged BI Publisher, Report Delivery, Reports 
    Title:
    Schedule new Report Job for BIP report, Notification tab doesn't save values
    Summary:
    Schedule new Report Job for BIP report, Notification tab doesn't save values
    Content:

    Hello.

    Has anyone else noticed this behavior when scheduling a BIP report job?

    Schedule a report, fill in all the appropriate tabs (General, Output, Schedule, Notification).  Submit the new Report Job.  Go to Return / Home and into the Report Jobs screen and find the new job.  Click the Edit button.  All the configuration that was set up is visible.  However, on the Notifications tab, only the Email Address field remains populated.  The check box for "Notify By" is now unchecked, as are the "When" options below it.  These had previously been set when the Job was created.

    Is this only a UI issue or does it mean this part of the Job's configuration was never saved?  We have had users with different security levels do this and the results have been the same, so we are thinking that it is not security related....

     

  • 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

  • Linda Stelling
    'Publish for Subscription' in OTBI Agent4
    Topic posted February 27, 2019 by Linda StellingSilver Medal: 2,000+ Points, tagged OBI Answers, OBIEE Answers, OTBI, Report Delivery 
    Title:
    'Publish for Subscription' in OTBI Agent
    Content:

    Hi, can anyone point me to any information on how to best utilise this feature within OTBI agents. Ideally I am looking to establish a way to set an agent to notify recipients when an analysis has been run and data produced but not physically send it as an attachment (due to the inability to password protect the file).  I wondered if the Subscription functionality is the way to do this but I haven't really used it before so am a little unsure of what it's meant to do

    Apologies if this is documented somewhere obvious, I just can't seem to find anything. 

    Many thanks

    Linda

  • Helen Thomas
    Exporting RTF to Excel - merged cells4
    Topic posted February 13, 2019 by Helen ThomasGreen Ribbon: 100+ Points, tagged BI Publisher, Report Delivery, Reports 
    Title:
    Exporting RTF to Excel - merged cells
    Summary:
    Exporting RFT to Excel is producing merged cells
    Content:

    Hello

     

    I have a business requirement to remove 3 columns from a rtf template in BI.

    I have downloaded the template, saved a copy, amended ( deleted) the columns and created a new layout using the new version. This appears to be working successfully.

     

    When I try to export the report to excel, the report in now merging 4 rows into 1, which is not happening on the original template. Is there something else I need to do?

     

    I am aware that it might be better to re-work the template into an excel one, but I needed a quick turnaround on removing the columns, and thought deleting them might be the quickest option!

     

    Thanks in advance

    Helen

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