Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I have used below formula in report. EVALUATE('REGEXP_REPLACE(SUBSTR(%1,1,%1-4),''[0-9]'',''X'')||SUBSTR(%1,-4)',"Order Details"."Credit Card Number") - syntax is working fine. But it is populating data as '0.00' in front end report where as If I executed the back end code in database it is giving expected results as…
-
How can we implement this at RPD Level ? I have Dimension table W_STATUS_D - Created two alias 1. W_STATUS_D_Generic Date, 2. W_STATUS_D_Latest_Date and Fact table W_MXD_F. I joined the two alias tables to fact table with common column Status ID. In BMM Layer I created One logical table with Two LTS (which are alias of…
-
Thank you @Jerry Casey, I have removed the Null and it is not populating duplicate columns.
-
Hi @Jerry Casey I have added the same case condition and noticed that it is causing null values in data, I tried to keep filter as List price is not null where it is giving error Oracle Error code: 934, message: ORA-00934: group function is not allowed here at OCI call OCIStmtExecute. It is populating duplicate values will…
-
Hi All, Thank you for the response. We are planning to implement Oracle apex. Thank you, steel.
-
Even I have implemented the same logic. Thank you @Jerry Casey.
-
Hi @Gianni Ceresa, Thank you. I will check and update you.
-
Hi Gianni, Particular dashboard is the Custom Dashboard. I am not going to change the OOTB dashboards. I want those colors to appear on Custom Dashboard only.The above three methods which I google from different blogs. Those code are worked for them. None of the codes did not worked out for me. The dashboard consists of 15…