I have a scenario where I need to <b>count the number of records</b> in the InfoCube data with one particular characteristic value (e.g. count records where CLEARING_AREA = 'CLRAR'). I have defined a key figure, which would always hold the value of 1. This constant of 1 comes from the Source System and is directly assigned to this KF.
I have defined this KF with Aggregation and Exception Aggregation values as 'Summation' but I guess the <b>type of KF I give is incorrect - with 'Number' and 'Integer', I am unable to do a summation</b> on this KF in the query designer; whereas I notice that with a payment amount KF with type 'Amount', I am able to do a summation in the Query Designer.
I have already <b>referred to an earlier post: Counter Key Figure, but it doesn't tell anything about the type of the KF to be given.
Request you to please help me out with this.
Thanks and Regards,