Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Filter on one fact table not affecting second fact table in analysis?

Hello,
I am creating an analysis with two fact tables (Sales and Inventory) and one conformed dimension (product).
In my analysis, I filtered the Sales fact table with sales_amount > 10. This filter displays only products with sales_amount > 10.
Now, I noticed that in the Grand Total of my table view, the Inventory measures are summing up for ALL products. I want the inventory measures to also be filtered to Products where sales_amount > 10.
I noticed that BI server is splitting up the query in 2. On query to the sales, the other to Inventory. How can I force the BI server to write a single query so that my filter is applied to the second fact table?
Thank you,
Answers
-
Hello,
Try this:
1. Create a UNION reports with oracle BI Answers
OBIEE - Reporting on Multiple Subject Area (Advanced Logical SQL) [Gerardnico]
2. Apply your filters by each "CRITERIA"
3. You could use a pivot table / table / graph.
Kind Regards,
0 -
Thanks, but there is no filter for my second Fact Table (inventory).
The logic is:
1. I filter my first fact table (sales amount > 10)
2. My Dimension will automatically be filtered to only products that have sales > 10 through the join with the fact table.
3. My second fact table should be filtered for only the products in my dimension through the join.
The problem is, obiee writes 2 independent queries, so my second fact table is not filtered at all and is displaying measures for ALL products.
Thanks,
0 -
Hello,
1. Yes, but if you want do this, you have to create a join/complex join between two fact tables ( sales / inventory), if you dont have this relationship between your both fact, OBIEE dont know how to create the query to hit the database and dont take the filter (sales>10) that you want, for that reason, obiee right now, create two queries, check your model in your RPD.
2. In other hand , Create your UNION criterias in BI Answers ,and make your filter based on ADVANCED SQL FILTER do a LOGICAL QUERY to FILTER YOUR INVENTORY BASED in your SALES RESULTS
Kind Regards,
0 -
Selection steps with "Keep Only" on Product dimension where "Sales Amount > 10".
0