Sometime it’s just easier like that: you have 3 analyses? Oh well, why to bother creating a new one that would be a union (requiring to replicate the logic and make sure to keep it always aligned with the business logic of the analyses you have) when you can just create 3 agents. You can even chain the agents so that you…

If it's too complicated to build a new analysis with just the emails and handling the UNION requests, you can also just keep it simple: make 3 agents, each one using a different column to get the emails. It isn't the cleanest ever way, but definitely the easiest ;-)

The structure of the 3 queries in the UNION must be the same (that's typical SQL behavior: you can't union different shaped data). But you can perfectly have only 1 email in the first part, let's say 'X Email ID', then in the second you edit the formula of that column (you can even rename it to just be "Email ID") and…

Hi, You maybe forgot to write the main part of the question because right now there is just a title. You should describe a bit more what you are asking, where you are trying to do it (the product has various interfaces working differently one from the other), and what does "calculate total number days for last 12 months"…

Thanks for the extra info. So, you ended up in the "wrong" forum, this space covers only the Oracle Analytics products. You could try https://community.oracle.com/customerconnect/categories/oci-cloud-infrastructure-general : it's a parallel (but independent) forum from this one and that page is for the general Oracle Cloud…

Hi, Could you please be a bit more precise on what kind of account you did upgrade? Are you talking about Oracle Analytics Cloud? Or is this maybe more generic for an Oracle Cloud account? (wrong forum, you should consider contact support for your issue)

Knowing that you have SSO and a need to reauthenticate while browsing is a side effect of a not correct SSO implementation as said in the other thread… Did you make sure that your SSO is a supported solution for the product you are using? (working doesn't mean supported and certified to work)

Hi, Is this really different than your other thread? https://community.oracle.com/products/oracleanalytics/discussion/24067/oracle-analytics-mobile-app-connecting-with-fdi-using-intune-policy

Hi, Did you read the certification matrix for OBIEE 11.1.1.9 before to start installing? It is certified for RHEL / OL 5, because OBIEE 11.1.1.9 was released in 2015 (should work with 6 too, I believe support for 7 always came at some point, but never 8). Any reason for installing such a old OBIEE version? You should…

now It's giving me the same output everywhere. That's what I said above: you are mixing pre-aggregation and post-aggregation operations. You have a AVG in your formula: what else did you expect? The average of a single value is the value itself, AVG is an aggregation function, it is applied to all the records of your query…

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 https://community.oracle.com/products/oracleanalytics/discussion/24050/report-with-all-text-fields-double-quoted-and-double-quotes-escaped

@User_0ONK7 , Please do not double post, mostly when not adding much compared to the existing question. https://community.oracle.com/products/oracleanalytics/discussion/24036/how-can-i-extract-data-in-csv-format-with-all-string-text-fields-double-quoted-n-double-quotes-escap Will close the original thread as this one has…

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 https://community.oracle.com/customerconnect 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…