GROUP BY clause is not uner SQL anymore!

[iren]

I am in a big trouble trying to implement a query anD completed the following steps:

Step 1
Under tab DATA I have the following fields:
Product
CPT_CD
CPT_DESC
Gender
Mem_birth_dt

Step 2
I select additional field int_clm_num and press Z button. After that I chose Aggregation function COUNT
On the right panel I see count Int-clm_num[for Mem_birth_dt]


Step 3
I go to the Filter tab and put condition:
Product=’M’ AND Frst_dt_month in 200701 and CPT_CD=”1234” AND mem-birth_d t< 1941-12-12

When I opened tab PROFILE and chose option SQL , I am able to see SQL with WHERE clause with filter stuff and
BY GROUP clause which all fields from DATA tab included

However when I run query in Cgnos Impromtu nothing happens.
Moreover…when I open query , GO TO TAB PROFILE and chose option SQL I DO NOT SEE BY GROUP clause anymore!

What I am doing wrong????? Could you please give me a hand? This is an urgent issue

Thank you in advance,

Iren

 

[CognosProfessional]

Can you see the group tab when you go to the profile tab? Can you group there?

CP

 

[JetKay]

don't go to the profile with out running the report..