General OBIEE

Get Involved. Join the Conversation.

Posts

  • Ashish Harbhajanka
    How to Pass Parameter from Dashboard to BI Report214.0
    Topic posted April 26, 2017 by Ashish HarbhajankaGold Crown: 30,000+ Points, tagged BI Publisher, Discussion Forums, OBIEE Answers, Reports 
    Title:
    How to Pass Parameter from Dashboard to BI Report
    Summary:
    Passing Parameter from Dashboard to BI Report
    Content:

    Hi Experts,

    I have a BI Report which has a parameter. (A List of Value Item which gets value from a SQL Query)

    The standalone BI Report works fine.

    The BI Report is embedded in a Dashboard.

    Now I would like to know how can we ensure that the said BI Report works fine in the Dashboard too.

    Any worked out example (containing a very simple Report and with screen-shots ) would be wonderful

    Thanks in Advance!

    Kind Regards

    Ashish

  • Gaurav
    Download BI Report in pdf17
    Topic posted October 18, 2018 by GauravGold Medal: 3,500+ Points, tagged Report Delivery, Reports 
    Title:
    Download BI Report in pdf
    Summary:
    Download BI Report in pdf
    Content:

    How can we download BI Report in pdf format from download link. Presently it is coming only in html format even though setting in BI layout is set to pdf

    Image:
  • Tim Welsh
    Setting relative dates in a filter for an OTBI AnalysisAnswered173.7
    Topic posted April 28, 2017 by Tim WelshBlue Ribbon: 750+ Points, tagged Analyses, OBIEE Answers, OTBI, Reports, SQL 
    Title:
    Setting relative dates in a filter for an OTBI Analysis
    Summary:
    In an OTBI Analysis is there a way to add into a relative date range into a filter?
    Content:

    I need an Analysis with a filter to pick up dates within the last week.  I don't see a way to do this in the normal filter properties and I'm getting errors when i add the below code into "Convert this filter to SQL"  Is there a way to do this either with the regular filter or with the Advanced SQL filter?  

     BETWEEN (SYSDATE - 7) AND SYSDATE

  • Dudi Levi
    Working with Agents - OTBI - Help neededAnswered175.0
    Topic posted October 30, 2014 by Dudi LeviSilver Medal: 2,000+ Points 
    Title:
    Working with Agents - OTBI - Help needed
    Summary:
    I've setup an agent to deliver a report via E-mail... I tried everything but report is being delivered with no results\:
    Content:

    Hi,

    I've setup an agent to deliver a report via E-mail (as an attached excel file)... I tried everything but report is being delivered with no results\:

    BTW when I'm running the report from app it works just fine.

    Any suggestions?

    Regards,

    Dudi

  • Rashmi Rao
    Can we generate a OTBI analysis in a Pyramid format in R13...145.0
    Topic posted November 8, 2018 by Rashmi RaoBronze Trophy: 5,000+ Points, tagged OBI Answers, OBIEE Answers, OTBI 
    Title:
    Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version
    Summary:
    Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version
    Content:

    Hi,

    Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version? Please advise.

    The different levels in the pyramid would represent different grades (e.g. Analyst, Associate consultant, Consultant,... partner, etc.) And their width+number(width of the pyramid) would represented headcount at those grades.

     

    attaching the screenshot of the different ways to represent data. one of the images in the screenshot is of the pyramid shape of data layout that we are trying to achieve.

    Thanks,

    Rashmi

    Document:
  • Ruth Langlois
    Compare two fields in analysis143.0
    Topic posted April 4, 2018 by Ruth LangloisBronze Medal: 1,250+ Points 
    Title:
    Compare two fields in analysis
    Summary:
    How to compare two fields within an analysis
    Content:

    How do I compare two fields in an analysis.  I need "Workforce Management - Person Real Time"."Person Legislative Information"."Country" equal to "Legal Employer"."Legislation"

    Thank you

  • Donald Ferreira
    Java.sql.SQLException: Invalid column indexAnswered125.0
    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

  • Prudence Kruchten
    BIP OptionsAnswered124.8
    Topic posted May 15, 2018 by Prudence KruchtenSilver Crown: 22,500+ Points, tagged BI Publisher, BI Publisher Data Models 
    Title:
    BIP Options
    Content:

    Hi experts - I need some assistance with some options within BI Publisher reporting, hoping you can help!

    1) Is it possible to allow users to type into a parameter field their choices, rather than having to choose from a drop down menu?  It appears that with the menu option selected, users can select multiple options, but is it possible for them to paste into that field vs having to sort through the full menu list to find their options.  EX: Business Unit = Human Resources;Information Technology.  Can I just copy/paste those two choices in?

    EDIT: See chosen best answer

    2) Is it possible to set the default report output options?  Right now, I see that the default is always Interactive; HTML; RTF; PDF; Excel (*.xlsx); PowerPoint (*.pptx).  I would like to change those defaults but cannot find where to do that.  I know I can do it at the report level, but I have to change it every single time I create a report, and I'd like to change that.

    EDIT: Appears there is no global setting for this

    Thank you all!

    EDIT 17MAY2018: As I asked two questions, updated with answers for others to view

  • Gal Shani
    SQL code which define dates as default in the report promptAnswered125.0
    Topic posted November 27, 2014 by Gal ShaniSilver Medal: 2,000+ Points, tagged Customizing Reports, Reports, Setup 
    Summary:
    SQL code which define dates as default in the report prompt
    Content:

    Hello,

    I know there is SQL code which define dates as default in the report prompt..
    For example- define the prompt on the "Assignment Creation Date" to run as of today-and will take the current date automatically.
    Can someone share his knowledge regarding the code? this will be very useful.

    Thank you,

    Gal.

     

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