https://www.youtube.com/watch?v=5CgBmj7Jz6Y&t=19s (Tips for Getting Answers to Your Oracle Community Forum Questions)

For my tests I often need a "new OBIEE", so instead of installing on my host or on VM I do it in docker as it takes less resources than a VM. That's why I didn't have to uninstall and all I did was calling the RCU doing a "dropRepository" as I didn't want to use a new RCU prefix. But then it's like a VM, so I just deleted…

Hi, Not sure you are the same person or just 2 different having the same exact question and code Actually the answer is correct, it's HTML! You can keep it as a GET request, that's what the system expect, and if you do it in your browser what do you observe? You first see a spinning "login" image and then, depending on how…

Hi, I had something similar again once (still in my docker container), but as I was in a hurry I didn't spend time on it: killed the container, removed it, cleaned up the RCU schemas and started a new one You can check the logs of bi_server1 in user_projects/domains/bi/servers/bi_server1/logs/ There you must find a lot…

Just a detail: keep in mind a link is supposed to start by " http:// ", so if your values don't have it (all of them) add it to the format of the column. The default format "HyperText link (prepend http://)" does it for you, but in this case if you have some with and some without it will not work as http://http:// will not…

If you were using the exact same as you wrote here the brackets were the problem, the bracket must be closed before the THEN as it's part of the condition [ WHEN <condition> THEN <value> ]. But good you could do it. Of course keep in mind that nested case-when (or even just a case-when) will have an impact on the query…

What Thomas posted is the cleanest and right way to do it as it also cover the special fiscal calendars (often fiscal <> normal calendar). Apparently your dimension stop at the month level, so it's a bit more difficult. You can try something like: SELECT YEAR(CURRENT_DATE) FROM "your subject area"

OBIEE accept a CASE WHEN statement, so just write it right and you are done : CASE WHEN "tab1"."col1" = 'A' AND "tab2"."col1" = 1 THEN 'Value 1' WHEN "tab1"."col1" = 'B' AND "tab2"."col1" = 2 THEN 'Value 2' END Your columns are CASE WHEN ? Not a problem ... CASE WHEN CASE WHEN "tab1"."col1" = 'A1' THEN 'A' ELSE 'B' END =…

Hi, If your column is a URL set the format in the Criteria tab of your analysis to URL and OBIEE makes all of them clickable and working links. It's just a column format as can be number, percentage etc.

First thing you are hijacking your own thread, making it a bit useless for others with similar questions as you change (add more) question in the same thread. To keep things useful for everybody (it's a community forum) if you got an answer working for your original question close the thread marking as required. If you…

It's about entropy, or actually the lack of entropy in your system. There are lot of things written about that and I'm not going to try to summarize them here (in case google about java weblogic /dev/random and /dev/urandom and I guess you will find lot of them). What I did in my OBIEE container to fix the timeout giving…

Are you using the right command and pointing to the right place? Because if "ssi" doesn't exist I doubt your OBIEE is working at all (actually I don't imagine it's up and running, even with a empty RPD).

Can you check something in the log? Is the timestamp of the log lines between the previous successful thing and the error about 5 minutes later? I just saw something similar to your logs 10 minutes when configuring OBIEE and it was because of the java random vs urandom (so changing the config to use urandom solved the…

They are not there = you don't see them or they are not there = your RPD is empty?

Did you try to look at what kind of query is executed when you select "all values" in your prompt? Because that's how you can then find your solution: look at what is done, apply the required piece of logic to manage it and give you the expected output. What you already know is that "all values" doesn't mean the variable…

I tested the formula over a year and the result was good. Now if your case is different than what you posted of course things change ...

Daniel, 50 is the correct value if you look twice at your formula: in the total count distinct work on all the ID forgetting the month, so it just find 5 distinct IDs. You can force the things by setting the "Aggregation Rule (Totals Row)" of your column to SUM instead of Default.

CEILING(CAST(DAYOFMONTH("Time"."T00 Calendar Date") as DOUBLE) / 7.0) (the cast is because of integer division ...) This gives you the week number per month, concatenate it with a reference for the month and you have your week. So something like 2017-03 week 1, 2017-03 week 2 etc. (based on your definition of week you…

What's the full request headers your java client send? I guess you are missing some and that's why you end up on the login page, so post all the headers of your request and let's see what you are missing PS: do you agree your client can follow redirect and send back the cookies it received, right?

Sorry to ask but can you define "customize mapping" ? (in my mind they are all custom as starting from a empty file, so trying to figure out exactly what you look for) PS: https://www.youtube.com/watch?v=5CgBmj7Jz6Y&feature=youtu.be&t=18s will help in getting better answers