Enabling this request would prevent disastrous calculation errors when analyzes are modified or migrated.

Thank you for the thorough explanation Robert. Jon

Screenshot 3 *Also attached for your reference the resulting report exported in .xlsx format. Thank you. Jon

Screenshot 2. * Please also see attached file for your reference that under "Tree View" the filtered data model shows only the word "DATA_DS" without entries. 

Hello Robert, Thank you for advising the solution. Could you kindly review the attached 3 screenshots, and comment on the possible reasons the published reports were not published according to the intended filters? 1) Screenshot 1 • Proving that the entry "HG" and "D99" are parts of the default data model when it is not…

Hello Robert, Please see below the following outcomes: 1) Both the data model and RTF report ran successfully when the following code was executed. Select ITEM_NUMBER AS COL_A, INVENTORY_ITEM_ID AS COL_B from EGP_SYSTEM_ITEMS_B 2) The following error was prompted when running a RTF report generated base on the data model…

What an "open ended" response. I've have posted my outstanding questions to 3 new posts below, and hopefully they will offer "closure"! https://cloudcustomerconnect.oracle.com/posts/db4fd3db16 https://cloudcustomerconnect.oracle.com/posts/64c2017ac6 https://cloudcustomerconnect.oracle.com/posts/9c3b02a874 Best. Jon

Hello Robert, Thanks for the advise. I have posted the questions on the following 3 posts: https://cloudcustomerconnect.oracle.com/posts/db4fd3db16 https://cloudcustomerconnect.oracle.com/posts/64c2017ac6 https://cloudcustomerconnect.oracle.com/posts/9c3b02a874 Chat over there. Jon

Hello Marteen, Do the the data output the intended result with the following code? CASE WHEN "Payables Payments - Payment History Real Time"."- Payment Information"."Payment Status" IN ('Cleared','Negotiable','Voided') THEN "Payables Payments - Payment History Real Time"."- Payment Information"."Payment Status" WHEN…

Hello Robert, Thank you. You advised method works produce a column with consecutive non-repeating row numbers for analysis if its columns do not share identical values. For analysis having identify entries within a column, I hope Oracle will come up with a "Row Number" check box option for analysis in its future update.…

Hello Robert, Thanks for the solution. I performed the approach you advised, and ran into 2 errors. Could you kindly comment on possible resolution: 1) Error 1 • Error code - It appears when I run the saved report. oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException:…

Thank you for posting a question I had in mind for a while. This communication thread helped answer my question.

Thanks for posting the clear illustration.

Hello Christian, Thanks for pointing out that the only viable options are RPD or direct DB request for the Oracle version that I am using. I have posted the idea on the idea forum at the following URL: https://cloudcustomerconnect.oracle.com/posts/d652d91ffd

Hi again Raghavan - Thanks for the affirmation and the link to the video. I had watched it previously, and noted that analysis can be called out to infolet.

Hello again Prudence - Thanks for the tip and I will try this approach to see if it works.

Hello Gabriel, Thank you for your response. Your recommended method was my original approach. Is there a way to lock the ranking order so it doesn't change despite re-sorting are performed on other columns. The goal is to show an index column of row numbers for read friendly purpose, so this column should be static despite…

Hello Prudence, Thank you for the "reverse engineering" approach! Best. Jon

Hello Raghavan, Thank you for the affirmation. Best. Jon

Hello Fernando, Thank you for for the response and reference link. Best. Jon