In other analytic product we have this feature as shown below that converts formula expression into textbox.
The screenshot shows that the formula outcome is the string shown in the big box. The big box does not convets the calculation, it is just showing the value. Using the CONCAT function, you can create a similar expression in OAC/OAS. In this case, the function will be something like:
Concat(Concat('Financials as of ', MONTHNAME(CURRENT_DATE)), Concat(' ', cast(year(CURRENT_DATE) as char(4))))
(I did not do the relative month calc as the question was about the textual function)
Sometimes, it is cleaner to use REPLACE as you can write the full templated sentence and don't need to concat string parts that are not values.
REPLACE(REPLACE('Financials as of MMM YYYY', 'MMM', MonthName(CURRENT_DATE)), 'YYYY', cast(year(CURRENT_DATE) as char(4)))
Right now, OAC offers pre-built pages and watchlists related to NSAW. At our University, we do not need these pages, and we want to delete them entirely. We've been told in response to our SR that all we can do is keep "Access" limited to only the default admin and sysAdmin roles. This prevents regular users from seeing…
It would be nice to have a way to right click on an object (subject Area, Column, Calculation, etc.) in the Data Panel and show where that object is referenced in a workbook = canvas, visualization, filter, calculation, data action, etc.) In Workbooks with multiple canvases and multiple subject areas, we are left to hover…
We want to automate the workbook export to .dva file and import this into another OAC instance using REST API, The goal is an OCI DevOps pipeline that can promote (a) a whole folder, (b) a single workbook, or (c) several workbooks in one run to another OAC instance, and print a status result at the end. Blocker: Export and…
When Oracle Analytics AI features find an anomaly, trend or key driver, let authors save those results as a dataset or subject area. Each run would add rows with the metric, the date found, the expected versus actual value, the severity, the main drivers and the filters applied. Authors could then build workbooks, schedule…
We use the snapshot to update AppRoles members. But we would like to disable catalog content to have smaller snapshots and create snapshots faster.
