I have a problem that I can't seem to find an answer to. I am attempting to use an FM package to populate a scorecard via Metric Designer. Everything was working fine until I updated the table to pull in more metric data within Framework Manager. When I attempt to view the values in Metric Studio, it sorts by date but totals all the values and puts the total value in for each date.
Example:
5/1/2010 4550
5/2/2010 4550
etc...
What I have done and ended up with the same result:
*Set Aggregate Function with Metric Designer to None
*Recreated the Metric Extract
*Recareated the Import Source
This all leads me back to the Framework Package.
Does anyone have any idea's?
Thanks in advance!!
Yes, for some reason the query underneath is split and probably rejoined without the date in the join definition. You need to look into the model itself ,cause you are probably experiencing unwanted multi-fact solution..
You were correct. I recreated the datasource within Framework Manager and re-established my relationships and everything worked great.
Thanks so much!