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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

YTD Calc


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



Joined: 13 Feb 2008

Posts: 184


flag
PostPosted: Wed Sep 01, 2010 10:21 am 
Post subject: YTD Calc

Hi All

I have got a crosstab report which is showing the Metric data for the last 12 weeks (starting from the Current week to the previos 11 Weeks) and in the table i also need to show the data for the YTD(Starting from the 1st week to the Current Week).

Now the issue is the Past 12 weeks data is showing fine. But, when i pull the YTD Calc(built from a separate DP) in the Report Footer of the Cross Tab it is jost aggregating the values of the last 12 weeks which is not correct as there is also data beyind that.
Can anyone help me on this. banghead.gif

_________________
Regards
Chetan
Back to top
mhy_pie03
Principal Member
Principal Member



Joined: 05 Feb 2009

Posts: 107
Location: Philippines


flag
PostPosted: Fri Sep 03, 2010 3:25 am 
Post subject: Re: YTD Calc

How did you get the past 12 weeks?
_________________
~Lovely Mhy~
Back to top
SteveD
Principal Member
Principal Member



Joined: 02 Nov 2009
ASUG Icon
Posts: 353
Location: Scarborough, North Yorkshire, UK


flag
PostPosted: Fri Sep 03, 2010 10:50 am 
Post subject: Re: YTD Calc

Are your queries joined - if they need to be if you're dropping the value in a report footer. Also - have you wrapped the formula in the footer in nofilter() to ensure it calculates for all dates?
Back to top
chetan.mudike
Principal Member
Principal Member



Joined: 13 Feb 2008

Posts: 184


flag
PostPosted: Sun Sep 05, 2010 6:42 am 
Post subject: Re: YTD Calc

mhy_pie03 wrote:
How did you get the past 12 weeks?


i have got it from a separate Data Provider which gets the Week Numbers from the Date Dimension. and the Metrics for the YTD is taken from a different Data Provider again

_________________
Regards
Chetan
Back to top
divyaprashanth
Senior Member
Senior Member



Joined: 04 Sep 2010

Posts: 38


flag
PostPosted: Sun Sep 05, 2010 6:48 am 
Post subject: Re: YTD Calc

Check if the two query dimensions are Merged? If they are then remove the merge dimension.
Back to top
chetan.mudike
Principal Member
Principal Member



Joined: 13 Feb 2008

Posts: 184


flag
PostPosted: Sun Sep 05, 2010 8:41 am 
Post subject: Re: YTD Calc

Hey Steve

The solution that you provided to apply the nofilter() worked and i am getting the right values now.

Thanks a ton!!

_________________
Regards
Chetan
Back to top
SteveD
Principal Member
Principal Member



Joined: 02 Nov 2009
ASUG Icon
Posts: 353
Location: Scarborough, North Yorkshire, UK


flag
PostPosted: Mon Sep 06, 2010 2:30 am 
Post subject: Re: YTD Calc

No problem icon_biggrin.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web 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.0295 seconds using 17 queries. (SQL 0.0031 Parse 0.0009 Other 0.0254)
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