Farrukh Nasir wrote:Is there any way in which we can set different default values for the prompts on the dashboard for different user? Sure there is: session variables. Set your defaults in prompts based on session variables and set them to either last month or current month based on the user. Or duplicate the dashboard,…

As long as it isn't a floppy disk it will work. I'm not aware of hard drives recommandation because it doesn't really play a big role in OBIEE (OBIEE doesn't store/contains data). Only things written on your disk would be cache if enabled and temp files if you are asking your BI to do the job of a database.

Hi Eric, By default in 12.2.1.4 the login page isn't the OBIEE login page. It is the so-called "lightweight SSO", a "thing" giving you a kind of SSO which means you can go from the classic OBIEE Answers (/analytics) interface to the Data Visualization one without being prompted for a login. The issue is that this…

HKVOOSA-Oracle wrote:It is critical issue and not able to complete upgrade activity to meet timelines. Sorry but ... you know that's a public forum? Nobody here is paid to read and reply to threads, we are all investing our own private time into helping the community. If you have a "urgent" need for a reply either follow…

Hi, Raj453 wrote:Hi Gurus,we have an issue when trying to start/stop the OBIEE instance. Below is the message upon attempting to start. Please share inputs. Thanks.====================================================================================================================[oracle@****** bin]$ ./stop.shStopping…

I guess I remember in 11g there was a way to export and import the users/groups. Did you try to google it? It gives results faster than trying to search the oracle doc Not sure anymore if it was done by GUI or by WLST (probably both will give the same result).

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…