There isn't much that can be done as it's illegal to copy/paste content from MOS in a public forum ... But Google, like often, has answers for you: http://www.redstk.com/obiee-12c-multiple-instances/

CubeMaxRecords — Specifies the maximum number of records that are returned by an analysis for the view to process. This roughly governs the maximum number of cells that can be populated in a view; unpopulated cells in a sparse view do not count. The default is 40000.CubeMaxPopulatedCells — Specifies the maximum number of…

Yes, DV/VA uses JET, so that's a JET thing. The main difference is that Oracle took care of the integration and interactions (filtering, drills etc.) while by hand in JET it's going to be a bit more complex. But JET as a concept is clearly interesting, a bunch of JS libraries all packaged together and for free. I just find…

+1 Robert ! Initial stage on 11.1.1.7 in 2018 is not something you really want to do at all. If you really want to stay on 11g for your own reasons at least move to 11.1.1.9, but honestly it's the right time to move to 12c. Upgrading with little content is easier and faster than waiting to have a huge RPD.

Don't want to be annoying but ... make sure you have the right to use Visual Analyzer: if you come from 11g you don't get it included by default in your previous license but it's an extra thing to buy ...

The idea is to have the hierarchy as prompt, so you don't pass a member to the selection step but you pass directly all the selected items. And inside the prompt you play with the hierarchy to get what you need. (Let's be honest: HFR was really good in these things because that was its job, OBIEE is a generalist universal…

Hi, You can maybe also explore prompts on hierarchy, they allow to play with hierarchical relationship of members in a dimension. They work in a slightly different way than normal prompts as it isn't a filter in the analysis but you set in selection steps that the hierarchy is prompted.

I would say it's maybe the page you try to embed with start messing around ... "frame-ancestors" is a CSP setting just like "script-src", "frame-src" and "img-src", so trying setting it as well (set it as * to see if it changes something). In my test I just had to set frame-src to include a simple webpage, maybe APEX is a…

Dimitris Karydis wrote:(I suppose I had to use the quotes to make it a string??). To make it a string in the physical query. The value of a formula is sent as such to the DB, which allows you to query dynamic columns by storing their names in variables etc. So to not make your physical query invalid you need the quotes…

As Robert said, I guess the 2 values are just separated by a comma ',' when looking at the variable from a "text" point of view. Display the variable to validate the separator and then substring based on the position of the separator (or also the X characters from the right of the variable if your weeks IDs are always 7…

Just 2 details: You may want to consider updating your OBIEE to a supported version as supported for 12.2.1.0.0 ended a while ago (and it's also a first release, so with all the issues going with it). If you want to change a file in a style do not edit files like you did but create your own custom style (even just a 1-to-1…

3357027 wrote:Hi all thanks for your response and clarification,but I just wanted to know , can the text file be directly used to create the report and can it be refreshed ?where the file will be stored, can't we just replace the file in the filepath, and will it get refreshed.? You just had to read above, answers were…

So ... for 1) JS can do it, sure. But I join Christian in saying it's a bad idea. So it's easier to say "not possible" as it avoid people to destroy their instance. JS can do all you want with the OBIEE UI as it's a webpage. The issue is that it's not a simple nice static webpage, most of it is loaded asynchronously, with…

Do you really need to grant these things? OAC01_BIPLATFORM is the owner of the S_NQ_DB_ACCT table, so by default I would imagine it already has all the permissions on it... You need that grant if you use a different user.

The file being big (GBs) is an additional reason to load it into a database. OBIEE is not a database server, its performance when accessing data is definitely not as good as a database, which is developed for that reason while OBIEE has many other targets and accessing data files directly is just an extra feature they…

If you load the data in such a way you can't replace the file, if you need to use a new version of the file you need to upload it again (it will replace the existing one). Everything can be automated in a way or another, the question is more to know if you aren't looking at the wrong solution for your need ... Files based…

How is that different than ? It's against the rules of the forum to double post, and if it's urgent hire a consultant to do the job. You are paid by your client for that job, we aren't paid to post on the forum, we all do it in our free time instead of doing other things ... PS: you still didn't manage to spend 30 seconds…

As linked above the scheduler uses 4 tables where it stores things. Each job execution is logged there with a status. If you look at the table you easily figure out the columns and their meaning, or also search here around as some days ago somebody was asking about a monitoring dashboard for agents and he got a reply with…

So you have an analysis which you send to a user using an agent. And now you want to send an email to another user if the first agent didn't work fine? You have the logs tables of agents (https://docs.oracle.com/cd/E17904_01/bi.1111/e10541/schedconcepts.htm#BIESG1430) which allows you to know the status of the agent…

Hi, did you check the official doc (https://docs.oracle.com/middleware/1221/biee/BIESG/cluster.htm#BIESG9281 ) ? They cover all the steps required on both servers. As alternative just searching in Google get you https://www.peakindicators.com/blog/installing-an-oracle-bi-12c-cluster and OBIEE 12c - Horizontal Scaling - Red…