JPCogAdmin
Programmer
Hi,
I'm working on Cognos 8 and windows env.
I have 3 tables. One of them is the facts table
and the one of the 2 other tables has records I need to count. The problem is that I don't know how to count
the table records when these have a relationship of one-to-many. I have have it like this:
Table1 has a one-to-many relationship to fact1
table2 has a many-to-many relationship to fact1
I need to cound the records on table1 that match in some criteria way to fact1 and to table2, I need to do that in Cognos either Framework Manager or Report Studio?
In pure SQL I can easly do something like this:
select count ( distinct field ) from table1, fact, table2
where ( I involve my tables cretia here)
I get the results.
If you have had this kind of challenge before or know how to do the count please let me know. Thanks.
_j
I'm working on Cognos 8 and windows env.
I have 3 tables. One of them is the facts table
and the one of the 2 other tables has records I need to count. The problem is that I don't know how to count
the table records when these have a relationship of one-to-many. I have have it like this:
Table1 has a one-to-many relationship to fact1
table2 has a many-to-many relationship to fact1
I need to cound the records on table1 that match in some criteria way to fact1 and to table2, I need to do that in Cognos either Framework Manager or Report Studio?
In pure SQL I can easly do something like this:
select count ( distinct field ) from table1, fact, table2
where ( I involve my tables cretia here)
I get the results.
If you have had this kind of challenge before or know how to do the count please let me know. Thanks.
_j