3808468 wrote:If I do first time installation which is the best option to select. First identify which version you want to install! 11g is getting old, maybe worth to think at 12c directly. Depends on your architecture. As Christian said Enterprise is maybe the best way to go except if you have a very special need that…

What you see is normal. Look at this picture: the first highlighted part is where OBIEE set the border you define with the options in the "Border" section. The second highlighted element is where a custom CSS will be applied. Between the 2 there is still a bit of things, that's why it's normal to see a difference in the…

The UI allows to upload a file, looking at the URL called in the background with the POST request (I believe it's a POST, didn't check) and the few fields passed with the file would allow to easily automate the process with cURL or something similar.

Something similar to "analyticsRes", but using a different deployment, could make it. "analyticsRes" is generally used by various things custom styles etc. which doesn't require any security. Nothing prevent you from deploying another folder in the same way you did with "analyticsRes" (so it will have a different path in…

Well, OBIEE isn't Toad and OBIEE isn't SQL Developer. So if you want to use a variable you need to use the OBIEE syntax for it. For a presentation variable you could use the standard syntax like @{variable} etc. It will depends on the kind of variable you want to use, the syntax could be different. There are many blog…

I don't believe the behaviour or OBIEE is really wrong... Your fact table join to these 2 tables as 2 totally separate things, and you want to merge them into one. From a logical point of view, you will need to trick the system a bit more to make it think they could be the same thing. Obviously you agree that it's…

I don't have a webservice giving me a WSDL with a method with multiple parameters handy, so can't test. If the GUI issues you have are when building your analysis and defining the action, you can definitely have a look at the XML and "fix" things there setting the various things.

MarcoB wrote:Then I tryied calling this url with wget/curl via shell script but it looks it doesn't work. What does "it doesn't work" mean? Because technically ... it works (or it would be impossible to run agents from the tool itself.

It's defined by the webmessage with name kmsgHeaderBIBrandName. There are various things posted online, including Oracle whitepapers on the topic. 11g or 12c is the same thing for that. Covered in OBIEE 12c - How to change portal header brand name (next to Oracle Logo) as well

The site has some issues right now :s I had to refresh 10 times having all different errors to see them again (so it isn't my fault ). A way more generic (without code and technical details) can be found at https://gianniceresa.com/2018/03/gdpr-analytics-challenge/ and…

Hi, if you look into Sample App (https://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html ) you will find scripts and RPD + dashboards doing these things. The scripts will maybe not work out of the box for 12.2.1.4 (because they are from an older version, main change is the lightweight SSO…

What version? (exact version) If a 12c: do you have the lightweight enabled? You maybe don't know but there are 2 login pages in some OBIEE versions, and things works in a very different way for the 2. So you need to give more info on what page you are dealing with.

My bad, skipped the fact you asked about HFM and I was talking about Planning ... (no idea why I switch to the other one). Did you try looking on MOS? I believe there have been bunch of documents there too covering how to import HFM metadata into various versions of OBIEE.

Does it really return you NULL? NULL is different than no result, different than '' or anything along that line. The RPD maybe doesn't give you any warning/error with the consistency check, but it probably means your model had some "shortcuts" which worked in 11g and have a different behaviour in your 12c. So, as Joel…

Last time I did that it was 2015 and 11.1.1.9 was freshly GA (the very first version supporting Planning out of the box). The thing is that I don't remember having installed anything on the OBIEE side, everything is there already. I just had to tell my Admintool where was the BI Server as the client can't import Planning,…

What exact version (including bundle patch) ?

Don't you have an alias after the renaming? If you have an alias it must work as usual and would be worth some further investigation ...

Different business date (from order to payment) = different point of view. You either create another time dimension proper to payment date or you create different measures proper to payment date. OBIEE is about modelling things, so you need to represent all those things as models being star schemas.

Is your question related to the front-end or the RPD? If the front-end you will need to fix your model as you missed a join, if it's in the RPD your date dimension would ideally need a day column to make a 1-1 join. If you can't have the day grain in your date dimension just write the join with a BETWEEN:…

So going back to what I first posted on this being a community forum: post some hints of what you did and how you fixed it (you can use generic names if you have a privacy concern). Because it isn't the first time this question is asked and will not be the last one, so will be helpful for others to have your first-hand…