Hi, Did you check the certification matrix? You don't say which version of OBIA you have (I was betting on 7.9.6.4 as you have Informatica), so can't really check for you, but if you look at Oracle Fusion Middleware Supported System Configurations with your OBIA version you find all the details. If you look at the "Current…

Take all the previous answers, put them together and you get your solution What you ask can be done in few ways, some being better than others. If you can filter at the AD level (so pointing OBIEE to a subset of your AD only, a sub-branch or something, or add an extra condition based on membership of the users to a group…

No luck ... Also because it's a kind of really annoying issue as you can't really find out a pattern Would be nice if you can come back with an update once you heard something (I hope) from Oracle. In case you have time/resources you can maybe also try a 12.2.1.1.0 ? (as you are now on 12.2.1.2.0)

3410125 wrote:This will generate digits in that column. Nope, this will generate varchars in that column, so if the OP needs to sort over more than 10 elements the sorting will be '1', '10', '11', ..., '2', '3', etc. So the CASE WHEN was one of the options suggested at the beginning, but must be done correctly Also an…

Hi, Did you check the guide about embedding OBIEE in other apps? Integrating Oracle BI Presentation Services into Corporate Environments Using HTTP and JavaScript user9159846 wrote:Please tell me that need tweaking, as there is a bug. BI EE report is not displayed in the iframe.... What "bug"? What happen to your iframe?…

12c comes with jQuery loaded and heavily used out of the box. window.onload is a really really old way to try to make things, have a look at https://api.jquery.com/ready/ and use the jQuery event handler, it will always work (as long as the page is fine). It also depends on what your code try to change, because if you try…

What version is your OBIEE?

Sherry George is 100% right (and said the same days ago). The setting isn't at the section level but it's a 3 levels inheritance: dashboard, page and analysis in the page. Can be set at any one of the levels and underneath levels can override the settings coming from above (so dashboard > page > analysis). We were there 5…

Hi, OBIEE can sort ascending or descending, as you said (and saw). If you want a different sorting you must provide OBIEE with something it can use to sort on (ascending or descending again). So you need a sort column. If that custom sort order is the one you want all the time you can set that column in the RPD: If you…

Hi, Not sure to get what the rule behind your "max month" ... Do you want to get for each quarter the month which has the maximum value of measure (for example "for 2016 Q1 the max sales where in February") or do you want to get the "max" month available in your data? So if your fact table has some data for 14-Jan-2017,…

Yep, much more clear It's not really a common setup to have 2 domains (not that it can't be done, just that >95% of the setups are a single domain). So even more complex to estimate what the impact on memory usage is supposed to be ...

So you can now close the thread I guess ... For now it's still " This question is Not Answered. " and by closing it you will help others with the same / similar needs.

Do you need 2 OBIEE ? So 2 RPD and 2 catalogs running in parallel?

Yes, it looks like all the shortcuts in his "Start menu". As said the naming is set by hand as the installed will use standard names all the time for the shortcuts itself. So you rename them to make it more obvious and quicker.

The folder in the Start menu I can't remember if they end up in the same, I would say no (as far as I remember there is a different name). I personally then change these folders to give them a short and more explicit name with the version clearly visible (and also rename shortcuts to have versions in all the names so I can…

Hi, Just install them in 2 different folders 12c has a totally different structure and also names the ODBC driver differently than 11g, so no issues. 12c is even nice enough to make multiple installs (12.2.1.0.0, 12.2.1.1.0, 12.2.1.2.0) next to each other without overriding anything (while 11g was overriding the driver…

Moving to RHEL is a good move (lately all the people having a Windows server in front of them doing an 11g to 12c upgrade are really thinking to install a linux VM hidden somewhere ). Good thing you could test the LSQL directly : so Presentation service is out of the loop, the issue is between BI Server and the data…

I'm not officially on Christian's laptop (at least he isn't aware of that, so don't tell him ) but I bet on OEL most of the time. For example SampleApp use OEL6.x (can't remember the exact update, one of the latest). I had many VMs on OEL7 as well with 10Gb of RAM which works fine and never changed a single setting. Clean…

Sherry George pointed you to the most common reason when not seeing bug descriptions. You do not have to care about these things as you probably wasn't affected by that issue (as they are related to SR etc.).

The good thing is we never heard about that and also don't remember I saw somebody else asking for that on here. So it smells a lot like a one-time issue (so only on one server for ... no idea which reason). As you explored quite few options around RPD etc. I would leave that one as possible source of problems as secondary…