Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: mondrian empty result

  1. #1
    Join Date
    Jan 2013
    Posts
    7

    Default mondrian empty result

    Hi,

    I have a trouble with mondrian. I have a database, scheme for mondrian and saiku plugin in pentaho BI. Then mondrian generate some SQL, it returns 0 rows, while this sql is ok and return thousands rows.

    Name:  9.jpg
Views: 27
Size:  35.3 KB
    this is OK with first dimension, no filters

    Name:  8.jpg
Views: 21
Size:  39.4 KB
    this is OK with second dimension, no filters

    Name:  7.jpg
Views: 22
Size:  31.2 KB
    this is not work!!! Both dimensions, no filters

    Here some log information from mondrian_sql.log about this:
    Code:
    2013-11-19 00:02:19,712 DEBUG [mondrian.sql] 19: Segment.load: executing sql [select `time`.`year` as `c0`, `time`.`month_string` as `c1`, `v_client`.`client_name` as `c2`, `v_sku`.`manufacturer_name` as `c3`, `v_sku`.`brand_name` as `c4`, `v_sku`.`product_line_name` as `c5`, sum(`sales_cube`.`quantity`) as `m0`, sum(`sales_cube`.`amount`) as `m1` from (Select t.id, t.day, t.day_str, t.month,year, t.month_string from (select distinct time_key from maxxium_reports.sales_cube) s inner join maxxium_reports.time_dim t on s.time_key=t.id) as `time`, `sales_cube` as `sales_cube`, `v_client` as `v_client`, `v_sku` as `v_sku` where `sales_cube`.`time_key` = `time`.`id` and `time`.`year` = 2013 and `time`.`month_string` = 'Август' and `sales_cube`.`retail_outlet_key` = `v_client`.`dim_key` and `sales_cube`.`SKU_key` = `v_sku`.`dim_key` group by `time`.`year`, `time`.`month_string`, `v_client`.`client_name`, `v_sku`.`manufacturer_name`, `v_sku`.`brand_name`, `v_sku`.`product_line_name`]
    2013-11-19 00:02:19,974 DEBUG [mondrian.sql] 19: , exec 260 ms
    2013-11-19 00:02:19,975 DEBUG [mondrian.sql] 19: , exec+fetch 263 ms, 0 rows
    Here the database dump and xml schema:
    maxxium_dw.xml
    database.zip

    Where should I look with this problem? Can anyone explain what is wrong here?
    Last edited by anteastra; 12-11-2013 at 03:08 AM.

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.