key figure: nr of users

Question: Hi,
this looked simple to us, but wasn't eventually: in my statistics report, I have Calender day, user and nr of navigations. If on september 1st, 14 users used BW, I see 14 records. When I do a count on my totals, I also see 14.
For reasons to put this in a graph, I want to have this count on a key figure. So I want to see only 2 columns in my report: Calender day and the new key figure/ variable. We're spending already a lot of time in creating calc and restr key figures and structures, but no result.
Any help?

Kind regrds,
G.

Answer:
Have a look at the How to..Count occurances.PDF file on sapnet it may give you what you want.

you can get to it here:

https://websmp203.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000277675&

Answer:
Hi, tanx for the reply Avanie. That will work!

Answer:
Avanie:
I went to the SAP support site using the link you provided, and could not find the 'How to ... Count occurances ...' file.

Are you certain this file is accessible via this link ?
Perhaps it's been removed since your post on Sept. 15 ?
Is there an alternate way to access this file ?

Answer:
search in sapnet-BW, under BW Infoindex->Counting-> How to count the occurrences....regards, bw_2201

Answer:
you have to look under How To for BW 2.1

G.
Copyright ?2007 - 2008 www.jt77.com