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

Hi, First thing first: manage subject area in "Manage Privileges" isn't security, it's like if you look at the moon, you put your thumb in front of it and suddenly say you found a way to hide the moon. It's a wrong impression of security, do not base any security on that one. Security is about data: can you access data…

I maybe missed a point (reading too quickly): isn't your prompt setting the value of the request variable you use in the WHERE condition? Because if you use the prompt to set a session/presentation variable which then set another variable in the analysis (with the SET VARIABLE syntax) and it's this new variable used in the…

Your request variable act as a sessions variable: it exists, it's there, it's set, so it as a value. For an analysis, for a prompt or for any other query you send to OBIEE in the same session. So yes it must work for a prompt as well. A prompt takes its values from the same exact RPD as everything else. So if your "WHERE…

Prompts have a kind of "stronger" cache, the query to populate a prompt once it's fired it keeps the results somewhere and avoid running the query again. You are probably hitting this case (the logs in your session clearly show if your prompts are firing a new query or not). If you confirm you are hitting this case,…