Hi, Filters work by evaluating a condition to a TRUE or FALSE value for each row. And only when TRUE the row will be kept. Because you have conditions that say when a row has to be excluded, you just need to take the opposite of those conditions. Therefore, if you want to exclude rows where M1 = M2, you can add a filter…

Hi @Tiang , You got your answers, just adding some "opinions" ;-) If the screenshot you posted is something you are installing now, you should reconsider your choice. 5.5.0 is the 2020 release, unsupported since 2022, but hopefully it's just an old screenshot of what you did install at that time… How about you install OAS…

Hi, As far as I know, nothing really changed for Essbase. It's a while I didn't see huge changes for that (maybe something will come in the future when Essbase will be supported by the Semantic Modeler, but even then I expect it more to support what already exists without changing things in the RPD itself). If you open…

Because of the nature of a DV workbook that include inside a single object all the pieces that before were split in multiple parts (dashboard, dashboard pages, analyses, prompts, filters etc.) I'm not sure something can be done. But log an idea and let product management think about it. In the meantime, if you need it as a…

Hi Tim, I did read randomly about those changes with the Microsoft SMTP, but didn't have to handle them myself so far… Some ideas while waiting a more official reply on what the roadmap has for that. I believe that even for Microsoft there is generally a way to configure things to use the SMTP without authentication, it is…

Hi @Amit Garg-Oracle , It depends … Do you mean save the values you set for filters when viewing the page and have a quick way to reapply the same values? Or do you mean to save a set of filters that you use in an analysis as a catalog object so that you can easily define the same set of filters in other analyses by…

Any chance to provide more details? Where, how, what? Screenshots? Product name and version used? What part of the product? How can it be reproduced?

Hi, Is there a question or you are just sharing your opinion? Or are you requested a new feature to have the option to not suppress values in a DV pivot? Because in OAC/OAS a "classic" pivot behave exactly like it did for the past 10+ years in OBIEE, you have the option to decide if you want to suppress values or not. If…

There isn't any special tool for load testing OAC, but there are many ways that it could be done. Because this is a 6 years old thread, ask a new question, providing more details than just OAC (what part of it, what is the target etc.).

As Mandeep said, this isn't the right forum, your question isn't about Oracle Analytics products. Fusion is covered in the Cloud Customer Connect forum (there are lot of categories, you should easily find one matching your needs).

If you need your 3 columns to be a single column to be used as recipients for your agent, just make a UNION analysis: you select the column A in the first request into a "recipient" column, then add a UNION and select column B for that same "recipient" column and you do it once more for your column C. The result is an…

Hi, You are almost there with the usage of SUBSTRING , all you need now is to use LOCATE to find the position of the bracket, and use that for your substring. Use LOCATE as the beginning of the substring, with a +1 to not get the bracket but just the numbers after.

Hi, If you are asking for Oracle Analytics Publisher Desktop Tools, no need to look any further, there isn't one for Mac. As you can see in the certification, it's a Windows-only thing: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-clients.html This was also covered in a MOS…

What exact product name and version are you using? What kind of installation is that? What are you executing/calling exactly? The WSDL is there, the service is defined, therefore it would help if you could be more precise in what you are working with, and how you are trying to use it.

Can there be an alternate solution leveraging the extensions and Python code to achieve this functionality? Well, one of the steps of a data flow in OAS is "Apply Custom Script", therefore you can do whatever you want inside a custom script. It isn't designed for that I would say, but it will be able to do the job as it…

Hi, If this is the "idea" you posted asking this feature, you should post it in a different category: https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server Because ideas are a different kind of content, it's better to create one following what the GUI asks (there are some…

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…