Question:
Dear Fans,
I am new SAP BW user, I using SAP BW 3.0B. According to the help document SUMCT is one of the data function available in the calculated figure template used to total a key figure. The puzzling thing is ,
I cannot find this function on our BW 3.OB . I have got all other data functions except the RESULT function ie.SUMCT,SUMGT and SUMRT
Is this a basis problem.Please help?
Answer:
I think you make a mix between calculated key figure (infoprovider level) and formula (query level); the possibilities are not the same both side
Ch
Answer:
Thanks for the reply .. I could not be confused .. I do follow the same steps as instructed in the help manual. I open the Query designer ,select a new query ,click the key figure on the left hand side of the infoprovider menu.
then select new calculated key figure and a template is displayed. The template looks exactly as described in the manual except for the SUMCT
function..Please help.
I have done cut and paste of the help topic.
This topic is under Query Designer,,
Defining Calculated Key Figures
Use
You can recalculate the key figures of an InfoProvider for reuse in the Query Designer using formulas. Calculated key figures consist of formula definitions containing basic key figures, restricted key figures or precalculated key figures.
Procedure
Defining a New Calculated Key Figure
In the InfoProvider objects display frame, select Key Figure and from the context menu (right-mouse click), choose New Calculated Key Figure.
If a calculated key figure has already been defined for this InfoProvider, you can also select the Calculated Key Figures entry and, from the context menu, choose New Calculated Key Figure.
The New Calculated Key Figure dialog box appears.
The upper part of the screen contains a text field in which you enter a description of the calculated key figure.
You can use text variables in the description.
Beneath this is the input field for the formula that you want to use to calculated the key figure. The bottom left screen area contains all of the operands available for the formula definition. These are:
The basic key figures, calculated key figures and restricted key figures from the relevant InfoProvider.
All form variables
On the right-hand side of the screen, you see the functions that are available as operators:
Basic functions
Percentage functions
Data functions
------------------
Mathematical functions
Trigonometric functions
Boolean operators
when you click data function these operators are available..
Defining Calculated Key Figures
Use
You can recalculate the key figures of an InfoProvider for reuse in the Query Designer using formulas. Calculated key figures consist of formula definitions containing basic key figures, restricted key figures or precalculated key figures.
Procedure
Defining a New Calculated Key Figure
In the InfoProvider objects display frame, select Key Figure and from the context menu (right-mouse click), choose New Calculated Key Figure.
If a calculated key figure has already been defined for this InfoProvider, you can also select the Calculated Key Figures entry and, from the context menu, choose New Calculated Key Figure.
The New Calculated Key Figure dialog box appears.
The upper part of the screen contains a text field in which you enter a description of the calculated key figure.
You can use text variables in the description.
Beneath this is the input field for the formula that you want to use to calculated the key figure. The bottom left screen area contains all of the operands available for the formula definition. These are:
The basic key figures, calculated key figures and restricted key figures from the relevant InfoProvider.
All form variables
On the right-hand side of the screen, you see the functions that are available as operators:
Use
These are functions that you can use as operators for defining a formula or a calculated key figure.
Features
Value = 1 if operand <> 0, otherwise 0 (numerator)
COUNT(<Expression>)
Delivers the value 1 if the <Expression> is <> 0, otherwise 0.
Processing a Value as a Date
DATE
The value is seen as the number of days from 00.00.0000 onwards and output as a date.
The value can be between 0 and a million, which gives a date between 01.01.0000 and 27.11.2738.
Value = 1 if operand = 0, otherwise 0
DELTA(<Expression>)
Delivers the value 1 if the <Expression> is 0, otherwise 1.
The function is identical to the NOT operator and should no longer be used.
NDIV0 (x): Equals 0 when divided by 0, otherwise x
NDIV(<Expression>)
Is 0 if the calculation of <Expression> causes a division by 0. Otherwise, the result is the value of the expression. It is used to avoid error messages or so that you can continue to calculate a defined result.
Values without Dimensions (without Units)
NODIM(<Expression>)
Delivers purely numerical values of <Expression> and suppresses units and currencies.
Using this function, you can avoid the “mixed currency” character. See SAP Reference IMG ® Business Information Warehouse ® Reporting-relevant Settings ® General Reporting Settings ® Display of Numerical Values in the Business Explorer.
NOERR (x): Equals 0 for undefined calculations, otherwise x
NOERR(<Expression>)
Is 0 if the calculation of <Expression> leads to an arithmetical error. Otherwise, the result is the value of the expression. It is used to avoid error messages or so that you can continue to calculate a defined result.
NOERR(SQRT(-1)) = 0
Result
SUMCT <Operand>
Delivers the result of the operands to all rows or columns (see also Percentage Functions % CT).
Answer:
(I did not read anything of what you pasted)
Now, THINK.
What is SUMCT supposed to do as a calculation ?!
SUMCT is something like the total of your key figures for everything that has been retrieved by the query. If I retrieve 3 rows, it will add up the key figures for 3 rows and give you a total.
Now, WHEN do you think the system is able to know how many rows will be retrieved by the query ? at infoprovider level, before the query is run, or at query level, after all the needed rows have been retrieved ?!
stand back from your training material, and push "new formula" now ; look and go back to "calculated key figures" and see the differences.
Ch