nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Can formula expression be automatically converted into meaningful textbox.?

Sreekumar_Analytics_Ambassador

In other analytic product we have this feature as shown below that converts formula expression into textbox.

Find more posts tagged with

Declined

Analytics

Status: Declined

Comments

Gabby Rubin-Oracle

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

Top Leaders

Top Ideas

Ability to disable the header row in tables and pivot tables
I am creating two tables in a freeform report and overlaying these tables to appear as one to the end user. I can hide the header titles by setting the font and highlight colour to the same as the background colour but it would be better if there was a functionality to disable the header row completely.
Ability to list the members/users of a custom role from the OAC -> Console-> Roles and Permissions
My organization needs a practical way to generate a comprehensive report listing all members—including both direct and inherited assignments—of every custom application role within the Oracle Analytics Cloud (OAC) Console’s Roles and Permissions area. Today, the only built‑in method is exporting one role at a time through…
Ability to fix the width of table columns to a set value
Currently you are able to change the width of a field in a table or pivot table by dragging the border but there is no option to manually fix it to a set value e.g. 100px. Justification: I am creating a report with two tables in freeform and need the field widths to have the same size when I overlay one table on the other.…
Allow Selection Steps in OAC Classic Analysis Reports to Support CASE Logic Conditions.
Request for an enhancement to Oracle Analytics Cloud (OAC) Classic Analysis Selection Steps on measure suppression for a specific calculated member created through Selection Steps. This idea is opened based on the directions from oracle CEAL team, for more details please find the below service request. SR -…
REST API for OAC App Roles
Hi, We use a lot of Custom App Roles in OAC Console and It would be easier to have an API to manage the members of App Roles.