Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Report Studio - Select Distinct
- Thread starter UcfMike
- Start date
- Thread starter
- #2
I do not think that that is the whole story.
When I select only identifiers and attributes (no facts), then the SQL generated is automatically fetched as a distinct set. From a rollup reporting perspective this would be the sensible thing to do, cause I would be interested in the unique combinations that make up the set and not the complete recordset from the database.
Actually this was not covered in the fasttrack course in any way, so perhaps one of the forum guru's could shed some light on how the defaults are set.
Ties Blom
When I select only identifiers and attributes (no facts), then the SQL generated is automatically fetched as a distinct set. From a rollup reporting perspective this would be the sensible thing to do, cause I would be interested in the unique combinations that make up the set and not the complete recordset from the database.
Actually this was not covered in the fasttrack course in any way, so perhaps one of the forum guru's could shed some light on how the defaults are set.
Ties Blom
- Thread starter
- #4
Well, modelling was part of the framework section of the fasttrack course. So, basically we spend a couple of hours on how Cognos expects data to be modelled.
The real problem is that the Cognos course takes a datamodel that matches the best practice very nicely. Real world data structures are a little bit more complex.
Ties Blom
The real problem is that the Cognos course takes a datamodel that matches the best practice very nicely. Real world data structures are a little bit more complex.
Ties Blom
- Status
Similar threads
- Locked
- Question
- Locked
- Question