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…

Well ... good question Based on https://community.oracle.com/docs/DOC-891037#jive_content_id_1322_Helpful_and_Correct_ you are supposed to see a link/button below each reply in the thread. So if you go where you have the one from Sherry George which represent the correct answer you click on that button/link and so his…

Hi, You got the answer to your needs by @Sherry George above but as you seem a bit confused on what tool you are using I guess it's worth replacing pieces correctly in their context (as it will make things easier both for you asking things or others understanding what you ask). user630977 wrote:In OBIEE you can design…

justthefacts wrote:If I issue the logical SQL directly, I get the same results - in this case column s_4 is blank. If I add dimension X anywhere in the SQL, then s_3 is blank. If I move dimension X or s_3 around in the SELECT clause, still s_3 is blank. If I change out Dimension X for Dimension Y, now s_9 is blank. It is…

A long thread going in many directions so I missed a point but ... The issue is that an agent has a static list of defined recipients, and that agent is set to run as these recipients. The problem being that if one of these recipients is disabled in MSAD then the agent fail. Right? I maybe missed a thing but sounds…

So you have an upgrade 11g to 12c where the existing analysis randomly (so not all the time) have one of the columns being empty. For the same analysis once it works fine, once column A is empty, once column B is empty and so on, right? What's the status of cache? Do you have that also with newly created analysis? As you…

Hi, Didn't read fully the "doc" screenshot as it's just impossible to read (too small). But few points that can maybe help you: nowhere is written than OBIEE 12c require 3Gb for AdminServer and 3Gb for the managed server. What you posted is a generic rule for FMW, but OBIEE is a bit more than just FWM, it's actually a lot…

Of course you can ... by hand! Just making sure to remember to merge all of them before to deploy the RPD. You can perfectly automate these steps and so end up with "virtually" multiple RPD on your OBIEE server.