we can use VALUEOF(NQ_SESSION.USER), but that column which i used in report is not able to enable writeback

Thank You for your reply, Can i give user and data directly in writeback template as below <update>update table set c1='VALUEOF(NQ_SESSION.USER)' ,c2=NOW()</update>

Thank you I did freshly everything and it worked. just Update a column without where condition worked fine but when i am using an update with where condition it is throwing error. i am using all varchar columns and used single quotes. <update>UPDATE Table SET col4='@{4}' where col1 ='@{1}' AND col2= '@{2}' AND…

HI Yes, i set all as per document but still i am getting system cannot read template error

Not getting data from second fcat, getting nulls as below D F1 F2 1A 6 2D 7 3F 2 need to get data for F2 also

from where i can mark as helpfull, i am not able see that option here. So i am just replying as worked for me. please help

thankyou it worked

applied,Thanks.

i need No of records for C1 group by C1,C2 in OBIEE11g report as we do in SQL Select C1 from Table group by C1,C2

issue resolved, thank you for your help

i tried C2 = MAX(C2 BY C1) i am getting max date, but missing record if C2 is null i am not getting c2 when null need to get max if C2 is not null, if c2 is null i need that record too please help

this is also not brigning expected results, an other go

C2 = MAX(C2 BY C3) , THIS is brining direct max date not taking C3 into consideration, when aaa and bbb is available we need to get max date bsed on aaa , if aaa is ot avaiable then we need to get bbb with latest date C1 C2 C3 1 April 1 aaa 1 March31 bbb 2 April 2 aaa 3 March30 bbb 4 April4 aaa i need to get as 1 April aaa…

C2 = MAX(C2 BY C3) , THIS is brining direct max date not taking C3 into consideration, when aaa and bbb is available we need to get max date bsed on aaa , if aaa is ot avaiable then we need to get bbb with latest date

Hi This is helpful.Let me provide more details of my request C1 C2 C3 1 march31 aaa 2 April 1 aaa 1 April 1 bbb now i need to get 2 April aaa, i need to get lastet date for aaa , if aaa is not available then need to get bbb with latest date Thanks 2

Hi on report i am keeping max date

can any one guide on calculating weekdays excluding saturday and sunday in obiee11g report

ok

HI CHarles, Can you help me in setting up data level security. The user who logged in , they should be able to view only data related to them.I have settup this added user in console and assigned role in em. Created initialization block when i test it with userinput i am getting only user related data. Then again i have…

HI, Both are same version,I Am using OBIA and OBIEE 11.1.1.9.0