Hi, If this is the "idea" you posted asking this feature, you should post it in a different category: Because ideas are a different kind of content, it's better to create one following what the GUI asks (there are some questions asked to provide all the required info). Right now I will close this one as it's either the…

Hi @Subhakara Netala-Oracle , Your screenshot shows "ORA-01489: result of string concatenation is too long". This is the database kindly telling you that your physical query (on the database) did try to generate a string that is too long for that database. Your is an Oracle database, and the default maximum size for a…

@User_PWOBY , You mixed up a number of languages… Are you sure the field where you are entering the query expects SQL? If it does expect LSQL, that's a different language, and it doesn't have all the SQL operators, because it is just a different language. At first you had a WITH clause, which can't be used because the…

Just a note: speak with your DBAs and let them define the best way to handle the password of technical accounts. If you aren't a DBA, you shouldn't create profiles potentially massively weakening the security of your database accounts. Each company has different rules on how to handle password for humans and technical…

Hi, There isn't a LOOKUP function (well, technically you could achieve something similar with FILTER(… USING …) if you really want something close to LOOKUP), but you don't need it. You have the time series function to easily get the measure one year ago, and then you can do any kind of calculation you need with it. Look…

I don't have a 5.9 available, but let's assume that the "Users and Roles" page was already working the same as it is working now (it probably was very similar). The list of users is a call to a web service (GET /bi-sac-config-mgr/api/v1/security/Users?limit=25&offset=0&_=1732311723832 in my screenshot below) If you look in…

Hi Steve, Are your users defined in the lightweight LDAP in WebLogic Admin Console? Did you try with something like this: https://support.oracle.com/epmos/faces/DocContentDisplay?id=942525.1 ? You can get all the users with a WLST script (it's python 2 with a number of functions available to interact with the WebLogic…

Hi @CarolineH , your question has been moved to the OTBI category posted by Arjun above, no need to repost it there :)

Hi, I don't know if there is a formal description somewhere. What that option does is a special flag to handle the case when the legend would contain a single item. When you have 2+ values in a legend, it does make sense to display it because it shows what is what (by color etc.). But in the case when your legend has a…

@User_86E2M , Not sure what you mean with your message (the thread is about where to set a parameter based on an error OP got). Because this is a old thread, you could ask a new question, describing your situation, your question, the current behavior, the expected behavior, and what you did so far to try to change it. And…

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 ) 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 or maybe the APEX category in that same forum (it's…

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…