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…

You got everything already in above answers but just to recap: - rename to the right filenames, it isn't .zip, but .zip.001, .zip.002 etc. (right names isn't an option !) - check the checksum (the names in the checksum file are the exact names your files must have) - if with the right names your standard unarchive utility…

Isn't this the exact same thing as Dashboard prompt - report not generating ?

Check this: https://blogs.oracle.com/proactivesupportepm/obiee-12c-infrastructure-tuning-guide Follow the link to MOS and download the PDF. Point 4.3 is about JavaHost and they talk about Excel exports. But ... do not randomly apply everything because it's written. Always read the PDF first, compare with your use case and…

The export also bring into the equation java memory settings for javahost etc. Ideally you must check the settings in all the components getting into the loop. If you look on MOS there are documents about that and the tuning guide probably also cover that.

Hi Pius, How are the permissions? the 2007+ exports require the user to have access to its own personal folder as it's where temp file will be generated. So depending on security this can be an issue. Other problems can depend on the size of what you try to export: so are you doing a database dump with Excel via OBIEE?

Hi Robert, Yes and no .... Meaning that if it's 11g the legend is inside the flash, so you will not manage to manipulate it. If on the other side it's 12c (or 11.1.1.9 configured for that) and so the charts are HTML5 things yes, you will be able to interact with the legend and hide things. But like always the problem here…