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.

3689512 wrote:... but it fails when both values are less than 0. Can you define "fails" ? Do you have an error? Do you have a wrong result? What kind of result? (post an example or screenshot maybe?)

Hi, Your agent is set to execute "as recipient", right? Because otherwise the 60 users receive the content as retrieved by the single user you configured it to run. If you set the agent to run as recipient it will be executed as each one of the 60 users, and there security is supposed to be applied. You can look in the…

The first results from Google: https://gerardnico.com/dat/obiee/admin/12c/bar https://docs.oracle.com/middleware/1221/biee/BIESG/configrepos.htm

984465 wrote:I want to create two identical instances. I assume you mean from a content point of view and not the binaries etc. So you installed 2 separate instances, one is PROD and the other TEST, you have content in PROD and you want that content to be "cloned" to TEST? Did you look at the BAR file concept and important…

3063133 wrote:Can we achieve this requirement without time hierarchy?If yes, Kindly suggest me design approach. The "design approach" is to design a proper time hierarchy and let the tool do the job for which you paid the licensing price. If you don't want to invest 10 minutes into modelling a time dimension with the…

You can read about "content level" in the doc and if you google it you must find some blog posts as well. It's an extremely powerful feature of OBIEE which needs to be tested and understood. If you don't get the expected result the first time check again the settings and try again.