SQL Server Performance

dimensions...

Discussion in 'Analysis Services/Data Warehousing' started by shrike, Jun 13, 2005.

  1. shrike New Member

    Goodmorning,
    I'm a newbie to Analysis services.
    I'v a parent-child dimension with nations and cities like following structure:

    [AREA]
    - EUROPE
    - France
    - Paris
    - Bordeaux
    - Marseille
    - England
    - London
    - Manchester
    - Germany
    - Munchen
    - Nurnberg

    I need to create a new dimension without some base-element of my existing [AREA] as following:
    [AREA_2]
    - EUROPE
    - France
    - Paris
    - Bordeaux
    - Marseille
    - Germany
    - Munchen
    - Nurnberg

    excluding England.
    When I include this second dimensions in my CUBE any data are filtered excluding the country 'England'.

    To build report I use MIS-Plain and if I create a view on my Cube using hierarchy 'AREA_2', correctly there isn't the element 'England' but using hierarchy 'AREA' all elements under 'England' are 0.

    How can I resolve it?

    Thanks.
  2. ranjitjain New Member

    I feel as the data is measured against the new dimension so ofcourse u will get england measures as
    null vaues or 0 elements.

Share This Page