As you managed to connect the the RPD in "online" mode (as you fixed problem 3), did you find which user the RPD is using to connect to the database? Simply ask your DBA to unlock that user and, if password changed or you are unsure also change it. Or your only issue now is that you can't connect to your database with the…

Hi, Conferences on OBIEE itself not really, but most Oracle related conferences have chances to have sessions about Business Analytics (OBIEE, DVD, OAC etc.). For trainings depends : you can for sure check on the Oracle University side to see what they have in stock, or there are consulting companies organising trainings…

3057520 wrote:so I created a synonym for a table to validate if it works and it does. BUT I think that it is not the best solution. Do I have to create synosyms for every table when I use another user who is not owner of table?? Why did you create a synonym? It's useless, when checking the "fully qualified name" checkbox…

I never talked about privileges, but fully qualified name which is: schema.tablename vs tablename (without the schema). An option in the connection pool which by default isn't checked (it's a checkbox) and you must enable to make it works. That's a simple SQL thing: you can't expect the database scans all the schemas you…

The table giving you the error is owned by the user you used to connect? (so into the schema use used in your connection pool) If not you must check the checkbox to use fully qualified names if it isn't checked in the connection pool.

Hi, There are some variables giving you the hostname and few other things, but as far as I remember not the full link with http:// in front and the port number and /analytics... So what's your use case? (just an example of what you expect to use the variable for, in which place as ...)

As Ebin said, and as the certification matrix clearly states too: RCU schemas (BIPLATFORM and the other 6-7) are supported only on Oracle Database, SQL Server or DB2 (check the matrix or Ebin answer for details on versions). MySQL isn't supported for the RCU schemas. Then of course as you said you can use many other…

Just keep in mind a detail: this will not prevent your users to tell you "I never got it", because you can't know if the SMTP server had an issue, but of course you can at least show that in theory you did everything right and the problem is somewhere else

Hi, You got the answer from the 2 replies above, both pointing you to the certification matrix and listing you the possible supported DB. Just a detail: Sree!!! wrote:... first we needs to install the oracle db then on top of we will install the obiee... It's not really "on top", in general the DB is in another server…

OBIEE 11g is different than 12c ... Does your weblogic user have the right permissions? Is it member of the required application roles? Do you have application roles for OBIEE? What's the history of the system? Fresh install, upgrade, something else? sai kiran t wrote:but this is not the error we see in bi_server1.log…

I suspected somebody did it with Weblogic I would first point out licensing: if you have OBIEE licenses you aren't allowed to use the full Weblogic for other things if you do not own a Weblogic license. There are limitation in that direction which is better to find out first. OHS is a "kind of" Apache HTTP Server (at least…

Hi, You generally set a variable (repository variable refreshing every few hours or even just once per day, depending on the different timezones you must cover). The query sourcing the variable will use your own time dimension to get the value of the fiscal week column based on the current date. Or just using the same…

@3257772 : did you give up on this?

As Christian said, OHS isn't part of OBIEE 12c. It's a different product which you have to install separately if you need it. 819624 wrote:...so should I conclude that I can't find httpd.conf file? If you didn't install OHS that's a right conclusion. The question is more why are you looking to tune something in a webserver…

SampleApp has examples for that (you can also just refresh analysis in a page and things like that). The above JS will not always work as the URL isn't always valid: OBIEE does a lot based on it's own session, so if you want to be sure to reload the right page you better first get the URL to use from "Create bookmark link"…

For your second point I still have that in 12c (12.2.1.2.0) : I do not remember a setting for that honestly. Wasn't it because you were sending dashboards / dashboards pages instead of an analysis?

As far as I know Weblogic doesn't provide that. It's an application server, a good one, but not really a proxy or a load balancer. So it's something you definitely need to manage outside.

Hi Chris, To be allowed to send the entire dashboard (or a dashboard page) via email with an agent you must first be allowed to export the entire dashboard / dashboard page. Check in the Administration > Manage Privileges page to see if you have the permission for that (or actually it's more the user the agent use who…

That's what a load balancer is used for. It isn't OBIEE business to do that job, you wanted 2 nodes so it's you that must provide requests to the 2 nodes and that's done by a load balancer. As alternative a proxy can also (often at least) manage that case, for example nginx can easily proxy queries to both nodes.

I guess it's a standard thing with EBS sources that you need to set a context first. Can't remember the details, something about the security and/or profile of the user requesting the data. That thing must be managed in OBIEE as well. Read this: Calling Oracle Stored Procedure from OBIEE 11g PS: if you post all the details…