Guessing the question to me is about this: "The first time, we ran it without checking the "Force refresh to rebuild the hierarchy even though the synchronization process was run" option, and the logs indicated that the data was processed, but there was no trace of it in the table. On the second run, we used the 'Force…

No, we don't have it planned yet.

REPLACE(REPLACE(REPLACE("Compensation Notes"."Compensation Note" ,'<br/>',''),'<p>',''),'</p>','') You have 3 choices. You can use a formula like above. You can use column properties. If you use plain text, then html tags will appear. If you use html, then tags will go away.

Review the Code Snippet in the link I provided.

My area is OTBI.

Futher functionality is also available in: 23C New Subject Area - Compensation - Workforce Assignment Salary Real Time https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/compensation/releases/23C/23C-compensation-wn.htm#F28574 New Subject Area - Compensation - Workforce Assignment Salary History…

This functionality was delivered in 22.04 / 22B. Please see: https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/compensation/releases/22B/22B-compensation-wn.htm#F22334

I would like to add here, that the assembler may allow a table name alias that is not accepted by the system, for example WORKER and POSITION as discussed here, in that case the error codes are ambiguous: https://community.oracle.com/customerconnect/discussion/comment/636924#Comment_636924

See the first paragraph, last sentence. "...will also be updated to FMW 12c"

In the meantime, CAST "Expenses - Expense Transactions Real Time"."Approval Level" as NUMERIC.

In Prompts under Options did you try Choice List Values, SQL Results, and Select where the values are not equal to inactive, or equal to active? You can also list specific column values to display and add them here.

What about multiple views?

I have use cases where these need to be independent actions. On the criteria tab, I need them in one order, on the results tab, they need to be different. For example, when the results tab contains multiple views, then how could this be honored? (The edit icon does not need to be used, the columns can be dragged.)

Hi Stephen, scoping is under way, and we are interested to know more about your request. May I have a greater understanding of the use cases?

Stephen it would help us immensely if you add your thoughts on how you use the ranges.

Thank you, much appreciated.

I posted a sample report that removes HTML tags, not for the same subject area, but the concept will be the same. See the code snippet on the post, it is a bit of a chore to figure out all the tags and list them all. In the code snippet I've removed the <br>, <p> and </p>. It's located here.…

These posts could help Cross-Subject Area reporting (white paper) Cross-Subject Area reporting (YouTube demo) OTBI Data Joins and Cross Subject Area Queries https://cloudcustomerconnect.oracle.com/posts/18820e4bbe UI for Logical SQL

See: UI for Logical SQL

(I'm just noting a relevant ER#27190781)