BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

YTD Runningsum() Issue


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
balachandarbe
Forum Member
Forum Member



Joined: 15 Sep 2008

Posts: 6



PostPosted: Mon Sep 15, 2008 1:15 pm 
Post subject: YTD Runningsum() Issue

Hi,

Can you help me for the below issues.

I am working on BO XI R2 and creating reports using Deski.

Currently I am displaying 2 weeks data with one measure object which will needs to calculate the projection value for the current and previous week data. I would like to calculate YTD for the projection(measures) for the current week, while applying the runningsum() function in the current week projection(measure), which is also get applying the previous week.

The wrong result which I am getting now,
Current week Previous week
Projection YTD
=Runningsum(Projection) Projection YTD
10 10 11 21
20 41 22 63
30 93 33 126


Expected result,
Current week Previous week
Projection YTD
=Runningsum(Projection) Projection YTD
10 10 11 11
20 30 22 33
30 60 33 66
Back to top
MichaelWelter
Forum Advocate
Forum Advocate



Joined: 08 Aug 2002
ASUG Icon
speaker.gif*6medal_bronze.gif
Posts: 15005
Location: Rancho Cucamonga, CA, USA, Earth, Milky Way


flag
PostPosted: Mon Sep 15, 2008 2:06 pm 
Post subject: Re: YTD Runningsum() Issue

Welcome to Bicon_mrgreen.gifB!

[Moderator Note: Moving from General Discussion to BusinessObjects Desktop - MichaelWelter]

_________________
Michael Welter, BOCP-BOE, Webi Image link
Independent BI Consultant
(909)899-3002

______________________
Follow me on Twitter

Latest Blog Posts
• 2019-02-22 Tableau Security Made Easy
• 2018-09-20 Hello, Tableau
• 2018-08-16 New Beginnings
Back to top
soni_ak
Principal Member
Principal Member



Joined: 15 Sep 2008

Posts: 141
Location: Mumbai


flag
PostPosted: Tue Sep 16, 2008 4:52 am 
Post subject: Re: YTD Runningsum() Issue

Hi,

are u using two different data providers for Current and Last week or single DP for both??
Back to top
balachandarbe
Forum Member
Forum Member



Joined: 15 Sep 2008

Posts: 6



PostPosted: Tue Sep 16, 2008 11:33 am 
Post subject: Re: YTD Runningsum() Issue

I am using only one data provider for Current and Last week for both.

Thanks for your reply.
Back to top
balachandarbe
Forum Member
Forum Member



Joined: 15 Sep 2008

Posts: 6



PostPosted: Tue Sep 16, 2008 1:08 pm 
Post subject: Re: YTD Runningsum() Issue

Hi,

As per the user requirement, we need to use single data provider to accomplish this report.

Please give me your feedback on this.

Thanks in advance.

Bala.K
Back to top
soni_ak
Principal Member
Principal Member



Joined: 15 Sep 2008

Posts: 141
Location: Mumbai


flag
PostPosted: Wed Sep 17, 2008 1:57 am 
Post subject: Re: YTD Runningsum() Issue

Hi,

As per my understanding, you are using Crosstab to show Current and Last Week data and RunningSum is applied on a single Measure Object that is why it is adding last and current week data together.

If this is the case then u can try to solve this issue by Resetting the value for RunningSum to zero for each Week. It can be done by following synatx-

=RunningSum(<Projecttion>;<Week_Name>)

where <Week_Name> is the Object that displays 'Current Week' or 'Last Week' based on the date.

Try it out and give ur feedback whether it works or not.
Back to top
MichaelWelter
Forum Advocate
Forum Advocate



Joined: 08 Aug 2002
ASUG Icon
speaker.gif*6medal_bronze.gif
Posts: 15005
Location: Rancho Cucamonga, CA, USA, Earth, Milky Way


flag
PostPosted: Wed Sep 17, 2008 8:57 am 
Post subject: Re: YTD Runningsum() Issue

soni_ak wrote:
Try it out and give ur feedback whether it works or not.

Please do not use Instant Message abbreviations on BOB. We want to keep BOB easy to understand for our International community. Thanks.

_________________
Michael Welter, BOCP-BOE, Webi Image link
Independent BI Consultant
(909)899-3002

______________________
Follow me on Twitter

Latest Blog Posts
• 2019-02-22 Tableau Security Made Easy
• 2018-09-20 Hello, Tableau
• 2018-08-16 New Beginnings
Back to top
balachandarbe
Forum Member
Forum Member



Joined: 15 Sep 2008

Posts: 6



PostPosted: Wed Sep 17, 2008 2:18 pm 
Post subject: Re: YTD Runningsum() Issue

Hi,

Thanks for your prompt reply. You are correct, I am using the same methodology to implementing the runningsum() on a single measure object.

But as per your suggestion, I have used the same syntax as.

=RunningSum(<Projecttion>;<Week_Name>)

But I am getting multivalue error. The below formula which I have used for 21st week & 22nd week.

=Runningsum(<Projection>;21)
=Runningsum(<Projection>;22)

Please let me know if you find any solution on this.

Thanks & Regards
Bala.K
Back to top
soni_ak
Principal Member
Principal Member



Joined: 15 Sep 2008

Posts: 141
Location: Mumbai


flag
PostPosted: Thu Sep 18, 2008 1:04 am 
Post subject: Re: YTD Runningsum() Issue

Hi,

Have you used Week_Object (for 21 and 22) in the report and apart from this, what other dimensions are u using.

for RunningSum, why are u using 2 different formulas
=Runningsum(<Projection>;21)
=Runningsum(<Projection>;22)

You need to create only 1 measure object having formula
=RunningSum(<Projecttion>;<Week_Object>)...It will reset sum based on value of Week_Object.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0323 seconds using 17 queries. (SQL 0.0034 Parse 0.0009 Other 0.0280)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo