Can definitely confirm you can freely configure CSP in your OAC instance to allow to embed images from an external host. The default on the config can be found here: https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG9326 And by SSH you have access to instanceconfig.xml in…

The images hosted on outside your OAC (google etc.) I would say they aren't visibile because of CSP, it's something which can be configured in OBIEE and therefore you can also configure in OAC I would say. The only thing to keep in mind is how upgrade will be performed: will your customized instanceconfig.xml be preserved…

So I hope you don't mind if we keep it here instead of into comments of a blog post. Will also be easier for others to contribute

You are counting the number of occurrences of ACT_CAND not being null, that's your measure. And because of duplicate you could it in a distinct way based on J_GROUP, PI_COMP_DT and CAN_NUM. Now look around your dataset and check if there isn't something which already had the right granularity, it's a COUNT, it could work…

What is your measure? What makes it unique? As you are looking for a COUNT it's often possible to use alternative columns which have the required granularity. If not exists it's up to you to create it: you can concatenate together multiple columns etc. You need to open up your mind thinking at alternatives giving the same…

If you model things as fact and dimension, all the attribute in the dimension will have an implicit distinct and be unique. For the fact you simply need to adjust the fact column to correspond to the combination of columns you need to do a COUNT(DISTINCT ) on. You set "count distinct" as aggregation and done. The column…

Sorry but how can you get a count of something by running a SELECT DISTINCT ? To count something you are supposed to have a COUNT() and GROUP BY or use the relative analytical function. Ignoring the incoherence of the "SQL" not sure what you are looking for: you want to know how to get OBIEE to make a SELECT on your view?…

Hi, Are you Adolfo? Any chance you could post in English? I don’t speak Spanish and I’m sure I’m not the only one The forum has English as common language so that we could all understand each other even if it isn’t our mother tongue. Is this relates to your previous thread where I saw Joel was replying?

3756623 wrote:...however we have run into difficulties with JavaScript because we lack the SAutils.js file that is being used. You reference a video about 11g (11.1.1.7) and you tagged your post with "obiee 12c". That's the answer to your question about SAutils.js .... The UI heavily change between 11.1.1.7 and 12c, many…

When you are about to install OBIEE, always start by checking the relative certification matrix (for 11.1.1.7: https://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls ) you find at https://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html . It's the best way to…

Ok, so 1 dashboard page with a single object: the prompt. This gives you the 2 scenarios if you set the "limits values by" or not. What version (exact version including bundle patch) is that ?

You mix things (lot of things) .... Your 2 screenshots come from different systems? different versions? (so you can't really compare the 2) The first one shows prompts and a message coming from prompts, the second shows prompts and an analysis and the error message come from the analysis. Right?

I would agree with Joel but usage tracking will only list analysis which have been executed, so any analysis which hasn't been executed will not be found. If you mean to find all the DDR (direct database requests) in the shared folder of the catalog you can use catalog manager, make a catalog report of all the analysis and…

964422 wrote:Error: "Server not initialized. Please make sure the repository is ready." Search this one in MOS, there are a bunch of documents talking about it (often related to 11g, but worth reading and trying to define if the cause and solution could match your case).

964422 wrote:"SECURITY_MODEL" value="ORACLE_AS_JPS" That's annoying, as that's the default value and also the one some MOS documents say to revert to if you can't login

Replying to myself, based on your other thread, I expect you have something like "BI_SERVER" there as value. You can try to stop OBIEE (everything, the full stack), edit that file and change the value back to "ORACLE_AS_JPS". Once done restart OBIEE (in your case you maybe want to restart the server as you seem to have an…

Worth noting that this is linked to OBIEE 12c error for analytics and BIP , a change of security model has been done in BIP but without the required config in OBIEE. @964422 : what is the value of the property "SECURITY_MODEL" inside the xmlp-server-config.xml file in…

964422 wrote:OKAfter server restart i'm able to login so i think there is no issue with login but something is wrong while stopping and starting services. Make sense, but no idea where to even start looking for this one. (because Windows ....)

964422 wrote:I'm using windows 2016 server Ok, no idea how Windows can interact with OBIEE. In the last years I always used it on linux because it's easier with less interactions and interference because of the OS. Windows installs seems to always have tons of issues which I never had on linux

964422 wrote:I have saved the response files . Can you tell me how to get the same environment back? The installers generally have some parameters like, for example, -silent -responseFile <pathToResponseFile> . By passing that to the installer it will uses the settings of the response file instead of asking you every and…