cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Analyzer :In the calaculate result as Standard deviation and varience

Former Member
0 Kudos

Hi Guru's,

In the Bex analyzer after the report excution ,with thecontext menu on the result we will be getting calculate

result as if we drill down with this option,we will be getting number of options.In all these options

standard deviation and varience options will be coming can u excplain what for these are used.with some example.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

The question is not clear to me.

Can you be more specific?

Former Member
0 Kudos

Hi

What are the functions of Standard Deviation and Varience while calculating result as,after excution of report (In Excel Sheet).

k .

Former Member
0 Kudos

Hi,

Can any one explain how to make reporting on a master data?

Thanx in Advance.

Former Member
0 Kudos

Hi,

<i>What are the functions of Standard Deviation and Varience while calculating result as,after excution of report</i>

Take a look on the link:

http://help.sap.com/saphelp_bw32/helpdata/en/17/82853c2dc5c505e10000000a11405a/frameset.htm

<i>Can any one explain how to make reporting on a master data?</i>

Make sure that the characterstic is defined as Data target.(in Onfo object change screen-->masterdata tab page).

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi anil ,

Thanx for quick repsonse.

My question regarding standard deviation and varience has solved,but question regarding master data reporting was not yet solved ya I did that tick of cjeck mark by specifying Info area name.after that the info objects are coming in data target heading but when I tried to create an update rule after giving and infosource name it is thrwing an error like datasource by the name not maintained.

Former Member
0 Kudos

Hi,

Is the Communication structure in the active form? By the by what is the name of your master characterstic.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi,

Anil My result column contains 5,6,7,8 and 9 as a figures.

can u plz explain with this example how standard deviation and varience works.

Thanx in Advance.

Former Member
0 Kudos

Hi,

Standard deviation = SQRT (variance)

Variance = ( sum of all x² - (sum of all x)² / N) / (N-1) for N > 1 and notexist for N=1

so

variance= ((2536496481)-(56789) * (56789)/5)/4

= (255 - 245)/4 = 2.5

So Standard deviation = SQRT(2.5) = 1.5811

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Thanx a ton Mr.Anil.

It is crystal clear.

Thanx a lot.

Former Member
0 Kudos

Hi Anil,

Yes My communication structure is active.

Plz go through below diagnosis :

Diagnosis:

The data source is not active.

Procedure:

Create the data source in the Administrator Workbench and activate it.

Thanx in Advance.

Answers (0)