How can I count the number of entries present for a characteristic

[Former Member]

Hi All,

Consider the problem:

I have a Characteristic : Store and a key figure : no. of stores.

I now want to calculate the no. of stores.

Please let me know if I can use EXCEPTION Aggregation here to calculate the no. of stores.

IF possible, please provide some docs or links to understand exception aggregation.

Thanks a lot in advance,

Punkuj.

[edwin_harpino]

dear Punkuj,

take a look

http://help.sap.com/saphelp_bw33/helpdata/en/6f/56853c08c7aa11e10000000a11405a/frameset.htm

http://help.sap.com/saphelp_bw33/helpdata/en/82/f2dc37f0f12313e10000009b38f8cf/frameset.htm

and how to count doc

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7e58e690-0201-0010-fd85-a2f...

hope this helps.

[Former Member]

hi punkuj

try this link

http://help.sap.com/saphelp_erp2005/helpdata/en/1a/615f64816311d38b170000e8284689/frameset.htm

hope this helps

regards

bwlearner

[Former Member]

Hi,

You can very well use the exception aggregation for couting the characteristics in BW.

You can count the no of stores for a particular period by setting the option in exception aggregation "count of values <>0" with the reference charcteristc as fiscper.

Hope this helps.

Regards,

K.Manikandan.