Calendar & Fiscal Hiearchies with Monthly targets


  • I have day level sales data and monthly targets which I am trying to show across a date dimension with Calendar and Fiscal Hierarchies which have a 3 month difference between them. The Sales data slices by both the hierarchies because it is at the most granular level of the date dimension. But the Targets are monthly and work across either Calendar or Fiscal hierarchy but not both depending upon how I associate them in the 'Dimension Usage' Tab.

    Is it possible for the targets to work across both the hierarchies. If yes, then what should be the granularity attribute between Targets and Date Dim?  Is there anything that needs to be set in attribute relationship in date dimension for this?

    Thanks, Ashish Singh

    Saturday, October 05, 2013 12:41 PM