Ragged Hierarchy Data display problem RRS feed

  • Question

  • Hi all,

    I am facing a very strange problem while creating Analytic table, chart or scorecards in performance point. I have a product dimension which has a ragged hierarchy. The Hierarchy has 3 levels: Market, Product and Packs. 1 Market is formed using 4 products. 2 products have packs and 2 products does not have pack. When I am trying to display data for all the products, I can only see the data for the products which does not have packs. I mean, for Product dimension, I am getting only data for the leaf nodes. But When I see the mdx query executed in the analysis service, it returns data for all the products. Even if, I have checked using the profiler and caught the mdx query that is called by the performance point, but that query returns data for all the products. But performance point does not display the data. It also does not show the data at market level.

    I am not sure why this is happening. If anyone can give a solution to this problem, that will be very helpful.

    Kind regards.
    Thursday, January 28, 2010 12:35 PM