Well ... the process looks right on the paper, but if Weblogic complains something must be wrong. Sure it can be Weblogic itself (I kind of try to stay away from Windows installs as I like to avoid issues). For sure bicustom.ear with 12.2.1.3 works as I deployed one 2 days ago and logo and colors appears as expected based…

I don't see how you can get a wrong bicustom.ear as long as you do not destroy it but just replace what you want to replace. Take the provided sample file, open it and look inside, you find "bicustom.war" and a "META-INF" folder. All you have to do is to edit the "bicustom.war" with what you want and then pack everything…

Yes, red for complex joins, standard default thing. And not just the color: a complex join also doesn't have the arrow, which a normal join (physical foreign key) has.

If you are using SA607 and look at the deployment guide you will see this: 6.5 GB ramUsers with more physical host memory can allocate more memory to the virtual machine OBIEE is an enterprise tool, it's big and require resources. The DB same business, so with 3Gb RAM the DB doesn't even start (in a new install the DB can…

So your laptop/desktop is Windows 10, on it you have Virtualbox, till here all ok. In VirtualBox you deployed OBIEE SampleApp 607 ? What resources did you assign to the VM? (cpu, ram)

What and how did you installed? (what OS, products, versions etc.) As your DB doesn't start fine because of "ORA-00845: MEMORY_TARGET not supported on this system" then nothing else will works (as depend on the DB). So looks like a lack of resources .... (if you installed it's weird it didn't tell you that during install,…

Hi, And adding a filter on the measure? That's what a filter does in the end ...

Open the RPD and change the "year" physical column to INT instead of SMALLINT, so you get rid of the % default format. As inside the hierarchy you can't force it to something else that would solve your issue in theory (hoping you don't have a weird default format for INT). Plan B: duplicate the column in the RPD (the…

Interesting I must admit it's the first time I see a year as a %. Assuming you didn't do that yourself on the hierarchy (or you wouldn't be asking), do you maybe have a system wide default setting "Year" or any SMALLINT column as % ?

Double post: After changing to company logo..how to clear the image cache clear setting in OBIEE? It's the best way for not getting any answer, so close this thread and continue on the other one !

The "Year" of your time hierarchy is returned as a percentage? How did you get there? (do you maybe have a screenshot? Because I'm not sure to be able to imagine where the % is ...)

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…