1578785 wrote:No, Same issue at SQL Developer... Well, if the view doesn't return you any data in SQL Developer you can't expect OBIEE to show you something (the tool can do a lot, but create data which doesn't exist ... not really luckily). So you maybe want to go back in your load process to see if the sources the view…

Hi, Congrats in migrating your content, hopefully the login is just a "detail" Can you check in EM if your weblogic user is still member of any OBIEE application roles? The migration also import that part of the security (when run with default settings), so you maybe just got your weblogic account out of the required…

If I'm not wrong we can say "Standard" is like Essbase + Data visualization (similar to Data Visualization Desktop in term of functionalities), while "Enterprise" is a full OBIEE. You will have full access to the "server" via SSH to configure or change what ever you want. So OAC is a real cloud hosted OBIEE with all the…

As long as you open the right ports of course it does ... It's a database in the end ... But you maybe want to first look at OAC? OBIEE on the cloud in the end ...

I maybe missed a bit reading ... Of course if in the prompt you define to set a variable it works just like a dashboard prompt as Christian said. If you don't define a variable there isn't a syntax to reference the values ( that's what my 1st answer was about).

So you already have your answer ...

Going back to the original question of "where does the boolean come from" : I would say the boolean is the result of your EVALUATE. EVALUATE doesn't have a type and OBIEE has no way to know it's a date. There is some flexibility with types and that's why your = or IN works I guess, but to use > or < you need to cast the…

Hi Robert, Don't think it's possible (without setting a variable). The embedded prompt works directly on the same columns (replacing the hardcoded filter or the "is prompt"), but isn't defined as variable itself (automatically). You have the "filter view" which will do that (but probably also show other things you would…

I knew there was something special So first of all what Christian just posted: why to make it complicated when you can have an easy solution Second option is to use OBIEE to build your dates, TO_DATE has an equivalent in OBIEE: TO_DATETIME OBIEE in IL: OBIEE - TO_DATETIME the secret function

Hi, The issue is that you expect the formula to be smart enough to understand at which level it is all the time and so identify the parent level accordingly. That's asking too much ... You can manage to "% of region in country", "% of country in continent" and "% of continent in total" but it will be separate things, not a…

Different question instead of an answer: why do you use EVALUATE to do a TO_DATE ? OBIEE can manage that kind of thing without having to use an EVALUATE and disturb the DB for that kind of job ...

https://en.wikipedia.org/wiki/KISS_principle It has been said few times: use a host-only connection (as main or 2nd network adapter). No need of any port mapping, no NAT, no nothing, no issues. Your VM will have a new IP (probably 192.168.56.101) and that's the IP you will use to connect.

Sorry but ... do you look for somebody to read through your 250K rows of log file and fix your problems for you? For that ask your colleagues by opening an SR and have fun with the full process. The idea is that you look at the log to identify why it doesn't start (which means that you try to start it and look for the…

3257772 wrote:Is there any native view in OBIEE like the one in the following links No, nothing native like that. You only option is to use an external library (like Google or any other kind of JS library).

Can't you manage that by setting a different style at the dashboard level for these users? Some time ago I saw somewhere an example of an OBIEE setup at Mazda where they had 2 kind of styles: one white and one dark and defined it at the dashboard level. So the users had access to a white or dark OBIEE depending on their…

Why not adopt a "keep it simple solution" ? No port forwarding required, you can keep your first network adapter as NAT but you add a second one as host-only. SampleApp will have end up having a second IP like 192.168.56.101 (it's DHCP starting at 101 on the 192.168.56.1/24 network). SampleApp keep access to internet if…

Hi, As an indirect answer ... Every single time I saw something like that I never saw a single administrator seeing that there was an issue. Mainly because admins setup a rule to move or delete these emails that keep spamming them or just have something else to do than count how many emails they got and when. If you want…

3478384 wrote:The HTML output shows no page breaks. How does a page breaks looks like in HTML? HTML doesn't have any page concept, so you can't really expect to have a page break if the idea of page doesn't exist. That's what HTML is and how things work. For the same reason you will struggle quite a lot to have a nice…

The miracles of Google .... Web Tier Overview Oracle HTTP Server Oracle HTTP Server (OHS) is an enterprise grade Web Server software - based on open source Apache HTTP Web Server - designed to deliver the following benefits:Deliver HTTP Listener for Oracle WebLogic Server through built-in WebLogic Web Server Proxy…

AliasTab1C is useless, that's why Christian only introduced this new alias as the right-side table at the end of the new path. There could be ways to use your current 2 alias of Tab1, but to be sure the existing one keep using the old route you better add a new alias. This way is safer. (Because in the end OBIEE generates…