3301055 wrote:We are in France. its almost 7 pm, .... ... and it's almost the end of the country because of the candidates they have for their presidential election ... So ... good luck for whatever happen after Sunday, an OBIEE error will maybe be the least of your problems

3301055 wrote:Nevermind, i did find my answer. Good for you that you found your answer, so maybe you can post it back here and flag it as the answer? It's the idea behind a community forum (take and give, give and take).

Hi, I highly doubt many people remember by heart a random error code like that. So if you want some answers you better invest a bit of your time in providing some context ... So my answer to your question is: no.

Hi, You maybe missed a detail on how the new command to upload/download a RPD in 12c works: you don't need to be on the server at all. If you installed Admintool on your windows laptop/workstation, you have the command there locally to upload or download a RPD from the linux server without touching the server at all. Of…

Did you try a calculated item instead of group? The calculated item has an option to hide the calculated item members, so you don't have things in double. In the example of the screenshot "Audio&Camera" will be added to the list of items in the "Product Type" column and because I checked the checkbox to remove items…

Hi, Maybe you better provide some context .... In OBIEE (the forum you are posting) itself nothing is named "Candidate Selection Workflow", so you must be talking about a different tool (so maybe posting in OBIEE isn't the right place? no idea as there is not context for now ...).

If all you have (or look for) is a GET or POST and you then check the HTTP code you get back try with this: http://<hostname/ip>:<port>/analytics/saw.dll?bieehome&nqUser=<username>&nqPassword=<password> This one will open the homepage doing the login automatically. It will return you a HTTP 302 with a redirect to the URL…

Can you flag your last post as the correct one? So people will not have to read everything and will directly see the answer (and it will also close the thread which is This question is Not Answered. for now)

Hi, It's a bit more complicated than just check a URL if you really want to check OBIEE. Sure you can load a page like /analytics, but this doesn't mean that the login work for example. So you can simulate a login (posting the form etc. or using nqUser and nqPassword in the url). But here again it just means the login work…

I can have this error when I try to write a CASE WHEN in a physical foreign key join. This is what Christian first said: if it's a "simple" join you must first delete it and create a new one which will be saved as complex join (with the CASE WHEN directly) and not as foreign key join.

You know that if you post directly everything we are not going to try to guess what you maybe try to do?

True: if the join is already saved as physical foreign key join first delete it. The properties window of the join clearly tell you the kind of join:

Yes, open the expression builder and write it there inside (so not directly in the textarea, the "Expression" field, of the join).

I'm curious: this worked but not this Hide Column in Grand Total row ? Which is exactly the same thing but you said it didn't work ... (the only difference is the screenshot taken on 11g instead of 12c Christian used)

Khalid Ibrahim wrote:After restarting services ... So it was working before! Who is managing that server? Who is managing the DB? Who is managing the network? Ask these people who changed what and you will also find out why you can't connect your DB anymore from the BI server.

And what about the "easiest" solution? Get these users in OBIEE. I don't mean the real people, just allow their account to exists. They don't need to be aware of it (so they aren't going to use the tool for real), but if the users exists you can then run the agent as these users and have your filters all applied based on…

Christian already said almost everything So you look for a set operation and not a by row operation. What you wrote just doesn't match, you can't with a simple query do what you asked (try to write the SQL doing what you want and I can bet whatever you want it's a bit more than "user='a' and user='b' and user='c' ".…

You are welcome, and +1 for @Thomas Dodds about the qualified name: I just always believe this one is checked all the time :s If you manage to make it work and got all your answers you can maybe close the thread at some point, for now it's still This question is Not Answered.

Just did a quick test: With FireFox 53.0 (32-bit) I can perfectly login without issues on a 11.1.1.9.0 (Build 150415.1247 64-bit) OBIEE. So ... not sure the exact version of your OBIEE but if it's a .0 then it's not really a Firefox issue (I didn't change or set anything special in my Firefox). Did you try the classic…

@Sandesh AG : did you give up on that one?