Do post the screenshot of the error of ur try and sample xml ur try to execute

Creating a sub template will solve your query

Creating a sub template will solve your query

I Dont see any sample attached ???

can u able to see the data with same logic in toad/SQL, well if so try logging with admin so some tables may not have an access in BI publisher without the access try this might help you

Have u tried going through this Doc https://docs.oracle.com/middleware/1212/core/OUIRF/install_screens.htm#OUIRF229

Mark it as correct answer if u say its right it will be helpful for others

can u share the screen shot of the rtf template what you are trying to do.

R u trying to do something Like this

Yes that should work fine accordingly

thanks ​ I have managed by dividing the column in rtf word document and also made a grouping which help me to fill the task.

Follow this doc which might help you https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-43E24DE3-F1DE-47E1-8B2F-C8ED59D619BA.htm#BIPRD3064

Some more info or document u can go through with http://vlamiscdn.com/papers/Preparing+for+an+Upgrade+to+OBIEE+12c+RMOUG.pdf

This is sample data from google but this is how exactly I want .. I jus want to seperate the column into two.... cant post the orginial

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

had done the trigger and function couldnt make it through as it made me hard choice but this is also one of the way can make it but long process . in changing weblogic allowing the user ID made things easy. well fetch the data of the user and logged in the name of user who is having the access. so now the table works…

oracle 12.2.2 version of BIP i am using it has parameters and I am using a view table from one of schema well in Toad it shows data if i pass the session.identifier if not it doesnt shows any data each query and subquery has been processed step by step and no error and data shows in toad by setting an identifier I am not…

has run in toad generates data through session identifier

I am not sure which way i can access in BI publisher when view the data shows the error as ORA-01722: invalid number. please do help thank you

allow the particular person to view the data