I'm using OBIEE 11.1.5. I have a hierarchy table which i want to display in the result of an analysis. I want to add a new table from the New View > Table. It's OK for now but i want to add different filters for each of the 2 tables. Is it possible? Right now if i add a filter - it's handled by both 2 tables. For example - Hierarchy table for products . In the first i want to show product category A and it's children, in the second - product category B with it's children associated.
SELECT saw_0, saw_1 FROM (
(SELECT Time."Year" saw_0, "#Sales" saw_1 FROM "SA1" WHERE Time."Year" = '2013')
(SELECT "- Open Date"."Open Year" saw_0, "-# Agreements" saw_1 FROM "SA2" WHERE "- Open Date"."Open Year" = '2013')) t1 ORDER BY saw_0
You may use button 'Combine with Similar Request' in criteria tab
Thanks for reply. I'm not sure if you understand me correctly. For example:
I have in a table values X, Y, Z. So i want in the result tab - 3 tables: The first one displays X values, the second displays Y values and the third - Z values. I'm not sure if with your proposal i'll solve the issue. In the result there must be 3 different tables/if we consider my example/. So is it possible to have 3 different WHERE clauses/filters/ associated to the tables:
1. Where <column> = 'X' for the 1st table
2. Where <column> = 'Y' for the 2nd table
3. Where <column> = 'Z' for the 3rd table
Sorry if your solution is correct for the relevant issue.
Using 1 report with 3 different views using 3 different filters I dont think we can do that. I'll keep check for any ones for possible way.
For these kind of requirements we got run time filters like Dashboard/Page/report prompts
In other way Instead of filters I would suggest to use Pivot table and pull the column in the sections, that would separate the view based on values... if you compromise with layout Pivot table is the good to go.
Btw: At first instance I was not clear with Table (db table or view as in answers) thats the reason I didnt responded.