Enabling navigation Attribute in multiprovider and query

Hello Experts,

I need to add a navigation attribute in a Query.

The navigation attribute in not turned on in the multiprovider.

there are 2 DSO and a Infoset under the multiprovider.

In that 2 DSO the navigation attribute is present but it is not turned on.

Do I need to turn on the nagivation attribute in the DSo and then in the multiprovider?

Or if I only turn on the navigation attribute in the mutoprovider that is enough??

Please suggest.

Thanks,

Ipsita