Are you 100% sure it isn't permissions related? So if you create a test users with exactly the same security assignments as one of the users with the issue you don't have any problem? Keep in mind security is all about inheritance most of the time, inheritance which can happen at various levels, like being denied somewhere…

There some online tutorial on Oracle for that. Otherwise you have to write it or buy it (like you can buy training as well).

Mukeshs wrote:management is looking for some other analytic product and wants to analyze current system performance. That's the thing ... "system performance" doesn't really mean anything. It's all about what you do with your system and how you use it. But you will hardly compare tools by "performance", it's about BI, so…

Hi, 100 - the number of emails of complaints you get from users saying the analysis are slow per week = the performance in %. More in general what's the link between "performance of a datawarehouse" and OBIEE (the place where you posted the question) ? Can you define what performance of a datawarehouse? I bet you can't ...…

No best practice for this. It really has a very little impact ... RCU is mainly used to store usage tracking if you enable it and agents schedules and logs. So there is no reason to try to look for something special for it. Manage it using the same process you have when needing a new schema for something, follow existing…

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…