Question:
HI..
I have CREATED BY and NOTIFICATION NUMBER in my infocube , now in my query on this infocube I want to see the created by name and total number of notifications created by that person... how do i achieve this ????
Thanx in advance ..
Simmi
Answer:
hey all BW Masters.. help me out please coz this is very very very urgent !!!!
Simmi
Answer:
you have to create a formula variable with replacement path on the notification number that you will use as a counter (use output as Boolean for this..)
I know this not the "everyhting nice on your plate" answer you're looking for, but it should get you started. Use the terms to search on this forum and certainly on http://help.sap.com to get you more info)
Answer:
Ya I did try working on it but my Notification number is a non numeric field and formula variable requires a numeric field !!!!
Simmi
Answer:
look for document HowToCountOccurences in service.sap.com/bw
Answer:
but my Notification number is a non numeric field and formula variable requires a numeric field !!!!
Simmi
if you have it as processing type "replacementh path", you can fill the formula variable in with a charcterisitc value.
And like i said, you would not use the actual notififcation number, but just use a boolean operator (1 or 0) to count the number of notifications