Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Data not fetched for children for parent-child relation.

  1. #1
    Join Date
    Aug 2011
    Posts
    6

    Default Data not fetched for children for parent-child relation.

    I have measure in slicer, time in rows and mu (parent-child relation) in columns. Data is displayed in jpivot. When data is drilled down no data is shown for children though aggregations are right. MDX query executed is:
    select Hierarchize({[Time].[2011]}) ON COLUMNS,
    Hierarchize(Union(Union({[MU DIM].[All MUS]}, [MU DIM].[All MUS].Children), [MU DIM].[MU1].Children)) ON ROWS
    from [Readings]
    where [Measures].[ReadingMeas]

    sql queries executed are:
    select
    `agg_c_10_a_mu_param_numeric_readings`.`the_year` as `c0`, sum(`agg_c_10_a_mu_param_numeric_readings`.`reading`) as `m0`
    from
    `agg_c_10_a_mu_param_numeric_readings` as `agg_c_10_a_mu_param_numeric_readings` where `agg_c_10_a_mu_param_numeric_readings`.`the_year` = 2011 group by `agg_c_10_a_mu_param_numeric_readings`.`the_year`

    select
    `time_by_hour`.`the_year` as `c0`,
    `a_mus_closure`.`parent_id` as `c1`,
    sum(`a_mu_param_numeric_readings`.`reading`) as `m0`
    from
    `time_by_hour` as `time_by_hour`,
    `a_mu_param_numeric_readings` as `a_mu_param_numeric_readings`,
    `a_mus_closure` as `a_mus_closure`
    where
    `a_mu_param_numeric_readings`.`time_id` = `time_by_hour`.`time_id` and `time_by_hour`.`the_year` = 2011 and
    `a_mu_param_numeric_readings`.`mu_id` = `a_mus_closure`.`mu_id`
    group by
    `time_by_hour`.`the_year`,
    `a_mus_closure`.`parent_id`

    The hierarchies are displayed properly though.

    Is this a bug or something wrong in the mdx query.

  2. #2
    Join Date
    Aug 2011
    Posts
    6

    Default

    It was my fault. The closure table had missing entries for distance 0.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.