Testing Result only 1 row

[scoebke]

For testing result of a querry item i only get one row back.
While the count rows gives back 13.

What I'm doing wrong?

Number of records retrieving is set to 100 or no restriction in options.
There are no filters or security set up.

We connect to mysql with ODBC connection?

Do I overlook something.

Kind regards
   Scoebke

[blom0344]

Should depend on the query definition. If no measures (facts) are involved, then Cognos automatically adds a 'distinct' clause to ensure a unique combination of dataitems. Check the SQL that cognos proposes to use in the execution..

[scoebke]

Thxs for suggestion.

I've 13 different rows.
I also isolated the table is seperate project, same result.
I tested the odbc connection in excell i retrieve 13 rows.

It looks like FM only use the first row from the querry.

I will see if i can retrieve back in MYSQL database which querry he takes. (not my specialty but okay)
SQL in cognos FM is correct and gives result.

Kind Regards
  Scoebke

[blom0344]

When you run the tabular query , do you get 1 row or 13?

[scoebke]

f.e. select `park_group`.`park_id` as "park_id" , `park_group`.`group_id` as "group_id" from `park_group` `park_group`

I got the 13 rows retrieved.

In report studio also one row retrieved.

[blom0344]

Yes, but what are you testing?  The rows as collection of dataitems or a single dataitem? Are you testing from within FM or from within a report?

[scoebke]

I'm testing both now.

I'm testing in FM
and open the data item what refers to a complete table in MYSQL.
and then i want to test this item

Kind regards
  Scoebke

[scoebke]

Is solved now.

What was the problem.
The MYSQL ODBC i used ODBC  3.51 driver was not working.
Upgrade to ODBC 5.1 gives better result.

Thanks for looking.

Kind regards
   Scoebke