As long as you executed the same exact query using the same exact account against the same exact database you must remember you also have the local settings playing a role in how a query is executed. If with all the above mentioned elements being the same your Toad gives you a different result than OBIEE (and you are 200%…

Well, I can't say what the licensing contract clearly state as those papers sounds like Chinese and it's more a topic for your legal department. From a practical point of view it's generally not a good practice to expose this kind solution to the external world directly. I would say it's not the main job of OBIEE to…

What would be the difference for you between installing OBIEE in a DMZ, in your normal internal corporate network or on a server without network? Nothing really change for OBIEE : as long as the server has a name / ip and it can reference itself OBIEE is happy. A DMZ is more about you and how you manage the various access…

@Avinash Pentyala : you better delete the copy/paste from the MOS document. Just leave the link and nothing else ...

I assume that piece of code is the custom code format of the column or something like that as you have the "@H" reference inside which is generally used to represent the URL being the value of the column. You can do what you look for, but you will need to move all that code inside the formula of the column, so you will be…

Moving from 11.1.1.5 to 12c isn't really supported (you would have to first move to 11.1.1.9 or 11.1.1.7 first in theory). And it looks like the issue is more related to your own customization. Identify exactly what is generating the issue, if it is your own custom code (JS etc.) then it's up to you to fix it and make it…

'FY' || CAST((CAST(SUBSTRING(CAST(2017 as CHAR) FROM 3 FOR 2) as INT)+1) AS CHAR) This thing also result FY18 but doesn't depends on a database knowing what "TO_NUMBER" and "TO_CHAR" means and will work on any source.

Hi, Why to use EVALUATE and making your analysis DB dependant when the default OBIEE functions could do the same job?

Well .... he asked for users, roles and privileges. Then post back for users and groups and nothing more. I'm just asking if that is like "hey, I got this piece done, it already cover part of my need and now I still would like to add X, Y, Z" or it is more like "the audit guys have no idea of what OBIEE is, so by giving…

Yes ... and ? So you don't have a question anymore? Then close the thread. Are you still looking for what you asked? Then is you answer questions it will be possible to move forward.

Hi, Where the CSS class "DashboardPageContentOuterDiv" is defined isn't going to help you. Even if the class doesn't exist at all you will just not see the style defined but that class. Your error is a javascript error coming before that: there isn't an element with the ID defined in the function. What version did you…

I assume you mean 11.1.1.9, which bundle patch?

What version of OBIEE are you talking about? Because some have issues when more than 1 master-detail ...

You found the doc posted 5h ago, as it's the official one... Can you please close the thread? For now it's still This question is Not Answered. And for the EAR vs /analyticsRes I would say it's as simple as EAR to deploy /analyticsRes in the various environment, mainly if you (and I hope you do) version the content in GIT…

Hi Adrian, What you look for is the command "deploy". Super simple to use: 1) you connect 2) you call deploy giving it the name of the app, the path of the EAR and the target (server or cluster) (for example: deploy(appName='bicustom',path='path_to_your_file/bicustom.ear',targets='bi_cluster') ) 3) disconnect Done !…

1579154 wrote:exports all users of Analytics , roles and privileges Can you define "roles and privileges" ? I guess by roles you mean application roles, but privileges there are many different kind of privileges in different places ... Everything is possible, there just isn't a big "export me" button for that PS: obviously…

Didn't you say you know Google? The first link returned by Christian's link is : http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/obiee_maps/obiee_maps.html Older version but give you a good idea how you tell your mapviewer where is the DB with the spatial data is. Still Google return things like…

1579154 wrote:i want to find a démo !!! A demo? SA607: OBIEE Samples Download, run and there you have your live demo with samples etc.

Not only the wrong place (how can this be linked to OBIEE?) but more in general the wrong site ... If you want to know how to install Pentaho you need to ask them. The Oracle VM is running linux, but it isn't Oracle supposed to tell you how to install a 3rd party tool. It's like asking Microsoft how to install Tableau on…

So as said, you where missing part of the proxy config ... And it has nothing to do with SSO, OHS is a webserver, a kind of Apache HTTP Server with an Oracle stamp on it. And it is acting as proxy in front of weblogic.