Welcome to the Oracle Analytics Community

Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Gianni Ceresa Mod

Comments

  • +1 Christian For the "where" I guess it's written somewhere in the post: where you want as long as it's accessible by the server (so on the server filesystem). When you deploy the folder you will navigate the folder filesystem (where the user runnning OBIEE has access) and you can pick any folder from there. I would…
  • Hi, You post links which doesn't work (not the first one) : is the link pointing to something inside a SR you opened with Oracle? Because this isn't Oracle Support, so posting links to SR documents will not help at all. If you opened a SR you must follow the SR with Oracle on the support site ideally ... (as you are doing…
  • You will never find an excel file with that filename on your disk (or better: on the server disk). https://www.rittmanmead.com/blog/2016/06/obiee-12c-extended-subject-areas-xsa-data-set-service/ Robin again covered it in detail, your file is loaded and processed, so it changes name etc. as it will be part of the Data Set…
  • Hi Mark, Right now you can't do that the way you expect it ... As Christian said (and with a screenshot) XLS sources in Visual Analyzer (VA) are also accessible in Answers. But that's it ... Other sources, created dataset by mixing a subject area and an Excel etc., will not be visible on the Answers side. So it's partially…
  • Welcome to this community forum ! User551626-OC wrote:Figured it out. The idea of a community forum is that you can ask things but you also share information. So just saying "Figured it out" how is it going to help somebody with the same question in few days, weeks or months? So could you please post the details of what…
  • Hi, I would say it's better to first make a quick analysis of the situation instead of just increate the number of concurrent connections as at some point this approach will start impacting something else (your DB or something else). So have a look at what that connection pool does, if it's the unique and single one etc.…
  • 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…