Hi, Welcome to the Oracle Analytics community and forum. First, let me say that OAS 5.9 is quite old (2021), and not supported anymore. You should consider upgrading to the latest OAS 2025 (aka 8.2) just released some weeks ago. There isn't a native connection for Databricks, but you can use the JDBC or ODBC. You should…

If EM works for what you need (you shouldn't be spending much time in there anyway), I wouldn't bother much… If you really want to try to get rid of that, you could try giving more memory to java. MOS should have some documents on how to do that for WebLogic or FMW (/em is not "inside" OAS itself, it'a FMW thing). It's…

Hi Brett, welcome to the Oracle Analytics community and forum. The answer is yes and no … There is a public available instance used to display what OAC does, but I believe it's fully read-only (in the "Resources > Live Gallery" menu here). As you are a consultant, if your company is a partner, then somebody has the details…

Hi, EM is slow as crazy, there is a simple config you can do to make the login a lot faster (it's about the discovery cache that you saw in the message). You can find the details on how to do those changes in https://support.oracle.com/epmos/faces/DocContentDisplay?id=1423893.1 . You have various ways to do the same thing,…

I didn't fully read, therefore I'm maybe totally out of scope… The Oracle Database error you get is generally raised when your actual value is larger than the definition. If you defined a VARCHAR2(4000) but have a value that is more than 4000, you will get that error. I imagine 2 possible solutions: make your value small,…

You should open the catalog in "offline" mode. In OBIEE 11g the catalog is still on disk, and allows offline access (via the catalog manager): in offline mode, the security isn't enforced and you will have full access to everything, including private folders.

Hi @C. Joseph , You should consider posting a new question, providing all the required details (product name, version etc.). This original question is now 8 years old and has been migrated across 3 forums over time, that's where pictures disappeared…

Where do your users come from? Are you using the WebLogic embedded lightweight LDAP for users or you are using an Active Directory or company LDAP? There are webservices to get application roles and members, you can also use WLST to get a list of members of an application role, you can also query the OPSS schema in the…

https://youtu.be/nuvaXmBxu8g?si=UlJxXaioraiCUNuf has a piece about the GIT integration (how to push the model to git) and the git panel. similar topic. https://youtu.be/MrV_5PK9Rrw?si=S-CRDbCZpxtE_Sdb is the generic intro to the Semantic Modeler (not git oriented). https://youtu.be/rLrElzs985k?si=KRDxnHYOniwkP2GQ another…

Hi, The real answers would depend on what feature you use in the Model Admin tool when developing your RPD. Keeping it short: the Semantic Modeler is going to be the future and, at some point, the Model Admin tool will disappear. If you use the various tools in the Model Admin tool, you will not find those in the Semantic…

Hi @deepmehta1-Oracle , Your question isn't really related to the topic of this thread, is it? The question here is about the Excel limit of 65k rows, while you look for "best practices" on a more generic report, not really impacted by the 65k rows limit. If your question isn't about the 65k rows limit topic, post a new…

Great to hear! One thing you can "fix" now that you are done installing: You can either follow the resolution posted there or just install jqin your environment, one of the two and the logs in Manage Sessions will be visible.

At the other side in weblogic console username hasn't been changed! No command will rename the account in WebLogic if that's where you defined it. You have to do the renaming there, and I believe there isn't such a thing as renaming in WebLogic, and renaming is done by creating a new user with the right username and…

Hi, Welcome to the Oracle Analytics community and forum. I can't really help you much with OAD because I didn't use it for the past 4+ years, so that part will need to wait for somebody else having more hands-on experience with recent releases of it. All I remember is that the front-end give you a generic error, while in…

Thanks Steve for the link, my MOS search skills weren't working when I tried to find that info. @User_JJ05H , yes, you need all of those. Some aren't patches like the JDK, but the rest is required. They aren't OAS patches, they are all the patches applicable to WebLogic and FMW 12.2.1.4, you can install all those before to…

Or, as an alternative "solution", just install jq(despite not being listed as a requirement in the doc). After installing jq, without any restart, the logs can be viewed in Adminstration > Manage Sessions. At least on linux systems jqis usually available as a package for all distributions. Mostly if full-text logs aren't…

The logo mentioned by Wayne above is the one you see when opening a workbook in the "Present" mode, and it's a "per workbook" setting. For example I added a logo to one workbook and when opening it in the Present mode, I see the logo next the title of the workbook (and the product header isn't visible at all, because it's…

Not answering the original question, but to confirm what Steve said: it does install fine on OL9 (I did a number of silent installs as I was creating a docker image). There is a required package that was "challenging" to find for OL9, and I believe it's the same for RHEL9, because it has been removed, I had to take it from…

Hi, Welcome to the Oracle Analytics community and forum. I would disagree with "it is not recommended to set it to 0" , this sounds a bit like the theories that for many years kept saying that logging and usage tracking had to be disabled to improve performances. You are the only one able to know what kind of needs you…

Hi, Technically having the BI Service Administrator application role doesn't automatically grant access to the catalog. I have worked on environments where weblogic was the system admin, but had no access to any content. I assume this isn't the expected behaviour, or you wouldn't be posting the question. Can you check in…