how to display presentation value in bi publisher

Question

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?

deahayes · Answer

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.

deahayes · Answer

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 · Answer

How and where should I write it in BIP report?