Solved

Having or something similar in webi report to only return counts greater than specified number

Posted on 2013-12-09
3
1,105 Views
Last Modified: 2013-12-10
I'm new to webi and trying to use Having or something similar so a report only shows locations with 6 or more tickets opened against in the past 60 days.
In the query builder I brought in my needed objects and a filter for tickets created in the past 60 days. Now, When I'm building the actual report I can add a column that counts tickets by location, which is the first column and the count is the second column.
It is counting correctly, but I am trying to only pull in rows (locations) that have had 6 or more tickets opened in the past 60 days.
I've always used crystal reports or sql with command object, but not sure how to do it in webi. Its seems it has to be possible without a change to the universe. Any assistance would be greatly appreciated.
Currently getting something like this
Location      Cnt
balitmore         8
seattle              4
Las Vegas         7
Woodland        3
Albany              6
kalamazoo        2

But want this:

Location      Cnt
balitmore          8
Las Vegas          7
Albany               6
San Fran            2
0
Comment
Question by:van-coug
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39708537
You can build a filter with a prompt into the universe along with the count object or you can use a report or block filter in WebI.

In WebI
  In the toolbars to the left of the fx there is a filtering icon.  It has a FUNNEL on it.
CLick the filter icon
IN the  new space that appears add your filter.
If you want it on the entire report click an area on the report like the report header
If you want it on a specific block or section click in the block or section
Drag your count object into the area
Set the filter

mlmcc
0
 

Author Closing Comment

by:van-coug
ID: 39709415
Thanks mlmcc! Much appreciated!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now