Home > Business objects Web Intelligence > Rolling calculations in web intelligence by row wise

Rolling calculations in web intelligence by row wise


In webi  we can calculate the rolling sum by using two functions as per my knowledge,

In the following example, i have used efashion  sample universe from Business Objects

They are RunningSum() and Previous(self) functions

while using RunningSum() function we have three arguments in this, which is RunningSum([Measure];Row|Col;([Reset Dimension]))

here we can control the flow of calculation by row using second argument (Row|Col)

=RunningSum([Sales revenue];Row;([Year]))

img1

the alternate way of doing the same is by using Previous(self) function

by

=[Sales revenue]+Previous(Self)

img2

there also should be some other way to achieve this one using formula.

if you find any,  share it here >….

Advertisements
  1. January 17, 2013 at 1:30 am

    I definitely wanted to compose a message in order to say thanks to you for all
    of the wonderful instructions you are giving here. My extended internet look up
    has at the end of the day been rewarded with
    extremely good knowledge to talk about with my family and friends.

    I would suppose that we site visitors actually are rather lucky to exist in a remarkable community with so many perfect individuals with
    interesting methods. I feel really privileged to have
    used your web pages and look forward to so many more brilliant times reading here.

    Thanks a lot again for a lot of things.

    Like

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: