Hello You can lookup fragmentation. Usually, we use fragmentation to implement UNION ALL in the right business scenarios. However, the grandmasters above have already asked you the right questions. These are the questions that you should always ask before implementing complex scenarios such as above. I don't believe…

Hi Think about it you are doing a distinct on measure column. You have data like India 100 Usa 100 China 200 Australia 200 Then you are just doing a distinct on measure which doesn't make sense you are treating measure as a dim attr which is something not unheard of but then you are trying to measure it again. Filter…

Hi Is this similar to BICS Oac setup. If yes, then i i know a couple of ways where you can access the objects using admin tool. Let me know if its the same thing and i will post the steps down below. Thanks Vipul

Hi just trying to understand this basically you have a date column and workflow step is based on date. So basically your requirement is something of the sort Count over (partitio by some column order by some column) If you can create a case when logic and then create one measure column on report criteria that calculates…

Hi Gianni We actually implemeted the exact same logic actually with a report using SA subject area approach to send a filtered report to a number of users that were external to obiee.

well you need to certainly learn a lot about obiee. Having said that its not that difficult. so from the text above i assume you have these question: why do u need logical join when you already have physical joins? whats the significance of multiple logical tables sources. so lets say you have a city table and a state…