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

Register | Login 

Streamline and extend SAP BusinessObjects software 
Streamline and extend SAP BusinessObjects software (Opens a new window)  

General Notice: No events within the next 45 days.

Avoid Duplicate row aggregation


 
Search this topic... | Search WebIntelligence XI... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Author Message
RUC
Forum Associate
Forum Associate



Joined: 03 May 2010
ASUG Icon
Posts: 993


flag
PostPosted: Mon Oct 24, 2011 4:55 pm 
Post subject: Avoid Duplicate row aggregation

Hi All,

What is the purpose of Avoid Duplicate row aggregation in the webi report level ??

What is the similar function in the Deski for the Avoid Duplicate row aggregation ???

_________________
Thanks
RUC
Back to top
Naresh Ganatra
Principal Member
Principal Member



Joined: 08 Apr 2004

Posts: 301
Location: Palo Alto, CA


flag
PostPosted: Mon Oct 24, 2011 5:44 pm 
Post subject: Re: Avoid Duplicate row aggregation

its basically to avoid the aggregation and display values even if they are duplciates


consider a table with 2 columns
say
Quarter / Country / Revenue
1 / USA / 10
2 / USA / 15
1 / CAN / 12
2 / CAN / 11

If you were to display only 2 columns in your report
Country / Revenue then you would get
USA / 25
CAN / 23

If you were to avoid duplciate row agg then you will see 4 rows with the values 10,15,12,11

I am assuming there are some posts about this already on the forum, try a quick search if you have not yet.

hope that helps !

_________________
Regards,
Naresh Ganatra
BI Engineer
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  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.0448 seconds using 17 queries. (SQL 0.0028 Parse 0.0351 Other 0.0069)
CCBot/2.0 (http://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