Dear Experts
How can I suppress warning message that did not stop the query from running?
I encounter this message when 1st launching it. The next run , it does not show. But if user run it i think may still show. How to suppress it?
The message is :
=================
Characteristic [Z_I_NN_FN]Application Sub Grou of the MultiProvider is not provided by the PartProvider ZC_00N; this means it is not identified. However, [Z_I_NN_FN]Application Sub Grou is compounded to 0COMP_CODE and 0COMP_CODE is identified with characteristic Z_I_MM_FM for InfoProvider ZC_006.
In this case, there is a compounding or CMP problem with [Z_I_NN_FN]Application Sub Grou in the MultiProvider for PartProvider ZC_006.
Processing characteristics with CMP problems in the data manager is very complicated and can have a negative impact on performance. The data manager cannot use SIDs for these characteristics (at least not in the corresponding InfoProvider) because the initial SID = 0 for [Z_I_NN_FN]Application Sub Grou is not the same as the initial compound key for 0COMP_CODE [Z_I_NN_FN]Application Sub Grou (that is, when real values are posted in ZC_006 for 0COMP_CODE).
For this reason, hierarchies for [Z_I_NN_FN]Application Sub Grou must often be read at leaf level. Furthermore, it is not possible to use hierarchy aggregates for [Z_I_NN_FN]Application Sub Grou or for the remaining InfoProviders.
System Response
Where possible, the system tries to avoid negative impacts on performance. Unfortunately, such performance issues cannot be avoided if the correct results are to be displayed.
Procedure
When working with important MultiProviders, you should always avoid characteristics with CMP problems.
====================
Please advise how to address CMP problem error message when launching query.
regards
Pascal