Did you try some alternative syntax to escape " ? " in your command is probably interpreted as a quoting of the values and not as part of the value to search & replace.

What do the logs show? How is the query showing all the values different than the one with the filtered values?

I highly doubt an Essbase server has an http:// address, "Essbase Server" is the address where the Essbase agent can be connected, it isn't an http:// link. Read the doc, it tells you most of the things you should look for:…

What is your exact version of OBIEE? (12c doesn't mean anything as there are 5 main versions and many many more bundle patches). Did you check the certification matrix? OBIEE 12.2.1.4 is certified for Essbase 11 and 12, you are using Essbase 9: a very very old release (2005 or there around) and things changed with 11 and…

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