Metrics in collections failing due to restricted characters

Paul Stones

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.

Sinduja Sekar-Oracle

Hi @User_NXCSL

Thank you for posting in FAW forum. Can you please provide more details on the product that you are using and the report or attribute that you are trying to build the metric on ?

Paul Stones

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;

Mohanbabu

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]

Chetna Saboo

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