BI Publisher administration access to a specificy model

Dir_Pal

Summary

BI Publisher administration access to a specificy model

Content

HI

I was creating a data model and passed on the sql query and created parameters along with it, But due to some reason I am not able to see the output value as well when I run this query in toad I need to pass the administrator exec statement to see all the value so how do I insert administrator access to that value in BI publisher.

Dir_Pal

running on a toad to view the values requires session.set_identifier(value) to view as it has only few people access. the only thing here is I cant see the data in a record and rest of the tables data is visible.

how to set up identifier for BI as for toad is defined above .

timdexter

Im not sure what you mean by 'identifier value'?

The first is a plsql based functin that you can write to set whatever environment variables, pre work, etc for the data model that is going to run. You can pass the function runtime variables and parameter values.

The second, is a function that will be called prior to the complete report being executed to set environment variables.

I hope one or the other will work for you.

Regards

Tim

Dir_Pal

can we use the  for set identifier value ???

timdexter

Check out two options

1. Pre fetch data trigger - https://docs.oracle.com/middleware/12213/bip/BIPDM/GUID-757ABC83-8CBC-4660-84CE-B8C1D48F7498.htm#BIPDM-GUID-BBCC37B1-40C…

2. Pre Process Function - https://docs.oracle.com/middleware/12213/bip/BIPAD/GUID-D10CB848-B225-48FE-9169-D47D6B28FF58.htm#BIPAD287

Tim

Dir_Pal

timdexter

Unless I can see your code, its really tough to help :0)

Dir_Pal

Well I am getting this error tim as I am not passing any non numeric value please do the needful the error is as follows

oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Dir_Pal

I will go through it and let me see if I can get through it.

Thank u Tim

timdexter

either will work then. But to test I would try out the Pre Process Function. Check the documentation link.

Tim

Dir_Pal

The only solution I found isby allowing the type of user on weblogic will work.