Hi, Downloading a full dashboard in Excel first requires a special privilege. The easiest way to find the link you need to use for that is simply to look at what happen when you click on that button in the menu in your OBIEE. You will find what link to call if any or the JS function to use for it.

Well ... sometimes I write a bit faster, just enough to hijack your replies and add some extra (not requested) info all around I would just say I personally prefer to not have the " ELSE null " as just the default behaviour or any normal database around, so it's written for nothing (but maybe somebody will replace the…

The example of "duplicate measure with a CASE WHEN" is : right click on the logical column and select "duplicate", then edit the source of that column to add a formula (so instead of being just a reference to a physical column you go into the expression editor). The formula is just : CASE WHEN <your condition> THEN "the…

The hierarchy, not the level "Time"."Time"."Fiscal Month" : "Fiscal Month" is a level of the hierarchy, "Time" (the 2nd is the hierarchy name), "Time" (the 1st) is the presentation table. Try with just "Time"."Time"

As I don't have a running OBIEE 12c right now I only tested it in the front-end, there it allows me to use the 4th parameter in OAC. Can't say right now if the RPD has a more strict approach ... Can you try just writing the formula in the front-end to test first?

Hi, I wouldn't try mixing things like that. OBIEE is 12.2.x, and use Weblogic 12.2.x. The certification matrix doesn't tell anything (as far as I remember) about a possible compatibility with a lower version, but I would say it's a "no". Even if it works you will have no support at all as it's not certified. OBIEE come…

Christian Berg wrote:... basically a clone of the first one ... Which translate into: right click on the LTS and choose "duplicate", then set the mappings as Christian said

Hi Ebin, Add the hierarchy you want to use as 4th parameter. https://gerardnico.com/wiki/dat/obiee/obis/logical_sql/function_time#periodrolling Note that the PERIODROLLING function includes a fourth optional hierarchy argument that lets you specify the name of a hierarchy in a time dimension, such as yr, mon, day, that you…

So now you are double posting: OBIEE 11G SCRIPT ISSUE 3275937 wrote:i want to know how to use jquery in obiee 11g https://learn.jquery.com/about-jquery/how-jquery-works/ You are just totally missing the point, nobody here is going to do your work in your place. You got the answer 4 times already. You apparently have no…

It weirdly looks familiar ... Read the blog post again, it's clearly stated it can't work out of the box in 11g because of the lack of jQuery. It's clearly stated. The libraries are probably the same for the previous OBIEE 12c releases and will also work, with some little adjustments for OBIEE 11g (11.1.1.7, 11.1.1.9) as…

You read it wrongly ... The exact wording I used in the blog post is: Keep in mind jQuery wasn’t there in OBIEE 11g, so that’s the main change required. OBIEE 12c has jQuery deployed and loaded in pages out of the box because it is used by OBIEE itself. OBIEE 11g doesn't come with an "embedded" jQuery, so you have to load…

Hi, The fact table is displayed depending on how you created the join: when you create the join you click on a table and then click on the second one, the join has an arrow. That arrow is the one defining which table is on the left or the right. So it's your model, depending the joins you create (and their direction).

Nothing more to add than what is written in the blog post: The libraries are probably the same for the previous OBIEE 12c releases and will also work, with some little adjustments for OBIEE 11g (11.1.1.7, 11.1.1.9) as the main javascript libraries are the same.Keep in mind jQuery wasn’t there in OBIEE 11g, so that’s the…

What Michael said (which is also what was answered yesterday on the blog post directly)

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.