Catalog Manager in offline mode isn't needed for a whole catalog search&replace. One of the things making it a bit weird is possible encoding or special characters. And of course Catalog Manager doesn't help you because it shows you something but it isn't really exactly what the catalog contains (because Catalog Manager…

Do as Ebin said and do not copy/paste content from MOS in the public forum. It's forbidden and a very strict rule as you have to pay to access MOS and so copy/paste giving it out for free is not really acceptable. So edit your reply, just say if it fixed your issue (I'm sure it did) and then mark Ebin's as correct which…

As Christian said, you can do it on OS as long as you keep the permissions and ownership of the files/folders (just to avoid issues). If you do it on the folder above "root" the good thing is that you will also have root.atr because without your catalog is kind of useless (like any other .atr all around the catalog). For…

Mike Wentz wrote:How they could be a leading service provider for outsourcing payroll completely eludes me. Let say that once again is the miracles of marketing and a good sales guy versus a not too challenging buyer Try to push a bit on them telling them it's unacceptable and ask them to sign a SLA with a 99.999%…

Hi, Of course you can take the prod one and bring it back in other environments as long as the content of DEV and UAT not being in prod is not too much (so it's easy to backup first and reload after bringing back the catalog from PROD). Otherwise the solution is quite simple once you understand how things are referenced…

As Christian said: 12.2.1.3 is not unstable, it's quite good when used correctly. If you get HTTP 500 when editing analysis etc. it definitely smell like configuration and implementation issues, crashing components again etc. Of course if they did a jump from 11.1.1.7 to 12.2.1.3 (there are 5 years in between) without…

The SMTP server is saved into user_projects/domains/bifoundation_domain/config/fmwconfig/biee-domain.xml , but there you will only find the server address and params, the username/password is probably stored in a secured wallet or something like that. The SMTP username/password is not supposed to be mandatory (based on the…

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…