Drilldown by Customer Country

[Former Member]

Hi

I am using BI 7.O in which i have a customer outstanding query using 0FIAR_C03 infocube.In this i require drilldown based on Customer country but the present country characteristic is showing Billing country (0COUNTRY). I want to use country attribute of customer ( 0DEBITOR ) .

How do i go about this .

Itz urgent . Prompt reply is highly appreciated

Thanks

[Former Member · Accepted solution]

Hi deepak

Just check your infoobject 0DEBITOR. If 0country is defined as navigational attribute then you can modifiy your Cube and make 0DEBITOR__0COUNTRY navigational attribute ON.

After this you can define this 0DEBITOR__0COUNTRY as free characteristic and have drilldown which will give you Customers Country .

Regards ,

Manish Churi

[Former Member · Accepted solution]

Hi

Thanks for your prompt reply .Appreciated mann..

But i just want to confirm that after changing the cube definition will it affect my cube data and other queries based on this cube and even multicubes???

Pls do reply..

Regards

Deepak

[Former Member · Accepted solution]

Hi,

It doesnt affect your cube data & queries.

But you need to Reactivate update rules belongs to this cube and Multiprovidors created on this cube

After this you will get 0DEBITOR___0COUNTRY under Customer dimension for selection when you modify your query.

Regards,

Manish Churi

[Former Member]

hi, 0debitor is a reference of 0customer, 0customer will inturn have country..

you have to load 0customer master data attributes

you have to make sure that the customer country navigational attribute is checked in your cube.

you can use the 0debitor___0country in your query to get this.