You already got the best answers above, so I just want to point out few details. You don't have to add a user in a group and than assign that group to an application role. You could directly assign the user to the application role if you want, but as they said above using a group is a good practice (because users can join…

Hi, The answer depends what's that install supposed to be: if it's a sandbox or test server you can have the DB on the same server as OBIEE (as long as you have enough hardware resources). As you can see in OBIEE Samples that's what they did there. If it's a prod environment is generally a good practice to split things,…

You will not find anything about it in MOS as the certification matrix is quite simple: RCU is only supported on Oracle DB, MS SQL or DB2 (not going into which version). So any other DB isn't supported and not certified and the installer or the RCU itself will not be able to run against any other DB. So even assuming that…

Nope, so far no documented or known way ... You can of course download a new copy of the "live" RPD, but that's probably not what you are after. If you desperately need to open your saved RPD you can always try to go through a SR but I suspect the reply will be the same.

You already got a bunch of replies, and as you can see the answer is into a mix of solutions. I would have a "all-in-one" solution, but it isn't an Oracle official tool or something you can buy on the market, just a way to put together all the metadata into a graph database allowing you to easily query the whole path: from…

Yeah, because in 11g the server needed the password to load and open the RPD, while in 12c the RPD is transformed into XML which isn't protected by password anymore. So the server do not need to know the password of the RPD (it's asked when loading a new RPD to be able to open it once, that's it).

That thing require the old password, the one which is missing in this case. Otherwise why to set a password on the RPD if an utility you get with the Admintool can just reset it?

Good luck and if all good come back to close the thread

I would say you can't .... The password doesn't exist anywhere else than inside the RPD. Keep trying with all the possible passwords (as it will not "lock" the RPD after some wrong attempts. Of course you can also script that and "brute force" it if you have at least an idea of what the password must look like.

What version of OBIEE are you using? I would guess it's a 12c and you didn't configure CSP correctly .... Look at https://gianniceresa.com/2016/10/google-map-in-an-obiee-12c-analysis/ (the part about CSP) and also https://obieeil.blogspot.ch/2017/12/obiee-12-with-external-images.html (also the part about configuring CSP)

Like that it must work (of course you can't say if the code/description is because of "origin" or "destination", but if you need that info you could easy add it). Plan B is what Christian said with "OR" (instead of your original "AND").

A complex join with a "OR" (because "AND" is impossible, ok ... possible yes, but a totally different meaning) works just fine in 12.2.1.3 . You just can't edit an already existing foreign key join to change it into a complex join (even if you open the formula editor when you save it will refuse). If you already have a…

That was actually an open point: did you wanted a single column for your code/description or 2 different (one for origin and one for destination) ? So the answer is: a single one! Fine: add 2 LTS in the logical table and point once to the physical object joined as origin and one as the physical object joined as destination…

Sorry but I would go with Robert first answer... Christian: I see what you say, and it would be right but ... the OP clearly try to match both foreign key at the same time with a "AND", which is logically impossible (or you open the door to 1=2 in SQL, and you don't want that). Your proposal could work with a "OR" instead…

How is that supposed to looks like? Percentage compared to what? (as a percentage is based on a reference value)

How many licenses for OBIEE you have? (as asking in the OBIEE forum) Not really, nowhere you enter the licensing details. You have to have the required licensing but the tool will not warn to block you (but if you get an audit you will pay it !)

Hi, You need to fix your code ... If the first time it doesn't display anything and need to reload it to see something it sounds like you aren't managing events correctly, and try to make some work too early when things aren't loaded (and it works the second time as things are in cache). You don't provide anything about…

You are welcome Kathie. MOS is a jungle: some days you are lucky, other days ... less

Do you know what a pivot is, right? A thing where you can select an attribute ("week" in your case) which will be display as many columns as there are values. So select the "week" and place it in the "column" part of the pivot view, place the measure as the measure and place the other attribute(s) (the one giving you…

Robert Angel wrote:I was not suggesting an 'exotic workaround' ... Your is clean, it's the original 53 columns with a FILTER inside what I call "exotic"