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 )

In addition of what Christian said, if by "DB" you mean the source of data, of course it isn't included. OBIEE doesn't store data, the databases to which it connects to run analysis aren't part of OBIEE and the tool has a "read-only" approach with those, therefor they will never be exported or included into any OBIEE…

So ... The doc says the same even for 11.1.1.9, but doesn't provide any example of how to write those 5 functions. Couldn't find a way to make it work. Found a reference of somebody else asking the same on Stack Overflow but had no answer. So .... no idea how it's supposed to work Maybe worth to ask in before to open an SR…

What version / tool are you using exactly? (the doc begin a BICS doc I'm trying to figure out what exact version and tool you are using )

3689512 wrote:Documentation says yes but havent managed to make it work Do you mind to post a link to this? Every place where OBIEE support functions has the "f(...)" button, the calculated item doesn't have it and just provides few buttons for basic operations, so I wouldn't expect functions to be supported there.