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.

Only Show Records of Minimum In Object


 
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
jeffreyrdubois
Forum Member
Forum Member



Joined: 05 Jul 2018

Posts: 12



PostPosted: Fri Nov 30, 2018 8:55 am 
Post subject: Only Show Records of Minimum In Object

I have the data similar to the following that I am pulling into WEBI

Inside each "Group" Denoted by 'Group Number' are at least 1 item. The item with the lowest number is the primary item for that group.

I want to create a stacked bar chart showing how many "A's" and "B's" there are, but I only want to display those that are Primary Items (Lowest Item Number in Group Number)

I tried to create two objects

Primary Item
=Min([Item Number]) In ([Group Number])

Primary Item Indicator
=If([Item Number]=[Primary Item] ; "Y" ; "N")

And then my plan was to filter my stacked bar chart (which currently displays every item) by "Primary Item Indicator = 'Y' "

But when I do this all I get is an empty bar chart.
What am I doing wrong?

Thanks!
Back to top
anil.ganga1
Principal Member
Principal Member



Joined: 04 Jul 2007
ASUG Icon
Posts: 470
Location: San Francisco


flag
PostPosted: Thu Dec 06, 2018 4:56 pm 
Post subject: Re: Only Show Records of Minimum In Object

I couldn't verify this, but Instead "In" try "For Each" and see?
_________________
Thanks,
Anil.

Business Objects 6.5/XIR2/3.X/4.X
Crystal Reports 9/XI/XIR2/XIR2A/2008/2011/2013/2016
Back to top
CSM07
Forum Member
Forum Member



Joined: 15 Nov 2016
ASUG Icon
Posts: 8



PostPosted: Mon Dec 10, 2018 2:49 am 
Post subject: Re: Only Show Records of Minimum In Object

How exactly are you filtering it?Are you selecting it or entering it manually?If your object 'Primary Item Indicator' is a measure then convert it into a dimension object.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11131
Location: Manchester, UK


flag
PostPosted: Mon Dec 10, 2018 9:57 am 
Post subject: Re: Only Show Records of Minimum In Object

1. Create a copy variable of Item Number as a Measure.

2. Now use the ranking functionality to rank within Group on Item Number Measure (or whatever you called your variable in step 1) and keep the bottom 1.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
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.0302 seconds using 17 queries. (SQL 0.0029 Parse 0.0009 Other 0.0264)
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