Hi FTisiot , Thank you for the illustration . Also your observation "Just a bit of initiative sometimes doesn't hurt" is noted , but it's not obvious to know all feature of a system like OBIEE where you are a novice . Regards , Morel

Hi Pedro , thank you for your response .Please could you illustrate how to create a legend view then i will do the same and see how to manage it . Regards , Morel

Thank you to all ! works now Just happy to have advice from oracle's Experts . @Christian Berg Now I can close the thread as advised .

Thanks for the clarification Christian, So let me try to use HTML in my sql statement .

Hi Joel , I've tried to use the solution given but Am not able to see when can i write the code as you advised. Please see the below screenshot . Please could you send me a screenshot where can i write this code ? Thank you

Hi All , thank you for your different reponses . @Christian Berg and @Gianni Ceresa thanks for your advice but I cannot modify the current RPD it has been provided by the vendor so far we are discussing if we have the right to use their RPD, that why i am obliged to use DDR . @Joel Acha thanks for your solution , let me…

Thank you Christian , Please there is a way or some tricks to enforce the css of a cell based on some conditions ? Regards , Morel

Hi Asim, you right indeed it was permission issue , now it's work fine . Thanks for your precious advice . Regards , Morel

Hi Asim and all , any feedback please ? am stucked , I cannot publish the new report due to this . If someone has suggestions or workaround , please don't hesitate to advise . Regards , Morel

Hi Asim , thanks for the feedback . Please see on the below error am getting in trying the syntax you have proposed: Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError:…

Thank you Asim !

Hi Asim , am interested by your idea which consist to combine similar report , indeed i want to do the total at row level as am able to do it at column level now from OBIEE . But I looked for OBIEE interface , but am not able use combine report so my question are . * This is an OBIEE feature (am novice with OBIEE) ? * Can…

Thank you ! But I've just found how to do it without analytics, you have to change aggregation rules from criteria mode, to put none for the column for which you don't need to have total . Regards , Morel