Do you have everytime the same data? In that case, more easily, you could use it down on the filter panel. I used this kind of thing for WriteBack method (necessary condition to insert a new row into DB) SB

hi to everyone... first of all i'd like to thank you for support and your tips. i solved issue with a view and a union all with a dummy record. In analysis, i filtered with a rcount(1). rcount(1) >= Case when la max(rcount(1)) >1 then 2 else 1 end in this way i have what i need. Thanks again guys SB

Hi everyone: On Sql, this works fine: select DCNN,VALUECPS,NETWORKOPERATOR from OPERA_INV_BE_DEV.V_AMUSER_CPS where DCNN = '000000' union all --edit, of course it's quicker select '0',-1,'' where NOT EXISTS (SELECT DCNN,VALUECPS,NETWORKOPERATOR from OPERA_INV_BE_DEV.V_AMUSER_CPS where DCNN = '000000') If i use this code in…

Ciao Chris Could it works? create a new table on RPD and make an sql as source: <span class="kwd">select</span><span class="pln"><br/> 'A'</span><span class="pun">,</span><span class="pln"> 2<br/></span><span class="kwd">from</span><span class="pln"> my view<br/></span><span class="kwd">where</span><span class="pln">…

Chris, with union query i'll see in all cases dummy record...right? or i'll see dummy record only when the first query is empty?

Just to be sure... when you talk about 3 or 4 reports, you mean in the same analysis right? is it possible to take another analysis if the first one is without datas? would be grea!

First of all thanks to all of you for your answers ... What about filter? Actually view is empty and tomorrow procedure will fill it so i can't test it as i would. In both queries should i use same prompt? pippo pluto paperino union '0' -1 null first query has pippo = '12345' do i leave second query without filter? if yes,…

thanks for your answer, but this will not suit to the request.

You right Christian! this is the best moment to work without noise around me (my wife ) Anyway... This issue because all project is using web services request and they use XML query. Results looks like <Row> <Column0>0185319802</Column0> <Column1>2</Column1> <Column2>INFOSTRADA</Column2>…

You right Christian... Sorry for that do you agree with Gianni there isn't solution for this request? what do you think about it? i really would like to know another point of view thanks a lot

Yes. they must have as SA. Tomorrow we'll have a meeting... we'll see. Thanks again for your support.

Ciao again Gianni and thanks to spend your time i really appreciate it. yesterday night i was thinking to do a view but is not dinamyc (filter can be changed). As i told you is a self reporting and users make their own report. even if i could create a view (in this way) select c.circ_id as ID from pippo a, pluto b, pippo c…

Ciao Gianni!!! Your answer is EPIC XD. unfortunately is all true and end-user has rejected my solution with alias. he said that second field is "misleading" and test is KO. Probably you know better than me that end-users ask to us impossible things... and our rule is to find work-around solutions. i was checking inside the…

Ciao again Christian! i'm writing you (and to all users in this forum) to ask you another question... today end-user has tested solution that i found some weeks ago. it works (adding an alias filter field from it)... but he doesn't want it. he wants just one field. Just to remind you, this is what he'd like to have as sql…

Thanks for your help Chris

Ciao Christian, Sorry but i was waiting a notify through email and i didn't receive anything... Anyway i found the problem that was in LTS... i added a dimension join into it. Now it works fine. just another question... i don't remember if in OBIEE 10 or OBIEE 11 there was a problem with arrow direction during join tables.…

I found the solution by myself after a lot of attempts... I write here in case someone will meet with same problem. The question was how to insert a prompt parameter in SOAP xml file (in this case). You have to add a filter and edit with "turn it in sql" adding a variable in this way ex:…

Ciao Christian and thanks for your reply! i would to see just a distinct code with the count id and the description with the max data. this is the result: codecount(id) description date 122 2 brontolo 10/08/2016 (OK) 133 3 paperone 10/02/2016 (OK) starting from these datas: code count(id) description(JOBTYPE)…

Ciao!!! i found the problem... in aginity tool, i have a DB version different then DB production. I was trying report on OBIEE that target to DB production. Following some web links, tells that we have to install that particular GROUP_CONCAT function in Netezza DB. We're still waiting the answer from the manager. Thanks…

Ciao!!! i'm testing this function on Netezza DB. With sql it works fine and i see what i want. Now i'm trying to use Evaluate_Aggr on Obiee but an error occur: this is the formula that i used: evaluate_aggr('GROUP_CONCAT(%1,%2)' AS CHAR,"FE_F_CELLE"."CODIFICA_CELLA",'-') and this is the error: Odbc driver returned an error…