let assume 100 values are showing in database but only 80 in report studio then what happens to 20 rows and what would be the cognos SQL and DB SQL in this case?
Quote from: khabaleshri on 26 Nov 2018 03:52:21 AM
let assume 100 values are showing in database but only 80 in report studio then what happens to 20 rows and what would be the cognos SQL and DB SQL in this case?
What do you see in the SQL? Is this an interview question?
Without knowing the particulars of your report it is difficult to say for certain. Does the report have a join or a filter that omits some of the database content? Does the report include facts as well as dimensions such that the fact data is aggregated for the level of detail dictated by the attributes?
Yes. this question came after usage property feature in FM.
As a generic question I'd guess that auto aggregation is the explanation. If all the elements are attributes then Cognos would do a select distinct. If some elements are attributes and some are facts then Cognos would use an aggregate function for all the facts and place all the attributes in a group by clause.