Answers (OBIEE analysis) and BI Publisher are 2 very different tools, they don't share the same functionality. BI Publisher has some integrations with OBIEE to use the BI Server as a possible source, the security and catalog can be shared, but the 2 tools are still different and separate tools. BI Publisher doesn't have…

And what do the logs say? If a size limit is hit in OBIEE there should be something logged somewhere. And also if the email is sent by OBIEE there is a log. Go through your logs to find exactly where things stop. Don't exclude it's an issue with your mail server till you don't see the logs saying OBIEE didn't even try to…

The question is if you have OEM, because if you don't, you have your answer already...

Technically you can write an integration if that's your target. The RPD is a single binary file, but still there are way to generate RPD content (the easier one is by using the XML format of the RPD). But I'm not aware of anything widely used. Maybe somebody sell a tool for the job, but definitely not something widely used…

Hi Alex, Not only it's a good idea, but that's how authentication and authorization generally works. In Enterprise Managers you will see the AD groups available as members of the application roles. So you map your AD groups to application roles and after you only manage your users in AD by adding them or removing them from…

You can search for long, you will not find one. First of all, Informatica is an ETL, it does transform data. I doubt you want to do the same data transformations in the RPD, so at the best you can look to have your final data objects (tables) into the RPD. Still, Informatica will not be able to provide any info on how…

Hi Joe, Isn't this the same as https://community.oracle.com/tech/developers/discussion/4485777/how-can-we-store-ms-word-rtf-content-data-in-to-the-oracle-database-without-missing-formats#latest ? OBIEE is a web-based tool, if you want something to have a "format", it has to be HTML. How you do store your source, it isn't…

And how about a COUNT and using content levels to tell OBIEE at what levels of your hierarchies it has to work?

All the detail for RCU version 12.2.1.4 by command line : https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/rcuug/running-repository-creation-utility-command-line.html All the parameters and available settings are described and examples, including to define specific tablespaces for every single component,…

You should call RCU before configuring OBIEE/OAS, the RCU gives you all the options, the configuration of OBIEE/OAS only does the very minimum customization if the RCU schemas haven't been created first.

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…