Hiding unwanted Rows in Webi Report

[vipul20044]

Hi,

I have already gone through Forum Topics to some extent but couldn't find much.

Is there a way in Webi, to hide unwanted rows (say, I do have a column on which I want to hide these rows). Suppose, Column value is -1 and what I want is If I can place a filter based on this coulmn so, that I can hide a row/.

I did achieve a solution by hard-coded SQL but it is against the Best practices (Suppose if user dragds drops another object then SQL will change).

Please advise a best possible solution.

Thanks

 

[skrandel]

This is basic funcionality. You could either do this in the query with a condition or on a report with a filter.

Filters have the ability to do all the operators. Not sure what the problem is. Just don't try to filter the column. Filter the block and it will be obvious.

Steve Krandel
Intuit

 

[vipul20044]

Hi,

Thank you for your inputs.

The situation is different now.

The user report is some what like this:

1) The default universe SQL is bringing data in the following format:

Agent Name - Company Name - hours worked - Total Hours
---------------------------------------------------------------------------
X - XYZ - 12 - 24
X - XYZ - 13 - 3
Y - ABC - 4 - 5

2) The report has some calculated fields (which is the actual display we need) and brings Max of above rows for each Agent.
Currently, Report is displaying the following results (Universe SQL results + calculated results):

Agent Name - Company Name - hours worked - Total Hours
---------------------------------------------------------------------------
X - XYZ - 12 - 24
X - XYZ - 13 - 3
X - XYZ - 13 - 24
Y - ABC - 4 - 5
Y - ABC - 4 - 5

3) So, I would like to suppress the default SQL result in report and display only calculated result values:

Agent Name - Company Name - hours worked - Total Hours
---------------------------------------------------------------------------
X - XYZ - 13 - 24
Y - ABC - 4 - 5

Its bit confusing for me, but appreciate your urgent help on this issue please.

Thanks
Sam

 

[skrandel]

Without knowing the calculations, it's impossible to guess. Seems like basic variables would do it. Max() for each of your measures would do exactly what you want. You can do this in the report or do it in the universe.

Steve Krandel
Intuit