dimensions… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

dimensions…

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.

]]>