could it be that -Dsfx.installer.launcher.home=C: should be -Dsfx.installer.launcher.home=C:\ (or "C:\") because it's the Home path, not the Home mount that is needed.?.

The quotes are a Windows quirk to deal with potential spaces in paths. My guess is this: "C:\Users\XXXXXXXXXX\AppData\Local\Temp\5\sfxC641.tmp\oracle.jre\jdk\jre\bin\java.exe" -Djava.io.tmpdir="C:\Users\XXXXXXXXXX\AppData\Local\Temp\5" -Dsfx.installer.launcher.home=C:…

Hi @Santhosh_N, You should engage a SME on the EPM side that understands the data in the cube that you are building the DV Report on top of. You can't think of Essbase as just a fact table, given its multi-dimensional nature. It will be helpful for you to have the SME show you how to prototype the data set you want, by…

@AM HRE In Data Warehouses/Data Marts it is very common to define the Primary Key (PK) with one column that contains a unique, system generated id for each row. This also known as a "surrogate key". This approach simplifies the design of tables because Foreign Keys (FK or join keys) between tables can be defined with just…

Hi @Vivek_Gautam09052022, This is why I throw this question out there. ODI-MP is obviously the more mature, on-prem based solution, just hosted on OCI. It would be telling if you are correct and the internal product teams are still dependent on it…

I've always wanted a good place to ask this question… Would it be correct to say that: OAC's Data Preparation, FDIP/FAW Pipelines and EPM Cloud's Data Integration are all engines that are built on top of the core OCI DI engine?

The fact that the difference was 2 didn't feel right to me at first, but then I remembered a project that I was on in the mid-aughts. At the time we found out that Excel had purposely perpetuated a bug from the Lotus 123 days to preserve data integrity, by including Feb. 29, 1900, even though 1900 was not a leap year. one…

Just one note of caution (I don't have access to validate this right now) wrt the proposed solution: TIMESTAMPADD(SQL_TSI_DAY, "LAST_UPDATE_DATE", TIMESTAMP '1900-01-01 00:00:00') Excel converts '1900-01-01 00:00:00' to a value of 1. In fact, Excel formats the value of 0 to the imaginary 1/0/1900, not 12/31/1899. You may…

@User_ZGKDB Could someone be running reports via MAXL? There is the ability to mimic a user from the MAXL CLI using the LoginAs command.

@Rajakumar Burra I just stumbled onto this thread... What kind of caching strategies were you using to increase the performance? How do OAC cache config strategies compare to Qlik's, in terms of complexity to implement?

@Hui Wang-Oracle Did your test include 3 canvases as well? I think the the original request was to have the ability to link to another canvas, insead of a URL.

@Scott Manning Maybe create an IdeaLab/Enhancement request for the addition of brackets as a operators in the filter tool. This would make defining complex, nested logic simpler, the resulting filter easier to understand by others and probably make the indentation logic simpler to boot.

Hi Scott, So you want to the logic to be: (Meets condition A AND meets condition B AND meets condition C) OR (meets condition D AND meets condition E)

Being able to import/export custom colour palates and other corporate "look and feel" attributes would also enable having a change management process, as a company fine-tunes these attributes.

If the RPD was converted to support Semantic Modeling, could you not export the models and search the data source connections?