ODS query

[Former Member]

Hi I have this following requirement :

I have a ODS with following data

Field1 Field2 date

x x1 5292008

x x1 5292008

x x2 5292008

y y1 5292008

y y1 5292008

My report is designed like below

field1 field2 cal/month

x x1 may2008

x x2 may 2008

y y1 may2008

now for the above report I want to add a column Field3. Field3 displays count of each unique field2 value/per month. the report should look like below

field1 field2 cal/month field3

x x1 may2008 2

x x2 may 2008 1

y y1 may2008 2

can you suggest me a way to count total occurence of a field/month in the ODS and display that in the query. Is it possible at Query level??

[Former Member]

Apart from the above solution, you can create a char. in the DSO and assign the constant value 1. Bring this in your report.

For, X and X1, choose "display result always". It will give you the number of counts.

Thanks...

Shambhu

[Former Member]

hi,

yes ,possible,

create a CKF and assign the value for it as 1.

create an RKF and restrict the created CKF with the calmonth characteristics.

hide the CKF in its property and display only the RKF

Ramesh