I have the following sql statement :
select distinct col1, col2, col3 from tableName
I would like to make a list which shows the distinct combination of the above columns.
Can you suggest me how to do it.
I tried sth like this distinct col1 for col2 without any success.
Thanks in advance.
Are you using this SQL statement as a Query foundation in the Report Studio?
Did you try to create this report straight from a Package?
By default for non measure attributes Cognos Engine will generate a SQL like this:
select col1, col2, col3 from tableName
group by col1, col2, col3
No, I do not want to use it through an SQL object.
Also I do not want to create it through a package.
My source of the report is a package but I want to simulate the query statement
in a list through data items and query-calculations.
Is this possible in any way ?
Do not use distinct.
Are you using relational package?
Are all these fields dimensional attributes without any aggregation?