Hi, Users you create in the Weblogic embedded LDAP aren't supposed to be transferred by the BAR, so that's normal. Security is moved, it contains app roles and mappings between users/groups/app roles to app roles, but the users aren't really part of OBIEE. If you want to move users/groups from the Weblogic embedded LDAP…

I “smell” a poor selling tactic from a sales guy at Oracle... @3739384 : ask the person telling you that (I really don’t believe it’s in a document) a written confirmation. Will be useful next time you will need to buy some new license to have a great discount

984465 wrote:Well I had told this earlier that why cant I increase my Temp Size, but if you are not reading it I cant do anything in that regard. Really? I can read your thread 10 times there isn't a single mention on the fact you can't increase temp size. You are maybe mixing things on your side? (this is your only post…

Do you have a port number in your OBIEE url? A proxy is often used to redirect from standard http 80 or https 443 to the obiee port number, can also do SSL offloading by action as the ssl endpoint. As you have a loadbalanicer there are chances you don’t have a proxy in front of your obiee. You would need to ask your infra…

Hi Dan, I'm quite sure the file is rotated automatically like all other logs in OBIEE. Did you change something in your system to override the default log rotation settings?

984465 wrote:Hence the seriousness of the community should be know to the world. With all the respect ... What kind of answer did you expect? You didn't even named if you are using a tool (and which one) or you wrote your ETL in PL/SQL, java, python or any other language existing. You just said you wrote an ETL but you had…

aPsikus wrote:Can load balancer do the trick? In theory yes, practically depends on your load balancer ... The thing would be to remove the OBIEE servers from the pool of backend server to forward connections to, and instead add a webserver which will return the "maintenance page". There are other ways to manage that, but…

Christian Berg wrote:Do you have an Apache in front of OBI? Or any other proxy, Apache is just one of the many possible (Nginx is great!)

First that query is quite “bad” and my first impression is that your DB would refuse to run it ... Based on what I guess you try to do, simply model that join between the 2 tables and done. Can even be done inside a single LTS, simple, easy and clean. OBIEE is about modellling, the tool generate the queries, not you.

Hi Dilek, search here in the forum. There is a thread started more than a year ago which was fully about that and there has been some patches released. Apparently it has been fixed by one of those patches. Can’t remember the exact version it was about. @Joel Acha must defenitely have useful links (sorry to spam you Joel,…

Soheil Star wrote:PS : please don't refer me to oracle support link. Why? That's where many answers are often. For example for your case you probably found by yourself the link https://support.oracle.com/epmos/faces/DocContentDisplay?id=2394388.1

If you feel like having some fun you can also find some hints on "data lineage" in https://gianniceresa.com/2018/04/gdpr-analytics-solution/ It mainly point to a presentation which you find here: https://speakerdeck.com/gianniceresa/gdpr-and-you-the-nightmare-of-ba It has pieces of codes / methods to use etc.

Hi, If you look into SampleApp you find scripts and RPD / dashboards covering exactly that. There isn't in OBIEE itself a "single click" data lineage but you have all the elements to get the pieces you will need to connect together. On one side you need to get the presentation columns used by objects in your catalog and…

Once you get the RPD file it's really just a binary file with no dependencies or anything. You can open it with "many" Admin Tool (not "any": the Admin Tool need to be ideally same version or higher, a older version can't open a more recent version RPD). The DB connections inside are defined, but don't need to work to…

Hi, Why don't you just copy the RPD and use it as reference? Sure you can generate the RPD documentation and get a file with bunch of relationships inside, but what better than the actual RPD as reference? Or even better just start doing your changed directly into the copy of the RPD, so no need recreate everything.

That's the feeling with 80% of Essbase cubes But sometimes we are lucky enough to find cubes designed for analysis ... (ok, maybe it isn't really 20% but more like 2-5% )

In theory yes, ETL wins. In this case it's Essbase, so unique member name / alias rule apply and no ETL will help.

3512682 wrote:I am still seeing the same error. So you have an error in front of you, that's new ... Help the community in helping you

Hi, If you have the same exact formula both in the prompt and in the analysis the "is prompted" is still supposed to match. The best way to find out why you don't get any result from the analysis is in the logs: what query does the analysis execute? What value does it use as filter? On which column? Just check that and you…

aPsikus wrote:Yes in DB, EP_RATING is number. And what is it in your RPD? Check the physical column (wouldn't be the first time that a number become a varchar or something else )