In DV the links between sources are saved in the sources so the tool knows they existed once somewhere and next time you use it, it does reuse that link (never looked into the details, not something I cared about). If you edited the links in the sources of a workbook, even without saving the workbook, the links have been…

Hi, I would first check what query is executed to render that visualization. The CSV export historically (in "classic") has always been the export of the query result itself, without any rendering or formatting. If, for any reason, your visualization does query 5 columns, and the names matches those of the CSV, we can say…

Hi, Yes, it's possible. From the tags you added to your question I assume you are working in a DV workbook. There inside the condition for the formatting is "simple" (not a composed one like you need with RULE_1 AND RULE_2). The quick solution for that is to create a calculation. Something simple with a CASE WHEN <RULE_1>…

So, keeping it simple, you want to know if the February being in the last 12 months is a leap year or not? Because your calculation can only return 2 numbers: 365 most of the time, and 366 when it's a leap year. I believe the first thing is to decide if you want to calculate based on your incremental key or you want to…

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 : it's a parallel (but independent) forum from this one and that page is for the general Oracle Cloud Infrastructure page. I just don't know if they also cover payment questions. I believe…

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?

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

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