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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.