Solved

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

Posted on 2013-12-09
3
1,137 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
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.

832 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