Use the query builder in BI publisher and see if u can see the data. if you can see the result then it would be a different if u can not see the data results the access to the table should be problem also try using different browser which might help you

try this leave the numeric format blank

whatever the parameters u have given in the column does it have same font and size 23 might have different size than 3.26 or it might highlighted in bold just check all this.

Try masking the features from 0 to blank .. try format mask to null

well try reinstalling the java jdk and also check the path and restart which might help you

re-install your BI publisher desktop and try once again or post ur xml file so we can tell what the issue would be.

There might be few reason for it. the one I know is if u tried using sql query builder and still finds no data then u don`t have access to the data so either use the person id have access to that particular data which solve your problem. if thas not the issue I am not sure about it.

copy and paste your sql Query any, or take screen short of the query

https://docs.oracle.com/cd/E29597_01/bi.1111/e22254/create_lay_tmpl.htm http://sfis.blogs.wesleyan.edu/files/2015/10/BI_Publisher-course-HEUG-Clackamas-County.pdf

get me the regular one

not able to click on the image provided??

this will not much be help of getting ur help . You have to handle data model query to accept "all values" and "multiple values" ,

To make reports work with Multiple Select Prompts/Parameters, we need to handle that logic inside the sql dataset. Usually this functionality can be achieved using IN operator in WHERE clause . Example: SELECT * FROM W_INVENTORY_PRODUCT_D WHERE PRODUCT_NUM IN (:P_NUM) Above query works well until P_NUM parameter holds less…

OBIEE tips and tricks: OBIEE to BIP trick 

https://www.rittmanmead.com/blog/2012/07/navigating-to-bi-content-in-obiee11g-and-passing-multiple-parameters/

creating a sub-template will help you to solve the issue

2738487 Go to the option more and try deleting it and also do provide a screenshot what ur trying to do? Thanks

is this select statement in a subquery????? select debrief.ITEM_PACKAGE_COUNT from shipment_stop_debrief debrief where itm.SHIPMENT_GID = debrief.SHIPMENT_GID and itm.S_SHIP_UNIT_XID= substr(debrief.S_SHIP_UNIT_GID, instr(debrief.S_SHIP_UNIT_GID, '.')+1) and debrief.SEQUENCE_NO = (select MAX(debrief2.SEQUENCE_NO) from…

https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T421742.htm

https://docs.oracle.com/cd/E51367_01/fa_lcm_gs/BIFAD/bip.htm#BIFAD10473