Logs tell you everything about why something doesn't work. Start the usual checks: are the components started? What do their logs tell you?

Hi, I didn't try in OAC, no idea if it does still work... There was (is?) a system session variable named "USERLOCALE" that you could set in your RPD for all users with the value you need.

Hi, Embedding multiple CASE WHEN works, if you got an error you should check the logic of what what happening. What you could also try is to simplify your first CASE WHEN because it can be replaced by the IFNULL() formula. A random guess of what you could try: CASE WHEN IFNULL("Order Detail - Oe Order Release"."Revised EST…

As reference, if you want the details of the requirements to install OAS, you can check this: https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/sysrs/system-requirements-and-specifications.html It's the requirements for installing the Fusion Middleware 12.2.1.4, which is the base on top of which you install…

By the way: installing OAS 6.4 now? OAS 2023 (aka 7.0) has been released, do you really want to miss a full year of features? You just need to replace the OAS install file, everything else is exactly the same (patches as well are almost all the same, the main difference is that OAS 2023 doesn't have a bundle patch so far…

The OAS installer doesn't install any OS prerequisite, but they are all documented and it's your job to make sure they are all set. The DB preinstall package mentioned above will install many more things and also change a number of settings in your environment. You should look in the doc for the minimum list of…

You mean SSL certificates? My guess is that if they are signed by publicly recognized authorities, it should be good. A doc says: In most cases, you don’t need to provide a compatible certificate as most mail servers can use the default certificate, including Office 365.

Isn't the Office 365 SMTP requiring an OAuth2 authentication? If it does, then no, not supported so far (not that I did look if the config screen changed, but nothing has been said about this in the list of new features of the March 2023 release). If your SMTP doesn't use OAuth2 but standard authentication (over SSL), it…

Hi, Any chance you could be a bit more precise on what version of the product you are using? OAC is OAC, while OBIEE is OBIEE. Or you maybe mean what is generally referred as "classic" in OAC (and not DV or Publisher): dashboards, analysis? Mobile usage of the product generally was done via the app (there is still the…

It becomes a challenge when everything starts by pushing DV for everything. It has no chance to catch up with everything classic does and it can't be the plan because it would take years. And when the "new features" are reproducing something that existed and worked for 15+ years inside the same tool, it's challenging to…

True that you can get everything via the webservice. But in the end: aren't you going to overengineering something? Not sure what exact product you have in front, Catalog Manager really isn't an option? You could do an archive of the catalog by command line / code and be 100% sure it will work in case of a restore. But…

Just to note that I wouldn't really consider this a backup. You get the content of an object, but the XML doesn't contain the ACL and other few metadata (like type of object, owner etc.). So it's really a pure "content" backup and will not be fun to restore. But better than nothing for sure !

Hi, So you want to backup the catalog, right? Sure you can do it by webservice, tested and perfectly working on OAC. You can look at this doc https://docs.oracle.com/middleware/1221/biee/BIEIT/methods.htm#BIEIT180 which describe the various services available. The one you look for is the WebCatalog Service. You find…

Just a detail : once deleted in OBI it's deleted forever, not into a trash or temporary place where you can get it back. So you either have a backup you restore or go with the ideas posted by Sricharan. (And the backup aren't done automatically, it would be up to you to setup a backup process and make sure you can restore…

Don't be jealous 

Not at all! Was more me complaining with myself because of doing things in the middle of the night a bit randomly instead of doing it in a more "qualitative" way in the morning :D Keep going with your OTBI (OBIEE), it's fun ... at least I believe it is. Always happy to support the community here in the forums like many…

Sorry for not having been more explicit (at 1:40AM on a phone was already not easy :D ) You set these formulas in the "Criteria" tab editing the formula of 2 columns (so add your "cost_center" twice and then change the formula in both to be the cost center ID and cost center name). You generally never edit the SQL (logical…

Hi Stefan, As they finally set permission on the forum it’s possible to reply... LEFT('00-00-000 HQ - CostCenter', LOCATE(' ', '00-00-000 HQ - CostCenter')) SUBSTRING('00-00-000 HQ - CostCenter' FROM LOCATE(' ', '00-00-000 HQ - CostCenter')+1) You can use these 2 formulas to get the left and right part of the column. As…

You can set it in DV > console > System Settings > Portal Path, just enter the path of the dashboard you want to use. And you can't change the behavior of the "Home" link in the top main menu in OAC : the homepage of the product is a different thing than the "starting page" you can set in "My Account" (or with the Portal…

I see what you are looking for and it's absolutely valid (and that's the default behavior of classic prompts in general for the same exact reason you said: to not change visualization, and the relative queries fired, till the filters are all set). Seeing a bit where DV comes from, I suspect it isn't an existing feature,…