Hi, You can open the BAR and look inside if you are curious, it is a zip file ... For example, if i want to open the Usage_Tracking.bar file and do necessary changes before deploying/merging into the current rpd. No, that's not how things are supposed to work ... If you open the Usage_Tracking.bar it is only to look what's…

I guess you don't need to do anything to "fix" the problem, users login again later or at a different time and access is back? What probably happen is that users don't get the right/full application role membership during login, that would explain the "intermittently" occurrence. So investigate on that direction, when you…

Hi @3310714 , Please do not go and apply any random patch posted by @Jasmine Pauline, what you saw is the expected behaviour and works like that since OBIEE exists (ok, at least 5-6 years for sure, seems to be more enough to not be a bug!). No luck you can't see the link (a nice company blocking slideshare.net where you…

As you just said 11g I took the latest 11g SampleApp, so 11.1.1.9.0 (Build 150415.1247 64-bit)

Managed to run my local SampleApp 506 (11g) : fragmented source in Publisher no problem at all. Same analysis in OBIEE gives the same results as Publisher using a Subject Area as source. The 4th column is the "fragmented column" while 2nd and 3rd go to one logical table the first and to the second logical table the second.…

Hi, First thing first: you aren't talking with Oracle Support but posting on a community and public forum, if you want to open a SR you must go to https://support.oracle.com/ What does the logs tell you? Any query in OBIEE has logs, so you must be able to find exactly what query Publisher is sending to OBIEE. Wanted to try…

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 ...…