Do you believe you will get a discount on the license by double posting? Is BI Management Pack available for OBIEE 12c ? Double posting is the best way to: 1) not get any answer as the OP doesn't look serious and will not follow up 2) pollute forums with forever-open and not followed threads

Hi, For that kind of requirement you can maybe solve it with a bit weird workaround as long as things are exactly as posted. You will need a measure (in your example you don't have any measure) which count the number of users by activity (so a count / count distinct on the user). In the analysis you apply the filter on…

The miracles of Google .... https://docs.oracle.com/middleware/12212/lcm/RNINF/GUID-10F524EA-A008-4868-8AA5-3F19C7E787FE.htm#RNINF-GUID-7A3B718B-8205-44C5-9663-424A553070E0 From the doc: You can ignore this error because Node Manager does not use ADR. So yes, lot of people see that error (actually I guess I saw it in most…

After Christian pointed out a "detail" I skipped ("any other tuple of data") it's still not something OBI can do easily, and also something that SQL will require to store a lot of data (for every other possible tuple). So a different technology, as Christian said, would match better.

Hi Robert, A "nice" requirement Honestly the best "non-resource intensive way" crossing my mind is you do that by ETL while loading your data in the source. As the calculation must work on all the rows not selected by the filter it will be a nightmare both from a logical point of view to write in OBIEE and performance…

Well, it just works on the calculated item, of course you must have the same calculated item on the "detail" analysis. As I have a little doubt I put together a quick example: click on the calculated item of "master" automatically switch to the same calculated item in the detail.

After the super high quality of what I saw yesterday evening on TV .... yes, I HAD to mention it !

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).