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.

3371002 wrote:I have granted the Access to Export privilege to the User and they still do not see the Export link. As @Sherry George said: did you enabled the link in the dashboard properties, page properties or analysis properties? It's a 3 level inheritance: analysis inherit from page, page inherit from dashboard and you…

3371002 wrote:I assigned the privilege to the user from Administration>Manage Privileges>Dashboards>Export Entire Dashboard to Excel and Export Single Dashboard Page to Excel, but they still do not see the Export button. These privileges are the 2 you can access on every page using the top-right "page options" icon. It's a…

The CASE WHEN isn't right ... When calling a variable the @{variable name} is the value if the variable, the following {default value} is the value in case the variable isn't set. So the variable isn't null (because checking nulls doesn't always work... CASE WHEN '@{Nomenclature}{##XX##Impossible-Value##XX##}' not like…

If you expand the prompt properties in the bottom you see the option to save the value in a variable. A condition can simply be a CASE WHEN (if you check in the formula editor of your analysis you have the CASE WHEN example, you reference the variable by '@{variable}{default value}' . Now I'm not going to say that asking…

Edit your prompt to save the value in a presentation variable and use that variable as conditions to see if something has been selected or not. So you can display a custom message or nothing when there isn't a value selected.

The question is "où" ? where do you want to see the description? In the prompt? Or do you want based on the selection of 010121000 in the prompt to see the description of that value in the title?