how to display presentation value in bi publisher — Oracle Analytics

Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to display presentation value in bi publisher

Received Response
33
Views
6
Comments
deahayes
deahayes Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

Hello all,

How can I take the presentation value from dashboard, for example: user.id and use it in by Bi publisher report. I would like to locate user id and email report to that user. How do I call presentation value userid?

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    Check this https://blogs.oracle.com/xmlpublisher/entry/running_bip_reports_in_biee_wi

    also OBIEE 11g: GOURL for BI Publisher report - Passing multiple values on to a parameter

  • deahayes
    deahayes Rank 4 - Community Specialist

    Thanks for replying,

    The article titles are exactly what I want to do but the details are the opposite. It does not explain how I copy a variable from dashboard to BIP report. I just want to take a session variable (current user) and copy it to BIP report.

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    Try to keep BIP parameter same as session variable and see how that works

  • deahayes
    deahayes Rank 4 - Community Specialist

    How and where should I write it in BIP report?

  • deahayes
    deahayes Rank 4 - Community Specialist

    I used select :xdo_user_name from dual  to retrieve username, how can I use this to send report via email to xdo_user_name? Bursting?

  • deahayes
    deahayes Rank 4 - Community Specialist

    Srini,

    Wondering if you can help me. I have the session variable.

    Im getting real close to my desired output. I could use some help modifying my data model and bursting query.

    I can get data to display if hardcode the KEY but only with a PDF output, CSV is invalid format but why?

    Anyway here is a snippet of my data model

    SELECT ou.NAME, --KEY value used below

      cust.ACCOUNT_NUMBER Customer_Account_Number,

        trx.SALES_ORDER Sales_Order_Number,

      ar_tran.TRX_NUMBER Sales_Invoice_Number,

      ar_tran.TRX_DATE Invoiced_Date,

       gl_cod.SEGMENT1 Legal_Entity,

      gl_cod.SEGMENT2 Account_num,

      gl_cod.SEGMENT3 Department,

      gl_cod.SEGMENT4 Country_Code.....


    My bursting query is

    select

    'US_100000'  "KEY", --value from NAME

    'rpt305burst' TEMPLATE,

    'RTF' TEMPLATE_FORMAT,

    'en-US' LOCALE,

    'PDF' OUTPUT_FORMAT, --will not accept csv

    'EMAIL' DEL_CHANNEL,

    'Rpt-305' OUTPUT_NAME,

    ':p_user||'@yahoo.com' PARAMETER1,

    'xyz@yahoo.com' PARAMETER3,

    'subject' PARAMETER4,

    'Please find the attached extract of the requested file , Thank you ' PARAMETER5,

    'true' PARAMETER6,

    'donotreply@yahoo.com' PARAMETER7

    from DUAL

    Im new to creating bursting files, and I know NAME used above is incorrect. I want to send file based on user logged on (p_user) but its not located in data model so I just picked a column in data model. How should I rewrite this? I need to change "US_10000" to a variable or to p_user.