Answering my own question, I have put both in the same Logical Table Source. What tells if the "Original Sales Transaction" alias table will be included in the query is the direction of the join arrow. As soon as I changed it, the alias table did not get included when not necessary. Joao

Yes, let me clarify. If the user creates a report Sales by Week, in the RPD I want to limit the result set using a WHERE statement in the LTS fact table by Week, aggregated at Week Level < sysdate. If the user creates a report Sales by Year, in the RPD I want to limit the result set using a WHERE statement in the LTS fact…

I thought about using concatenate to unite the two columns, but it is indeed an ugly solution. Andrew, thats exactly what I need. I tried doing that using OBIEE 11.1.1.1.7 but I keep getting an error. Maybe it is a new feature for 12c? Anyway, I will try it again, maybe I missed the parenthesis. Thanks!

I can not have the values hard coded. I need to filters the values brought from a sub-query. Store Number, Product Number in (select Store Number, Product Number from Sales where Amount > 10) So your solution doesn't apply in my case..

I have had this same problem before. Indeed, it is not displaying in the line chart for certain months because the data simply doesnt exist. What I did was to create a Direct Database Request in OBIEE, and I wrote a query based on a timeline (I used my Time dimension), and for each month, make a case to check for data,…

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…

Thanks, but I need to filter both values at the same time. In regular SQL, this would be something like: Select * from table1 where (prod_num, store_num) in ((prod1,store1),(prod1,store2)); Note that this is different from the example you gave me: Select * from table1 where prod_num in (prod1) AND store_num in…

Thank you! It worked after setting the Levels tab for my Store Count measure to Total in all dimensions except Dim Location.

Hello, thanks for answering. Nope I don't need a count over time. I just need to filter my sales for a specific year in the same analysis. As soon as I add the Year=2016 filter, my Store Count measure disappears I have the same problem as obiee_kid in this old thread: OBIEE - How to get count of members for a level? Even…

Thank you Thomas, it worked. But I soon as I add another dimension to my analysis (ex Time), the Store Count is null because I get "None of the fact tables are compatible with the query request Store Count". In other words, my new Fact "Location" is not joined to Dim Time. Does it make sense to join it in the logical layer?