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.

Great that you solved and posted back the solution Ideally can you mark it as correct answer as well? So it will also close the thread and really help other users with the same issue, for now it still says This question is Not Answered.

This document goes back to the /dev/random vs /dev/urandom thing for Weblogic. As it's something quite simple to test, @Khalid Ibrahim, you can always give it a try...

So you really want to push OBIEE do things it doesn't like to do Didn't test in details but PDF printing generally understand text, basic html and probably images (real images). But it can't generate the image based on JS code for you as that's what the browser would do. So if you manage to generate a real static image you…

Which one of the few print options you mean? Because exports and PDF printing will not make it as it's done by OBIEE, but HTML print must be fine as it's your browser managing it and your browser understand how to render the JS code.

Oh no ... I would be tempted to suggest to cancel and rebook with another guy ... I know one who can do it (and I actually also already delivered OBIEE training in French, was a weird feeling )

So as said: no real changes. Actually nothing changed on conditional formatting between 11g and 12c in Answers. Actually if you define using the UI the rules it isn't a OR, and it isn't a AND. OBIEE will evaluate all the rules and apply all of them if they are valid in the order. So if a rule set a background color and a…

Where is time spent? If you follow in logs the startup what is done for how long? One element know to help is the /dev/random vs. /dev/urandom for java which can help weblogic, but first would be better if you analyse where the time is spent.