Oracle Analytics and AI

Priya Chary

I'm encountering an issue while working in SME. (see screenshot) indicating an error.

"Subject Area attributes have leading/trailing whitespace character. Please check subject area name/description/folders/columns for possible whitespaces."

I’ve reviewed the subject area name, description, folders, columns, and even the referenced database views and columns—none of them contain any leading or trailing spaces, special characters, or parentheses.

Everything is aligned with latest recommendations stated here:

https://docs.oracle.com/en/cloud/saas/netsuite-analytics-warehouse/nsawa/customize-oracle-netsuite-analytics-warehouse.html#GUID-3325B397-6E0C-447E-A81A-50D27D9ACB42

Has anyone run into this before or know how to resolve it? Thanks in advance for any insights!

Ram-Oracle

Hi @Priya Chary

Welcome to the Oracle Analytics Community.

For sme leading or trailing whitespace error please check following document

FAW:FDI:FDIP: There Are Errors In Your Current Semantic Extensions - Leading / Trailing Whitespaces (Doc ID 2995720.1)

One way to find the columns with whitespaces:

In the browser, go to Settings and Developer Tools > Network tab. Then, navigate through the SME step which showed errors with whitespaces.

The Network tab will show a Payload step now. Copy the contents of this request in a notepad. Then, search for two strings -> ( ",) - space followed by double quotes followed by comma, and (" ) - double quotes followed by space. If you find any match, then those are the columns or names with leading / trailing whitespaces. Remove the whitespace in that object and save the changes. The errors should go away.

To generate HAR file from chrome browser ,press F12 and then from network tab ,preserve log and check har file as mentioned above.

please also check another use case from the following document

FAW: Reporting Issue with Space in Table Names in SME (Doc ID 2999595.1)

Thank you for posting your query on Oracle Analytics Community