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.
I feel as the data is measured against the new dimension so ofcourse u will get england measures as null vaues or 0 elements.
