You aren't looking at it from the right point of view .... Your time hierarchy contains multiple data types, so what is the most basic and common format to represent multiple data types? Text ... OBIEE work assigning a single type to each column, so the hierarchy being represented as a single column they need to use text…

You can customize each level of the hierarchy. Expand the hierarchy (in the Criteria tab) and set the format for the levels you want.

What's the type of that column?

And the JS references above are also from 12c where there is no direct link for that visible in the code ... So not sure what change do you expect from a 12c upgrade.

I didn't say it was a link (so a change in the URL in your browser).... There are more chances it's done by JS, and you don't have a simple link to call for it but need to call a JS function (or at least go through the JS function calls to find out which is exactly executed and what it does). As said I don't have a 11g…

Hi, the issue is probably (98%) at this row: xhttp.open("POST", "saw.dll?IssueRawSQL", false); What the script does is that it use the "Issue SQL" page, which is available in the Administration, to run a query on the BI server and get the list of variables first and their values after. So your users need to be allowed to…

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)