Hi, What kind of research you did about that? Because Google actually return some nice hints ... Let's turn things in a different way: how can you access Share Point data? Can you define it as a java data source? Can you define a ODBC connection to it? These 2 methods can be sources in the RPD. Apparently based on Google…

@EmmanuelMash pointed you in the right direction (there are also slides and videos of rmoff's Silver Bullet presentation on performance). I would just say to not limit yourself to log files, in your case I would also not underestimate the benefits to look at DMS metrics...

You aren't missing anything @Thomas Dodds I was a bit too much against the "original need" and forgot to think a bit wider... So the preferred drill path is the cleanest solution as long as the requirement isn't to drill somewhere else in the next analysis

As said I suspect your only way to link customer and product is using the fact table. So if you imagine a join between the customer table, the fact table and the product table you easily see how bad it is because of the number of lines returned. So you can do it, sure, it's just not the ideal way. What you did now is a way…

Hi, Why do you want that? The result will be the same product categories to be repeated again and again many many time for all your customers, doesn't really make sense. And the link between custom and product category is probably only your fact table with sales. These few things make it a kind no-sense hierarchy, that's…

In 12c I have that option right after importing a cube. That's how the screenshot was done: import, right click and there it is. If the dimension doesn't come with the correct type it's more a design issue of your cube. And of course it's obvious it require a dimension to be flagged as measures for the option to exist. As…

Hi, It didn't move, still same place.

Hi Todor, Actually I was thinking it was maybe you (you are the only Todor I ever met till now ). Actually I'm just thinking about "exotic" workarounds but can't really find anything obvious. I'm kind of sure there isn't a webservice call for that kind of translating prompted link to bookmark link. So the only thing I can…

The only "cache" you can have must be on your database side. That's what direct database request (the name is explicit), OBIEE doesn't do anything else than sending the query directly, so any cache must be done by the source directly. That's also why direct database request isn't supposed to be something used and abused in…

Hi, Direct Database Requests doesn't hit the cache as they bypass the BI Server logic and RPD to go directly to the physical source. So what are you trying to achieve? For generic cache seeding with agents the doc cover that: Managing Performance Tuning and Query Caching - 11g Release 1 (11.1.1)

If you got all you looked for based on your request you can maybe close the thread and mark if required? It would help others looking for the same, right now it's still This question is Not Answered.

3357027 wrote: so the connection pooling creation is exactly same as usual connection pool creation., and we need to use ODBC to connect ., Am I right? Connection pool creating is exactly the same? YES We need to use ODBC? NO, NEVER ! You never use ODBC to connect to an Oracle Database, you lose functionalities and…

Maybe this one can help you a bit more: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_QS/oracle_database_cloud_service_dbaas_q…

Hi, Your DBaaS is a Oracle database, so get the connection details from there (the online management interface), setup security to allow access from remote (ideally by setting your source IP address to avoid issues) and done. It's just a normal database, the "detail" is you don't use a local address but a public IP ...…

Hi, Google return this as one of the first results ... Exception in thread thread_name: java.lang.OutOfMemoryError: GC Overhead limit exceededCause: The detail message "GC overhead limit exceeded" indicates that the garbage collector is running all the time and Java program is making very slow progress. After a garbage…

What is the "middle of the report" for you? If you want the title as background of your chart you can't do it. If you want the title on the top, left, right, bottom of the chart just move it. And also you are talking about the title view of your analysis or the title field inside the chart view? (that's why I said that a…

Hi, In the center like ... the title in the middle of the chart? Or what "center of" are you referring to? (a picture is worth tons of words ....) And as we are here: what exact version of OBIEE is your question about?

Keep it simple ! Based on your previous posts the business model is unique and common between HR and FIN, so I also assume the model can ideally answer a report on address, employee ID and salary. So just 1 click! (ok... 2) Add the second subject area and make your report. Or, going back to my previous answer, in one of…

Hi, I would say that to convert a prompted link to a bookmark link you have to open the page with the prompted link and click on the icon to get the bookmark link and save the resulting URL. In a prompted link URL you have all the parameters in the URL, in the bookmarked link you have a "BookmarkState" attribute which,…

Actually that's a perfect answer ! Nobody asked you to be able to take a picture of that cat and then use photoshop to put the words on it, all they asked you is why you like it (you = the OP, not Christian) PS: if you go there with an OBIEE dashboard I would say 85% you don't get the job