3 Replies Latest reply: Oct 27, 2009 9:00 AM by aamit RSS

    is this proper in QV?

    Amir Vastani

      I am looking to get analysis on the Territory level but where where all roll up to a Region and regions rolling into a Division. I use the Terr field from the Geography and the Region field from the Product table and the Division from Geography.

      Or should I use all three dimensions from the Geography table? If I use all 3 dimensions from the Geograhpy table, my charts are incorrect because all Territories show the exact same sales. but when I do the split as Territory and Division from Geography and the Region from Product, I get unique results for each territory and region and division. Why is that? Based on my schema, I should have gotten the same result either ways but it is not so. Thanks in advance for your help.