check below document , https://blogs.oracle.com/xmlpublisher/entry/dynamic_report_titles

This is expected behaviour , If BIP is installed as part of obiee the permission tab from xmlpserver by default is disabled ,analytics and xmlpserver will share same catalog ,so you can assign permissions to bip objects from analytics. Thanks

please upload xml and layout , will send you updated , thanks

please upload template and try to use table for aligning the fields for displaying in fixed positions.

I think you are applying left group on product column. please apply outer group by product and place to display in inner group. if you find issues , please post code you have applied in layout.

Excel Template is a plugin to excel sheet and it allows you to create report template as per your requirement using sample xml data. once you are created template then you have to upload excel template to bip server then it will point to database to show data in the report. please go through document thoroughly…

create excel template to handle above requirement. have a look at below document https://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T527073T571887.htm

upload Template

https://myoracleappsworld.wordpress.com/2015/03/19/to-reference-a-parent-level-element-in-a-child-level-table-bi-publisher/

please go through the HCM data model and find table related to above fields in the screen shot.

please post query associated with above report and also post screen shot of parameter section in data model. Thanks

please check the Click to add to Favorites Fusion BI Publisher - Getting Error While Passing Multiple Values In Dashboard Prompt For BI Publisher Report (Doc ID 2214582.1) To BottomTo Bottom In this Document Symptoms Cause Solution References Applies to: Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later…

please use different web browsers and if you have access to bi publisher scheduler database tables you can remove from there based on job id. Thanks

Directly develop the query in Toad or sql developer or sqlplus and paste directly in the data model,its good practice to write.

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…

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…

please upload screen shot. thanks

Please handle at source level by using group by clause or apply group by in template on functional classification column. Thanks

Please upload RTF Layout and xml , will send you Updated Layout. Thanks

If you can think hidden param is passing value , you can try this As you said you have 3 values (3 options in param drop down) , along with 3 values create or add extra value 'ALL' . so total value will be 4 and keep this 4th value as default in parameter section and disable parameter then run the report. Note: you have to…