How can i hide # while generating reports on multi provider.

[Former Member]

Hi Sir/madam,

I'm getting # while generating reports on Multi Provider.How can i hide # in reporting on Multi Provider.

Regards,

Vishali.

[Former Member · Accepted solution]

Hi Vishali,

Say if you have 2 infoproviders in a multiprovider, then you have to use only the characteristics which are common in both the infoproviders in the drill down of the report. ( In rows or columns ).

If you introduce any characteristic which is not common in the drilldown then you will get # as it is not available in one of the infoproviders.

if you want to introduce any filter in any of the characteristic which is not common, then you have do the restriction locally in the KF where you want to apply this filter.

Hope this helps,

Thanks,

Krishnan

[Former Member · Accepted solution]

Hi,

thanks 4 clarifying my doubt.

Regards,

Vishali.

[Former Member · Accepted solution]

You are welcome.

[ravikanth_indurthi]

Hi,

Exclude '#' for the required infoobject restriction in BEx query designer.

Hope this helps...

Rgs,

Ravikanth.

[Former Member]

Hi Sir,

I've tried but still I'm getting #.

regards,

Vishali

[Former Member]

Hi,

You will have to use Constant Selection for hiding # values.

Please refer the below link for more information,

[http://help.sap.com/saphelp_nw70/helpdata/en/46/91f0f090ea13e8e10000000a155369/content.htm]

Regards,

Durgesh.