If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Fact Measures Summing automatically

Started by jthomas8946, 29 Sep 2011 06:33:25 AM

Previous topic - Next topic

jthomas8946

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!!

blom0344

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..

jthomas8946

You were correct. I recreated the datasource within Framework Manager and re-established my relationships and everything worked great.

Thanks so much!