Is this what you are looking for => Vishal's blog: OBIEE 11G: Setting multiple values to Presentation Variables through goURL and conditional filtering

You are correct, my motive is not the points, but I do care about justice - you gave the answer, I only gave minor aid in understanding it, if any answer is marked correct it should be yours.

As previously advised try the 4 file method using an empty file, or copy of your original twice, favouring the dev version on changes.

Which are you using as current and which as original? Do you have the 'Equalize during merge' ticked or not?

I think if you use the 4 file strategy detailed then you get the dialogue. n.b. One of the four files can be empty!

See step 30 in the below for an example of what I mean; - http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11115/import_merge/merging_importing_11g.htm

And when you run merge does it not report the clashes and give you the option which to accept? a. Source 1 b. Source 2 c. Target If a and b clash then which to c?

From memory you can generate XML files from rpd in 11.1.1.9, yes? There are a number of ways you can compare XML files -> https://www.google.co.uk/search?q=compare+two+xml+files+for+differences&rlz=1C1GGRV_enGB768GB768&oq=compare+two+xml+fil&…

What you describe - added manually - is how it works. There is no standard means to automatically send to all users who exist using 'Run As Recipient' - other than encouraging them to self serve - the majority of the power of OBIEE is in interaction; drill down, personalisation, resort, repivot, etc etc; - flat…

Hi, don't know if you are following what Christian has advised / my dialogue with Christian? If not then; - 1. Run as recipient emulates what would happen if that user logged in and run the report as himself - he would see all rows - yes? 2. You need to build some extra logic into the report to filter by user So, you would…

Thanks - and yes you confirm how I had understood it, and I think it is me who is being slow in fully understanding what the OP has posted. I have just re-read it and I see that the OP seems to be expecting 'run as recipient' to 'know' that it should add a filter on the e-mail address, which is not what happens - unless…

Thanks Christian, no criticism intended or implied, just trying to understand if the position has changed as it was back in 11.x versions I did this last... My question is that the OP seems to be saying; - a. That they have row level security in their subject area b. They are using 'run as recipient' In these circumstances…

Hi Christian, I have not used this functionality for some time in OBIEE - generally for bursting it tends to be BIP - but I had understood that the solution works as described by @Gianni Ceresa - in this detailed explanation from this post -> Quote: - "Hi Ebin, In the tables (S_NQ_JOB & S_NQ_JOB_PARAM) no real change, it's…

Trans: the lunatics running the asylum.... 

Do you have row level data security applied that means that when the afore mentioned users run the report manually that they currently only see their own data?

And what are the equivalent logical joins here for the dates? And can you post the physical sql that is generated when this runs? And looking at your other joins am I correct that the two fact tables conform on everything apart from the time dimensions? Do any of the other dimensions feature in the analysis that could be…

Hi, OBIA is subject to copyright / licensing, but if all you are after is a platform to learn on then you could export the DDL for the tables using a tool like SQL Developer and recreate them on local schemas of your choice.

Yes - the million dollar word in my comment to you was 'guess' - without the full picture that is all we can do, make educated guesses as to the requirement...

My thinking on sum by was that it gives a single value for all of the values that he would concatenate - like you my thought was listagg - but then I looked again and wondered if this was missing his requirement (i.e. I ignored what he asked for and tried to guess what he was actually trying to achieve)