As Nathan said, ORA-xxxxx errors are Oracle Database errors. On your side you should adapt your query if you want to avoid the error. Or take those ORA-xxxxx errors, your query and go speak with your DBA to see what can be done on the database side. The PGA limit can be defined at the database level (assuming you are…

Hi, Did you look at the generated queries? And while there also at the LSQL query? If the LSQL queries between your test and her test are exactly the same, then the physical query should give you answer on what is wrong. It is possible that there are extra filters added to the query based on the roles of users, and those…

By the way, the formulas are wrong… Or maybe somewhere in a virtual world the first day of current month is November 30.

@kalikhan , are you trying some GenAI service and randomly posting it? How about first reading the generate answer and see if it does make sense? If you really believe you need 4 calls to TIMESTAMPADD to get the first day of current month, you better think at it twice. Please don't post GenAI content: if people would like…

phone numbers for support need valid CSI？ No idea, I never called Oracle, but I imagine they will ask for a CSI (Customer Support Identifier: a contract for Oracle support). But again, you should ask in that other forum… This forum is for Oracle Analytics products, and I don't work for Oracle, therefore I can just tell you…

Hi, You can add many dashboard filters visualizations as you want, and those blocks will give you some control on the layout. Inside a single dashboard filter visualization you don't have lot of controls on where to display things, they are one after the other. As for your performance concern, everything is based on…

Sounds like you are on a "always free" account and not a paid cloud account. Then go to the other forum linked above, look for the best category (not "Feedback", that's for feedbacks about the forum) and post your concerns there. Also, I believe there is a chatbot available on the cloud page, no idea if it can link via…

Hi, It sounds like your post is about a cloud account, not Oracle Analytics. Therefore you are in the wrong forum. For your login issue, you should try to contact support (on https://support.oracle.com) or if you want to post in a forum, look for the best category in…

Hi, I have the impression you are in the wrong forum… Do you have an Oracle Analytics products somewhere? You mention APEX and Select AI, but both aren't Oracle Analytics. Is the question purely about Select AI ? I'm not sure what forum is in charge of Select AI, could be…

Starting with OBIEE 12c, the webservice is generally called via the /analytics-ws url, because of the security implementation of /analytics. It's just like with Catalog Manager, where you also need to use the /analytics-ws url instead of /analytics. It is related to the lightweight SSO implemented that can make things…

As said before, you should ask the question in the forum of Oracle University as it's them handling and certification part: https://education.oracle.com/ou-community Of course, if somebody in here took the certification recently in a different language they can give you their opinion, but for a formal answer I would still…

Hi, Certification questions have to be asked in the forum covering that topic: https://education.oracle.com/ou-community PS: the forum is in English only, for many of us it isn't our main language, but we aren't here to look after grammar or anything like that as long as we understand each other ;-)

Hi, Can you at least explain what is the meaning, the expected result? Because more than trying to convert 1:1 calculations, you should know what you want to achieve. The 2 products being different, there are chances that things can be done differently to get the best experience with OAC instead of replicating exactly an…

If you search about EM and processes showing as down in MOS you find some references. It isn't always an OAS specific topic but more a Fusion Middleware thing. For example (but not saying these apply to your case, also because each product has a bit of a different setup inside FMW EM, some being mostly managed servers,…

Yes, you can use a calculation where you enter your formula. The functions you will use are just 2: TIMESTAMPADD to add or substract days and months, and DAYOFMONTH to have the number of the day of the month. The logic is just what I said above. For a given date, you will subtract (1 - number of the day of the month for…

Hi, It looks like a quite old OBIEE? When there are errors with .cpp involved, it's always difficult to debug something, and your query also doesn't look good at all (nothing personal, but when a LSQL is a wall of text, there isn't much to debug…). Did you search for that .cpp in MOS? There is one document mentioning it,…

@User_S6RKR : Is that a piece of GenAI copy/paste? (Yes, it is) Looks like this is the second reply from GenAI. What is the target? OP could have asked ChatGPT himself if that was the expected result… Steve answered the question, I will just add a comment on one point: We are deploying a significant number of OAC…

The above answer sounds like a piece of GenAI output, don't blindly trust it… (or not at all, it isn't the best GenAI output you could get) Can you add inside the column with Product Category another grouping? This is what I am looking for. What do you mean by "another grouping"? Are you saying that you want to concatenate…

Hi, OAS isn't going to send SMS by itself. You will need to use an external service for that (can it be a webservice or sending an email or whatever the provider/service you select for the job requires). As Jacques said above, data actions if you are in DV, or action links if you are in "classic" will do the job. If your…

Hi, In what place of OAC are you trying to do that? Because the last day of a month is something "dynamic" (28, 29, 30 or 31), you can generally easily get it by combining a number of simple functions available in the tool (assuming "classic", DV workspace or RPD): subtract the day of month from a date, add 1 month,…