Measure Objects Doubling when creating reports

[rajua99]

Hello,

In your framework all the Amount fields are measure objects where the Regular Aggregate is Sum under properties. When we are testing all the values for measure objects are 2 to 3 times more.

In the report studio when we change the Aggregate Function from Total to None then we are getting the right values.

We are not sure why the measure objects are 2 to 3 times more...

we are totally confused why the measure objects are doubling up when we create reports...

Please help how to resolve this issue in framework manager so that our users no need to change the properties for each measure objects...

Thanks
Raju

[wyconian]

Hi

It sounds like you've got some duplication of data or you're missing a column that makes each row unique.  Try taking off the auto group aggregate on the query.  If you see what looks like duplicated records try adding other columns until the records are unique.

It may be that the data is at a lower level of granularity, if that is what's happeing you should look at making the relationships in the model stronger or maybe look at determinants to roll the data up.

Let me know what you find.

Good luck :-)

[rajua99]

Hi

It sounds like you've got some duplication of data or you're missing a column that makes each row unique.  Try taking off the auto group aggregate on the query.  If you see what looks like duplicated records try adding other columns until the records are unique.

It may be that the data is at a lower level of granularity, if that is what's happeing you should look at making the relationships in the model stronger or maybe look at determinants to roll the data up.

Let me know what you find.

Good luck :-)

In the database we are having only 1 row in both tables when we do the filter on...when i remove the auto group aggregate i can see 2 rows and both are identical. I added all the objects from both tables still both are same.

We are not using any determinants in the framework for those 2 tables and also i added the joins for all the common objects from both tables.....

somehow i am still missing how to resolve this issue....

[CognosPaul]

Do you have more fields in the table than you're referencing in the model?

[rajua99]

Do you have more fields in the table than you're referencing in the model?

No, All the fields in the table are referencing in the model except the common fields....

[CognosPaul]

What do you mean common fields?

If you're joining two tables, put all of the fields from both tables into the list. Then run it. Is it possible the data in one of the tables is duplicated? Is there an index on both tables?