The second parameter of the function isn't a column name but the name of the hierarchical level: is your hierarchical level named "Core"."Date"."Fiscal Year" ? This one looks more like your fiscal year column, not the hierarchy level.

If your measure is a varchar, it depends what the aggregation is. If you use COUNT on it, no need to cast anything, if you use SUM, you have to cast the definition of the column itself in the RPD because the SUM has otherwise no way to work. All in all, you aren't supposed to cast the measure because TODATE only change the…

Compatible? Maybe, could probably work. Certified? No https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-systems.html It's a difference in wording which can mean a lot: if it's a sandbox you can live without a certified system, if it's production you would be really brave. Mainly because…

You don't have to cast the fiscal year at all, and the second parameter for TODATE isn't a column but the hierarchy level of your time hierarchy (and that's why you can tell OAS/OBIEE to work on the fiscal calendar or normal calendar when they are modeled as alternative hierarchy, because the level will tell the system…

Can't you use the time series calculations? TODATE should be able to sum all the required periods correctly. If you did model your fiscal calendar as alternative hierarchy in your time dimension, it will works just fine.

Technically "MONTHS_BETWEEN" works, but this exact function isn't exposed in OBIEE. If you don't want to use evaluate to push down to the database FLOOR(MONTHS_BETWEEN(...)), you have to adapt the logic by knowing how OBIEE translate TIMESTAMPDIFF. As said earlier, TIMESTAMPDIFF is MONTHS_BETWEEN, but it has a ROUND()…

As the example above shows, with customer create date = 11-March-2021 and current date = 09-June-2021, the result of MONTHS_BETWEEN would be 2.9554... So what's the logic for you to say that 2.9554 should be 2? Another example, MONTHS_BETWEEN 11-March and 12-June = 3.0323, do you want 3? Are you saying your logic should be…

Hi, The result you see is correct for the dates you provided: 3. You are asking a different question to OBIEE than what the logic of your formula does. TIMESTAMPDIFF at the MONTH level is translated, in an Oracle database, into ROUND(MONTHS_BETWEEN(...)). Run this piece of SQL on your Oracle database and you see the…

https://community.oracle.com/tech/apps-infra/discussion/comment/16798195#Comment_16798195 How is that supposed to help? Are you saying that new browsers are breaking the internet? "old MS Internet Explorer" shouldn't even exist anymore on your system, there are good reasons why Microsoft killed IE. The very new Chrome,…

You want a guide for tuning OAC? Open a SR if you have OAC issues, because that's managed by Oracle. For OAS, just like OBIEE, the good practices are the same. There isn't any "go_fast=42" flag, if you have a performance issue, track it down to the source case and fix that one (many believes they have to change all their…

Is that really a thing? Anyway, https://support.oracle.com/epmos/faces/DocContentDisplay?id=2707401.1 clearly says "applies to any platform", so it covers any OS on which OAS 5.9.0 is certified.

Did you see https://blogs.oracle.com/analytics/saml-20-and-kerberos-single-sign-on-configuration-for-oracle-analytics-server ? There are documents in MOS how to setup SSO with SAML2 for OAS (maybe not update to 5.9, but because Weblogic and FMW are the exact same version of OAS 5.5, they are still valid).

Is this the 3rd thread for the same exact thing? Once only a screenshot is posted and this time 1 line of log file?

Hi, A screenshot isn't very helpful. You have to find the logs and look there inside for the root cause. Failing at start means you should probably look into all the components which are being started to find the one (or many) being the problem.

You can't have a mixed datatype in the same column: if 'a' is a number, 'N/A' should be a number (which is impossible). If you really want 'N/A' then every single number in that column should also be a text, which is maybe not what you want... CAST() can be used to convert any datatype.

Can you look what the physical query looks like in the logs? Depending on the database used DATE is maybe not without time component, therefore even a CAST isn't changing anything at the real values.

I don't have a column with a time component handy, but you could try using CASE(<your column> as DATE). So in your case the filter would become CAST(<column 1> as DATE) = CAST(<column 2> as DATE)

Are those dates really just dates? You seeing '22-Dec-20' doesn't mean the real value isn't 2020-12-22 23:53:47.845 And if you have a time component in your dates, there are lot of chances they will not match the comparison as they will probably all have different times.

Hi, Is that an analysis or a report (BI Publisher)? Assuming you mean analysis (by the name of your columns), you take your first column and add a filter. There you check the "Convert this filter to SQL" checkbox. In the window you have, you can enter the SQL condition you want to use. Just write your column1 = column2…

Hi, You are already getting answers in the MOSC thread you open. Keeping it short: yes you can have as many installs as you want in a single server as long as they don't overlap on disk and that running environments don't conflicts in ports (so same ports are fine if the 2 or more instances aren't running at the same…