Are you asking if you need to know SQL to learn and use OAC? Or are you asking how to learn SQL as well? While you could use OAC without knowing SQL, I will say you will not fully understand how the tool work without knowing SQL. You will still be able to build things and display data, but you will not really be able to…

You can create free tier account and provision OAC there. https://www.oracle.com/in/cloud/free/ Keep in mind that OAC is not part of the free tier but it is available with the 30 days 300$ cloud credits. As soon as you reach 30 days or 300$ (the first one), your OAC will stop working or you have to pay for it yourself (and…

If you look at the posted example, the filterExpressions is a piece of XML that use the same XML syntax as filters in an analysis. If you don't want to write it by hand from scratch, build the filter in an analysis and then look at the XML and adapt it as needed. (Using the webservice is a kind of advanced task and that's…

@user9176407 Post a new question instead of commenting on a 7 years old thread. Also make sure to provide the minimum information for people not seeing your screen or knowing your environment: product name and version, and what means for you "command", "data manipulation", "XYZ" etc.

we have a password standard of 30 characters or less If that's really the standard, 16 being less than 30, it does still match with your standard. I didn't go reading details of where that limits come from, but you could try to test if it's just the RCU having that limit. Create the schemas with a short (<=16 characters),…

As Ezequiel said, the font used in more easily changed in a custom style instead of having to edit everything and force a font. You don't have to import the font, it should be available on the clients (and Calibri is everywhere on Windows clients, but still, you better define 2-3 fonts as it's common practice to make sure…

How are you calling the webservice? Did it ever work? What does your call exactly look like?

Hi, What's your product name and version? Are you on the latest bundle patch for your product? Any correlation identified between an action and the error in your log? Or any link found between something not working and the error in the log?

Hi @User_A1BVT , You better post a new question. This is a 5 years old thread and you don't really have the "same" question (because you have the opposite one). Just make sure to specify the product name and version in your question, so that answers will be adapted.

My understanding is that you look for an API to modify/create something in your Fusion app, and you aren't asking something about analytics/reporting with OAC or OAS. The "Oracle Business Intelligence" category is inside the "Oracle Analytics Cloud and Server" category, therefore meant for questions about analytics but not…

Did you have a look at the categories in https://community.oracle.com/customerconnect ? There is maybe one that matches your product (at least more than the Oracle Business Intelligence category where this is now)

Hi, What product (name and version) are you talking about?

One of the first random results when looking for OAC and PBCS: https://youtu.be/27c7Nf6yjeA

What exact product (name and version) are you asking about? Because of course there can be a lot missing in your security model, mainly on your new custom application roles, for the user to see the content. But only you know your security model and what you did, how you did create, the new application roles. Security…

The priority group of a LTS is used to define which LTS should be used when more than one can satisfy the query being performed. It's a numeric value used to "sort" your LTS, 0 being highest priority. It's a way to give you control of how the tool does generate a query, very useful in some special cases with complex models…

If you look the link you posted, it doesn't change the list of supported data sources. The Data Gateway is just a technical solution to make the connection easier handing networking complexity, it doesn't really make OAC able to handle more data sources than it can by itself. The limitation isn't that your OAC can't…

HFM, just like Planning, was available in OBIEE already in the RPD. It is still possible now in OAS, on-premises, as you can see here: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-supported-data-sources.html Your option is to either use OAS instead of OAC, or if you really want HFM…

A search for that error gave this result from the Oracle forum: Behind every LOB column the database creates a LOB data and a LOB index segment. You can't drop them separately, but you need to drop the LOB COLUMN: the two segments will be dropped automatically. You can't drop that index, because nobody created it (and it…

If you have access to the table, just drop the index you don't want... UT isn't meant to need any of these things, it only requires the table structure to be the expected one because it will insert data expecting that list of columns. But that's about it for UT. Please suggest how can we delete there indexes without…

What product are you talking about? You posted in the "Oracle Analytics Cloud and Server" category, these products comes with no content at all, therefore you must be asking for a different product.