Metrics in collections failing due to restricted characters

Question

Is there a recommended approach for a customer name that contains restricted characters so that metrics for that customer can be built?  We have a number of customers that contain characters such as period/ full stop but in order to ensure payment we need to ensure that the customer name is accurate this is preventing metrics being built.

Chetna Saboo · Answer

Is this issue being sorted, we are facing the same issue

Mohanbabu · Answer

I am getting the below error. please anyone assist me

ava.lang.RuntimeException: com.essbase.api.base.EssException: Cannot open cube view. Essbase Error(1198094): Unable to connect to source database with the given credentials.

java.lang.RuntimeException: com.essbase.api.base.EssException: Cannot open cube view. Essbase Error(1198068): ODBC message [[Oracle DataDirect][ODBC Oracle Wire Protocol driver]Cannot load trust store. %s1]

Paul Stones · Answer

We raised an SR as below the query is returning restricted characters '.' in the customer account and party name.

On : 11.13.23.07.0 version, Manage Advanced Collections

When attempting to run Initialize and Load Collections Metrics,

the following error occurs.

ERROR

-----------------------

The list of Missing members :: Customer-S-100000103895793,Customer-S-100000121315388,Customer-S-100000121320738,Customer-S-100000121319745,Customer-S-100000121318413,Customer-S-100000121338022,Customer-S-100000121315385,Customer-S-100000121315384,Customer-S-100000121318411,Customer-S-100000121341674,Customer-S-100000121315387,Customer-S-100000121326041,Customer-S-100000103861536, etc

Data is not loaded to cube due to missing dimension members.

/*3-34896897411*/ SELECT HP.PARTY_NAME, HCA.ACCOUNT_NUMBER, HCA.ACCOUNT_NAME

FROM fusion.HZ_CUST_ACCOUNTS HCA,

fusion.HZ_PARTIES HP,

fusion.HZ_PARTY_SITES HPS,

fusion.HZ_CUST_ACCT_SITES_ALL HCASA,

fusion.HZ_CUST_SITE_USES_ALL HCSUA

WHERE HCSUA.SITE_USE_ID ='100000103895793'

AND HCSUA.CUST_ACCT_SITE_ID = HCASA.CUST_ACCT_SITE_ID

AND HCASA.PARTY_SITE_ID = HPS.PARTY_SITE_ID

AND HCASA.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID

AND HCA.PARTY_ID = HP.PARTY_ID

AND HP.PARTY_ID = HPS.PARTY_ID;