Aren't you just having the java "random vs urandom" issue? A long start time often point to that as one of the first things, so look at your entropy when you are about to start and during the start process and fix that one if too low.

Download Oracle Linux 7 (I guess it's now 7.3 or so), add the ISO to your VMware as DVD, the installer is graphical and kind of intuitive (even partitioning done automatically if you want). Just select in the list of packages the "Desktop" option so you have a graphical interface. Linux is installed. Then the install of…

You are on a NAT network, which means your VMWare host is acting a DHCP server and assign an address to your VM. But when you restart a VM you often get a different IP (like a +1 because the previous was taken). Now your OBIEE as it is installed expects to be on 192.168.68.158 , if your VM doesn't have this address it will…

Alex1 wrote:like I said before, I have installed obiee in new virtual machine... How does your VM get an IP? If it's DHCP then it's possible your VM changed IP between the install and now and this isn't good (that's why an OBIEE install on a DHCP environment often start by installing a loopback adapter so that there is an…

1037520 wrote:Hello,I'm trying execute a sql server function from obiee 12c, and i get this error. How does your "try" looks like? How does the analysis looks like? What's the formula you used? More details you provide, more chances to get a proper answer focusing on that exact case...

It's written in full letters if the cache is used in the logs, and you also see that no physical query is generated and executed.

It must be a search at the XML level, so filesystem or by using Catalog Manager. The web front-end works on the "OBIEE content" level, not the source code itself (XML).

You probably aren't aware of the almost unique common rules about licensing with Oracle: the price depends on how good you are in negotiating with your Oracle sales guy Honestly licensing is such a customer based thing which means each one has a different deal and agreement, the best is you get in touch with your Oracle…

Look at the logs, everything running on your system leaves some logs, everything doing an query has logs there (with the info if the LSQL has been sent down to a database or matched a cache entry).

Hi, Objects (meaning catalog objects) are referenced by using their absolute path, so if you search for the path of your given object in the whole catalog you find all the references to it.

Not really, OBIEE will see your JSON as what it is: a string ... But what you can do is to take that JSON and so something with it in a the visualization side with D3 or any other JS library as they manage JSON easily. It's just an indirect way of doing things ... An alternative way could be to add opaque views in the RPD…

Hi, You can definitely do it, just think more "analytics" and less database. Sure you can use EVALUATE and push that down in the database but then you will be strictly linked to your database with physical SQL in your analysis. Ideally in your data you would have a flag generated by your ETL (or something else) to flag…

Are these things measures? Or attributes? What's the aggregation rule in the RPD?

Hi, Let's go back to the beginning ... First of all: what's the exact version of your OBIEE? (including bundle patch) So everything is fine except your grand totals and to make it work you need to switch the "Aggregation Rule (Total Row)" from "Default (Sum)" to "Sum"? Or by default you have something else? What's the…

Thomas gave you the solution: a flag in your data ... Because what you are asking is something like: if there is a single negative value for any period then display the whole row, with all the periods including positive and negatives ... I would say you can still make it, but the conditions will be a bit more weird. What…

3506585 wrote:In 11g it is not necessary to set this settings. Are you really sure? Didn't you just set a system-wide default for that data type in your 11g? Because out of the box I'm kind of sure 11g always display numbers without any decimal ...

By ordering the columns you use on your X axis correctly you get the same, with axis labels not grouped and without the big spacing in between products. But you get the same kind of output ... from an information point of view ... As said by Christian: if you want exactly that then a JS charting library like D3 is what you…

Isn't this the same/strictly related to Report to display negative values only. ?

Hi, You maybe posted in the wrong forum or forgot parts of your message ... OBIEE doesn't store any data, so ... what are you talking about?

Hi, I will answer you with a question: are the jobs over? Because if they are in a running state (how long doesn't matter) and they aren't over there is not problem at all and everything works as designed.