Im just trying to replicate the calculation logic And that's what you shouldn't do, because it's the best way to get a wrong result and a really poor OAS implementation (which has good chances to make users ask to go back to Tableau and trash OAS). Is it possible that some of your values are 0 or NULL? Maybe the error is…

Well, if the LOG function can't return results larger than 1.7976931348623158e+308, then your input to LOG can't be larger than EXP(1.7976931348623158e+308). But then again, you are translating some logic just replicating it? Or are you building things to match the requirements? Because you are mixing up pre and post…

SQL can do everything you want, but SQL is a database language and it can only help you if your dataset is based on a database directly (and at the dataset level). A workbook doesn't speak SQL but LSQL at best, and even there you can't write every kind of LSQL query, because it isn't a standalone query generally defined a…

Hi, What kind of connection are missing? What source are they for? How were these connections created? Who did create the connections (because you mention security)? Well … more details are needed.

Double post

@User_0ONK7 , Please do not double post, mostly when not adding much compared to the existing question. Will close the original thread as this one has the same replies for Publisher.

Hi @User_0ONK7 , You are using Fusion, ok. But in what part of Fusion are you working? What does the screen you are using looks like. This forum is for Oracle Analytics products. You are maybe not even in the right forum, but right now it's impossible to know. Keep in mind that what sounds obvious for you because you are…

Just as reference in case somebody else open this thread and it isn't directly obvious what I meant by "editing the JSON": right click an object in the semantic modeler > Open in SMML Editor. And from there it's just a simple JSON that can be quickly edited (faster then the GUI sometime).

Hi, You mean in the Semantic Modeler? (you mentioned a "physical" table) Not really … But you can import it again in a different part of your model, or even a new model, copy the code definition (the JSON), replace it in your current model. Or, because it's just a piece of JSON defining your table, you can generate the new…

As this request is more about something related to Fusion and BICC, you should also consider visiting the forum. It does cover Fusion in details with many categories, and also its data etc. (It's a parallel forum: same platform but totally independent from this one.) This is mostly about Publisher as a technical solution,…

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).