Thank you Mike, really appreciate sharing your experience with us, will give it a try.

After talking to @Christian Berg-Oracle @Christian Berg-0racle offline, and finding the answer to my above question, we thought we should update this thread. Key points of a) the recipient list request and the payload request can be completely disconnected (even in terms of source, Subject Area, etc) b) The list just needs…

No you are right, I was looking for this to be applied BI Answers, but I thought I would give it a try also in DV, that is all. Thank you Gianni for your help as always. Joe

Thank @Gianni Ceresa I created the below formula in a column and worked in OBIEE answers but not in DV, in DV the same value kept repeating, the first value of the 4 EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)',PRODUCT)

Thanks @Gianni Ceresa It seems the only way as you said by writing the logice of Analysis 1 in the formula of a column in the analysis 2 but still going through challenges, can I give you another scenario which is more close to what I am trying to do. I have an analysis, made of booked orders in current quarter. Some of…

Thanks @Gianni Ceresa Image on top is how it is today, trying to have it as the image underneath

Thank you Gianni as always.

Thank you Gianni Just to make sure, Create a presentation variable Create a column with a formula like this TOPN("Fact - SSS"."Amount (USD)", @{top_customers}{10}) , called the column Top X And that is it? no filters, right?

Thanks Gianni for taking the time, I personally dont have access to the RPD.

Thank you Christian, really appreciate it.

I was going to try to use the substr and locate etc to find a specific word among a paragraph which I was able to do in OBIEE 12C but it seems it is not working for me in OAC DV..so I decided to write a case statement to say : case when "column that has a text" like '%##DIS%' THEN '##DIS' else '' end...will that work? it…

Thank you Christian as always- and again welcome to Oracle

Thank you Gianni

Thank you Gianni as always.

Ah ok, I understand - thanks for confirming @Christian Berg

So when we add the export link, the user has the option to export as DATA>CSV...therefore there is no option for us to show or hide specific columns in the export? per the original question. or is there and I missed it? Thanks Joe

Thank you @Christian Berg and @Gianni Ceresa Sorry about the not specifying if it is the OBIEE Anwsers or BI Publisher, I am referring to the OBIEE Anwsers/Analysis Thanks Gianni for the explanation between data type and formatted type of exports. So if I build a view using only a subset of columns and expose that specific…

Now I know what you mean, thank you both, really appreciate your support.

Thanks Christian, would you kindly explain more how to put different buttons displayed and how to hide/show based on user rights? Thanks

Thanks Christian