Skip to Content
author's profile photo
Former Member

Drilldown by Customer Country

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 06:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 06:05 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded