Drill through table does not show correct count when used with a dimension having parent child hierarchy and a filter on this dimension

Hi All,

I have a dimension with parent child hierarchy as shown in code block. The issue i am facing is if i have a filter on parent child dimension then drill through table does not show filtered data instead it shows all the data for that dimension. Here is an example.

<Dimension type="StandardDimension" name="page_type_d" caption="Page Type">
<Hierarchy name="page_type_h" hasAll="true" allMemberName="all_page_types" allMemberCaption="All Page Types" primaryKey="id">
  <Table name="npg_page_type_view" alias="pt">
  </Table>
  <Level name="Page Type" column="id" nameColumn="display_name" parentColumn="parent_id" nullParentValue="0" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" caption="Page Type">
    <Closure parentColumn="parent_id" childColumn="page_type_id">
      <Table name="dim_page_types_closure">
      </Table>
    </Closure>
  </Level>
</Hierarchy>

Now suppose i have 4 rows in npg_page_type_view table id display_name parent_id 19 HTML 100 20 PDF 100 21 XML 0 100 Total 0

Now suppose in my fact table i have following records id count 19 2 20 3 21 1

Following is my analysis view. Total (HTML and PDF) - 5 HTML - 2 PDF - 3 XML - 1

Now if i add filter(say Total) on this analysis view using OLAP cube. Then my analysis view shows the following.

Total (HTML and PDF) - 5

Upto this point everything works fine. Now if i click on 5 (to view drill through table) It shows me data against all page type i.e. HTML, PDF, XML but as per filter it should show only HTML and PDF.

Is it an exciting issue or am i doing something wrong here? Please help me.

ansaurus

tags:

views:

answers:

Drill through table does not show correct count when used with a dimension having parent child hierarchy and a filter on this dimension

related questions