parameter values not working for admin

Raghavenders

Summary

parameter values not working for admin

Content

Hi,

when I login as administrator unable to view lov values in parameter for all the reports.

Can you help me come out of this.

Venkat Thota - BIP

please upload screen shot. thanks

Venkat Thota - BIP

please post LOV query with :xdo_user_name , administrator not required to be in database but you have to handle explicitly , example : if you logged with administrator user and this user no more exists in database and no LOV will get populate in parameter, so what you can do is specify condition like select * from table where (case when lower(:xdo_user_name)=lower('administrator') then lower(:xdo_user_name) else lower(username)end)=lower(:xdo_user_name) let me know if you still have issue. Thanks

Sandeep S. Chauhan-Oracle

Hi Sonu,

You will get the values in drop down if your List of Value query is returning the records, check LOV query in data model.

Possibly, In your case your parameter is set with "Can select All" option checked & LOV query returns no rows.

-Sandeep

Raghavenders

Hi Sandeep,

Actually for that parameter i'm passing as (:xdo_user_name) to access for the particular users.But I want to know whether the administrator should be there in related DB as application_user so as to display lov_values for admin user.

Thanks,

---Sonu

Raghavenders

Hi Venkat,

I'm providing the screenshot for your reference when I select division it is not displaying any values and the same happening for the rest of parameters.

BI Version: Oracle BI Publisher 11.1.1.9.0

Thank you,

Sonu Upadhya.

Venkat Thota - BIP

I think you can rewrite above query to small SELECT DISTINCT MER.DIVISION_NAME FROM SEC_USER SU, SEC_USER_GROUP SG, FILTER_GROUP_MERCH FGM, MERCHANDISE_HIER_V MER WHERE SU.USER_SEQ = SG.USER_SEQ AND SG.GROUP_ID =FGM.SEC_GROUP_ID AND (FGM.FILTER_MERCH_ID =MER.GROUP_NO or AND FGM.FILTER_MERCH_ID =MER.DEPT) AND FGM.FILTER_MERCH_LEVEL in ('G','P') AND (case when lower(:xdo_user_name)=lower('administrator') then lower(:xdo_user_name) else lower(SU.DATABASE_USER_ID) end)=lower(:xdo_user_name) Run above query in sql developer or toad and enter administrator as bind value to :xdo_user_user and check data is populating or not, if populating data then copy same to LOV and check. Thanks

Raghavenders

Hi Venkat,

Please find the query related to division parameter and I want to know whether administrator as user must be there in that related DB or not necessary to access lov values.

SELECT DISTINCT MER.DIVISION_NAME

FROM SEC_USER SU,

SEC_USER_GROUP SG,

FILTER_GROUP_MERCH FGM,

MERCHANDISE_HIER_V MER

WHERE SU.USER_SEQ = SG.USER_SEQ

AND SG.GROUP_ID =FGM.SEC_GROUP_ID

AND FGM.FILTER_MERCH_ID =MER.GROUP_NO

AND FGM.FILTER_MERCH_LEVEL ='G'

AND SU.DATABASE_USER_ID IN(UPPER(:xdo_user_name))

UNION ALL

SELECT DISTINCT MER.DIVISION_NAME

FROM SEC_USER SU,

SEC_USER_GROUP SG,

FILTER_GROUP_MERCH FGM,

MERCHANDISE_HIER_V MER

WHERE SU.USER_SEQ = SG.USER_SEQ

AND SG.GROUP_ID =FGM.SEC_GROUP_ID

AND FGM.FILTER_MERCH_ID =MER.DEPT

AND FGM.FILTER_MERCH_LEVEL ='P'

AND SU.DATABASE_USER_ID IN(UPPER(:xdo_user_name))

ORDER BY 1 ASC