Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: how to create metadata abount fact tables of different granularities

  1. #1
    Join Date
    May 2012
    Posts
    1

    Default how to create metadata abount fact tables of different granularities

    hi, There are two facts of different granularities(say one measured at the day level, another at the year level) . I create the metadata as But when I select the year's Store Cost and Store Sales from VirtualCube , the Store Sales will multiple be repeated. Because the Store Sales's query sql is like as: select the_year , sum(store_sales) from sales_fact_year a, time_by_day b where a.the_year= b.the_year group by the_year My question is how to create the metadata?

  2. #2
    Join Date
    Apr 2009
    Posts
    337

    Default

    Regards,
    Madhu

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.