Hi, I think the OP has lost in interest in the question... But to explain my position, a message that is repeated, and repeated, and repeated, and repeated, and repeated, and repeated, and repeated, and repeated, and repeated, and repeated, and repeated, line after line after line after line after line after line after…

Sure, but I stand by my statement that the $ here is just noise, and if the currency is dynamic then any further analysis by the user is actually made harder as they then have to find a way to separate out the concatenated currency sign... And yes, I know you cannot then aggregate it with my rpad trick, unless you further…

Glad you got your answer, can you close the question please so others don't waste time trying to answer.

And looking at your error stack have you tried chasing down oracle.security.audit.Auditor to set the audit log location?

See 3.7 https://www.clearpeaks.com/configuring-ssl-obiee-12c/

Better not to do it. The dollar sign is just noise in the presentation, it actually detracts from the number, it would be better placed in the heading, or if it changes by record as a separate column, this is Business Intelligence not 'lets recreate excel because that is the best solution (sic) for everything'. But, if you…

Just use the 'line break' functionality to make new lines and hence a vertical presentation if it is reasonably small and you only want a single column.

Looking at the docs and asking colleagues I think the best you can hope for with your hardware configuration is active / passive, the latency with WAN would be too great.

Not familiar with supercluster, assume you are running virtual servers on this, if so see=> Oracle Apps R12 distributed / Multi-node Installation : Unix/Windows - Oracle Trainings for Apps & Fusion DBA https://docs.oracle.com/middleware/1221/core/BIEDG/GUID-B7BEA45C-A8C0-4591-B748-FC35C587DAE0.htm#BIEDG-GUID-5FA0BD38-FC3……

And your version of OBIEE?

In order to get a useful answer you need to state clearly; - 1. What is your current hardware / software configuration 2. What are you trying to achieve, is this disaster recovery or is this resilience?

Did we resolve your issue if so can you kindly close the question.

Did you resolve your issue? If not can you provide any further detail or if it is resolved can you close the question?

English expression - 'Big Shoes to Fill' - it means you are a hard man to replace.

Seriously though, I could never hope to fill your shoes....

One other idea that came to me, you could mis-use row level security imposed on a copy of your current subject area to achieve your monetary unit sample, but depending on your sample sizes this may run like a dog.

Before Christian says it, this is OBIEE, OBIEE = Business Intelligence, OBIEE = Data Extract and Sampling Tool But if you must hammer a screw in with the blunt end of a buzz saw then you could look into using evaluate to call dbms_random to generate random numbers, which you would order your analysis by, and then take the…

And sorry to keep posting on this, but final note. There are a lot of people now who call themselves 'data scientist'. For me a 'data scientiest' has a number of years experience in data analysis, big or otherwise, data mining, use of statistical functions, hadoop, pig, hive etc, but most importantly significant experience…

On the VM you need a lot of memory, not just for the install but once you start working through the exercises it also bloats considerably. And yes, it is worth using. On OBIEE you might want to see -> https://www.peakindicators.com/blog/enabling-r-in-oracle-bi-12c Topic: Big Data

Two other questions; - Did you try the above as a table rather than pivot table to see if you get the same result? Would a master / detail serve your purpose better if you are looking for a row level coordinated detail? https://gerardnico.com/dat/obiee/obips/master_detail