BW Characteristic Relationships on specific Query

[former_member538259]

I'm doing a Characteristic Relationship using the class CL_RSPLS_CR_EXIT_BASE as reference. BW uses to have input parameters in order to get the infoprovider that calls the "functionality". As you can find in BW BAdIs with the name "I_T_COMPID". The class CL_RSPLS_CR_EXIT_BASE has the input parameter "I_BASIC_PROV" that returns the infoprovider name (in this case, advanced DSO). Are there any way to get the query name? I'd like change the relationship table depending the query that calls it.

[gregor_dieckmann · Accepted solution]

Hi Alberto,

by design characteristic relationships are not bound to a query but bound to the basic planning provider; this is why you find I_BASIC_PROV in the GET_INSTANCE method. That you want to do something query specific in a characteristic relationship indicates that you are using the wrong method to achieve something that you have not explained here.

Characteristic relationships model the planning constraints valid for a basic planning provider and are automatically reused by all queries and planning functions using this provider explicitly or via other providers as MultiProvider or CompositeProvider which have the basic planning provider as part provider.

Regards,

Gregor

[former_member538259 · Accepted solution]

"Are you talking about the value help in new lines or do you want to show all valid combinations in the result set of the query (setting access mode for result values based on characteristic relationships)?"

Yes, the value help in new lines and it depends of the query.

System BW4HANA
Query over aggregation level and a BPC Embedded model is assigned in Analysis for Office report.

Thanks and best regards!

[former_member538259]

Thank your for your answer!!

I need the characteristic relationships on specific query for show determinated list of values instead all posible values. And in the rest of the queries show all posible values. Is there any way to meet this requirement? Any BAdI?

[gregor_dieckmann]

Are you talking about the value help in new lines or do you want to show all valid combinations in the result set of the query (setting access mode for result values based on characteristic relationships)?

Attention: A characteristic relationship might also be called in a planning function, e.g. the method CREATE is called in some algorithms when the function has to create combinations (e.g. in the copy function).

[former_member538259]

Yes, the value help in new lines and it depends of the query.

System BW4HANA
Query over aggregation level and a BPC Embedded model is assigned in Analysis for Office report.

Thanks and best regards!