I can understand that GEN2 and GEN3 are common names for you, but they don't mean much for somebody not being in your environment. A full product name and a version would increase your chances for useful replies (always keeping in mind this is maybe not the right forum for your product/request).

Hi, If your issue is with BICC, this is probably covered by the CCC forum at https://community.oracle.com/customerconnect . Look for your app and the various categories in there.

Hi @Mayank6088 , You maybe could provide some more details about your question. Currently there is only a title but no content was provided (or got lost somewhere in the submission). What part of the product are you talking about? DV? "Classic"? Publisher? Waiting for more details, I can just say that a majority of people…

@Chandresh Patel , the "old" webservices (WSDL) also support a login with a token. It just isn't documented because the doc for the WSDL webservices is being reviewed and refreshed now for Oracle Analytics (Cloud and Server). @Mike Durran-Oracle mentioned that in a previous post here in the forum about the WSDL…

If you aren't using a TLS connection, the change in TLS connections will not affect you. The change is that they will "force" to use newer/recent versions and probably desupport old versions (TLS 1.0 and 1.1 I imagine). If you have connection using TLS, you should perform the test documented to check if they will be good…

Actually I believe you also have an error in the formula you used: EXTRACTYEAR returns a timestamp for January 1st for the year in which the input value occurs. That's not what you want, you want just the year, as a number (and not a timestamp), for your date: you should use the YEAR(<date>) function instead.

Hi, In your "Previous Year" calculation, what are you trying to get as value? Currently, if your formula would validate, your "Previous Year" calculation would only have a TRUE or FALSE value, because the calculation expression is a logical operation. Shouldn't your "Previous Year" calculation be just the…

While I didn't try recently, and definitely not in OAC, in older OBIEE the syntax VALUEOF(NQ_SESSION.USER) was used in the "Execute before query" of the connection pool. My guess would be: is it possible that your query is executed before the user is even connected? Is your connection pool really establishing a connection…

Thank you @Farivar Javanbakhti-Oracle for this spotlight, and thank you everybody else who commented above (and below, planning for the future :D ). Let's keep making this community alive and push the products being better known and give them some extra love, from both sides: users and Oracle.

Sounds like you have permissions issues if you can't see things where they are meant to be. Check in DV > Console > Content (or Content Management), there you should see the existance of the connection, and also see who is the owner. If there as well you have no control on it, ask the owner to set permission correctly to…

I can only agree with you … In "classic" the language (the XML) already accepted complex expressions 10 years ago, but the GUI never allowed to generate them. I imagine there are good chances the same applies to DV workbooks, but you also can't tell your users to edit the JSON of the workbook to write expressions manually…

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 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…