Filtering by comany code in a queries?

[Former Member]

Hi Epxerts',

Here is requirement what I got from my onsite .

Please modify following queries to add a filter to exclude company code 1000. Add filter in global area.

Beow this there are list of queries to be changes.

Actually these queries are created over a multiprovider and I checked that this multi provider is not having a field called company code and there is seperate master data maintained for this company code.

Please tell me how can I restrict the company code in this scenerio?

poitns will be definitely asigned.

Thanks,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

From your question it seems that multiprovider doesn't conatin company code and there is a separate master data bearing char for company code.

Check if Company code is there is the data targets(DSO, CUBES) which are included in your multiprovider.If yes then modify multiprovider to include company code from data target. If not enhance your data target.

Regards,

Saurabh

[Former Member · Accepted solution]

Thanks.

Yes the navigational check mark was not enabled if I make the check mark enable and it may appear in the query?

by the way what is this filter in Global area?

[Former Member · Accepted solution]

Hi Ravi,

If you set the attribute as navigational you can use it as a filter in your query.

A global filter means that the filter can not be changed during navigation ("Characteristic Restrictions" in BEx Query Designer 7.x). You also have the possibility to restrict the default values of characteristics - but this can be changed during navigation ("Default Values" in BEx Query Designer 7.x).

BR

Stefan

[Former Member · Accepted solution]

When I tried to activate the multi provider I am getting message like this

Assignments for InfoObject 0COSTCENTER__0COMP_CODE have not yet been maintained

Please help me?

[Former Member · Accepted solution]

In the multiprovider maintanence right click on the nav. attr. and choose "Identify (Assign)". Then select the appropriate assignment from the infoproviders used in the MP.

BR

Stefan

[Former Member · Accepted solution]

Hi

Go to the navigaion of the multiprovider and uncheck the 0COSTCENTER.

and also Check out the setting in multiprovider "Identify Characteristics" and "identify Kefy figures" checked.

and reactivate it.

santosh

[Former Member · Accepted solution]

Ravi

I guess the InfoObject 0COSTCENTER__0COMP_CODE is not assigned properly to the Multiprovider, assign it properly and try to activate it.

Regards

Ravi.

[Former Member · Accepted solution]

When I right cliick on the 0COSTCENTER__0COMP_CODE and select the identify then it takes me to screen where I can see nothing in that screen.

Please help me help me how to assign in detail?

[Former Member · Accepted solution]

0COSTCENTER__0COMP_CODE will have to be set to navigational in the desired underlaying infoproviders before you can assign these to the multiprovider. Please note that update rules etc. will be inactive when you reactivate the infoproviders!

BR

Stefan

[Former Member · Accepted solution]

As per my first question do I need to place this comp_code in free char or in filter?please clafiry?

[Former Member · Accepted solution]

If it has to be a global filter it should be placed in the filters. If you restrict it in the free chars. it can be changed during navigation which I think is not what you want.

BR

Stefan

[Former Member]

Ravi

I think you may need to add the company code to the underlying Infoproivders and also need to update the multiprovider and then change the query to use the company code restriction in your queries.

All the Best

Ravi.