you can put varchar(3). absolutely there is nothing wrong with it.

Hi, Cast is string function basically. so try the below: CASE WHEN CAST("WORKFORCE".""."HRDWH"."DimRating_MD"."EP_RATING" AS VARCHAR(4)) = '999' THEN 'Not Rated' ELSE CAST("WORKFORCE".""."HRDWH"."DimRating_MD"."EP_RATING" AS CHAR(1)) END because first conversion is from number to character and in second, you are converting…

Hi Christian, It is MySQL Aurora DB in AWS. I am able to trace the issue and updated the ODBC.ini file and It is working fine now. Thanks for your effort Thanks, Bose

Hi Bhasker, Sometimes, in Physical layer, If cache is enabled for table/view it will pick the data from query result. Uncheck the cacheable or cache persistence in physical layer properties of a table. No need to refresh any layer everytime if the structure of the table/view is going to be same. Hope it helps!

same credentials.. never changed.

Hi Christian, Thanks for the response! I am able to ping the database server from BI Server and It does respond to the ping. From the same server, I am able to import tables in Admin Tool in my windows machine and developed the RPD modeling. After deploying the RPD in my AWS Linux server, I am not getting any data as there…

Hi, In Answer, if you want to test the result, then just update the default column with any date value and try. It will not give any error.

Hi, There is a string function LOCATE that will helps us to identify particular text in columnand then we can apply COUNT on top of it. for e.g COUNT(LOCATE("Table"."Column",'ING')) The above example will count the repetition of the value 'ING' in the table field. Hope it helps!

Hi Mik A.M, Try with the same syntax you wrote. It will work both in RPD and Answer Side.

Hi, If the column has the URL, then just change the Data format of the colum. ( Column Properties -> Data Format -> Custom Data Format) @[html]"<a href="@H" target="_blank">"@</a> This option will allow the open the URL in the new tab in the browser. Hope it helps! Thanks, Bose