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.

I must admit I first wrote "... and I will have to ping @Christian Berg to come sharing his advises on caching" right next to "use the BI cache for improved perf", but I thought to not leave you out of the loop for once Well ... didn't worked, you saw the thread

If you google for it you must find WLST scripts around for that kind of work (WLST = weblogic scripting tool). It allow you to automate what you can do in the GUI and a lot more. It also depends if you had embedded LDAP users mapped directly to app roles or users were part of groups which were then mapped to roles. If the…

Let me answer you with a question: when are your 500 users going to be on your obiee? And what are they going to do exactly? Because 500 concurrent users running heavy dashboard (containing many heavy analysis) is different than 500 users in total with a maximum of 5 concurrent users looking at dashboard consisting in a…

It's always better to work without cache as cache often bring more hidden issues than the advantages you can easily see. And never ever say out loud "I wanted to use the BI cache for improved perf" That's one of the best "worst practice" in OBIEE: people enabling cache hoping to solve poor performance without taking into…

What is the DB? Oracle? Is the system a fresh upgrade or something you are upgrading or it's there and running for ages? Are all the settings of the DB in the physical layer the best matching options with your real DB? Between different versions it's totally possible to have different behaviour in the way the queries are…

So what are you exactly asking? If you are going through the doc you find everything written there ...

If your query come from the same source (so using the same connection pool) it's generally pushed down to the DB because it's faster than having the BI server (so not presentation but BI server in case) doing the work (as BI server isn't a DB). So I find it a bit weird that you see both queries but not the final join in…

Hi, Christophe Servolin wrote:Problem : it seems that in some circonstances ( adding or removing some columns of the "Activité "."Articles" dimension ) the presentation server does not join the to physical queries correctly Are you sure it's the presentation server doing the final join? In a normal AGO analysis the join…

Hi, Did you check the official documentation? Blogs are nice, the doc is the doc ...

Didn't you forget to add some quotes in the query of the init block "usuario_perfil" ? Because it takes the username as a column while you probably wanted something like UPPER('weblogic') instead. But you don't really provide a lot to give other answers ...

Ah, you mean the embedded WLS LDAP groups, next to users. So your server crashed and you don't have the LDAP groups anymore? And the server crashed right before you first saw that starting take hours?

Hi, By "real OS" I supposed he meant a server OS (Windows or Linux) as client OS are supported only for development but OBIEE being an enterprise tool it's built to work on a server (and so using a server OS is the one matching better). As other pointed out: do not care about components up or down: the order in which…

What is the link between slow start of OBIEE and you "losing access to standard groups" ? Also, these aren't groups, Catalog groups doesn't exist anymore in 12c, so I imagine you talk about the application roles? The application roles aren't in console, so not finding them there is more than normal.