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?