See -> https://docs.oracle.com/middleware/12211/biee/BIEMG/GUID-9BA0DED0-83DD-4326-82E5-4A607B75952A.htm#hpp_l_advanced If your relationship is as simple as you describe I would expect (for it to work); - Fact 1 - relationship to dimension 1 set to detail Dimension 1 - has a dimension hierarchy with a minimum of total…

Can you also show us the physical joins? Can you also show what has been modelled on the dimension hierarchies in question and the settings on the table source for the fact / dimension relationships in question?

On testing you might want to look to the advanced tab and clear the option that uses cache, it can save a lot of this kind of pain.

See - > https://biproducts.wordpress.com/2013/05/24/how-to-exportimport-the-foldersreports-from-one-envirornment-to-another/

Two options, either use the bins functionality or write a case statement by invoking function on the column. https://oraclebizint.wordpress.com/2007/12/05/oracle-bi-ee-101332-bins-and-groups/ http://shikha17.blogspot.com/2015/10/using-case-statement-obiee-11g.html With current non-binary gender alignments you probably also…

You might also consider using the filter function; - https://datacadamia.com/dat/obiee/obips/filter_function

Hi Joe, your immediate need might be what you describe but what Gianni / Joel are pointing you to is one of the cornerstones. A sound time hierarchy begets so much useful functionality; - - Time based measures; Ago, Period Rolling, Total To ...Month / Quarter, Year - Time based drills - Alternative hierarchies - Fiscal…

re: Joel's suggestion see -> http://onlyobi.blogspot.com/2013/07/create-date-dimension-using-sql.html

One possible solution for you, if you have access to create DB objects is to create a view and a trigger on the view. https://www.oracletutorial.com/plsql-tutorial/oracle-instead-of-triggers/ Then use the view / trigger combination as an API to handle your multiple update logic. If the straight update with a single…

Your issue is probably one of the order of aggregation, due to whether your objects are physical or logical, on the case of case statements and aggregation you nearly always need it to be based on physical measures. My advice would be to create your logic in the rpd if possible, reproduce your case statement based on the…

If you want to do any real data updates you are better dropping write back and looking into using Apex. Write back was put there so Oracle could say it is a feature of OBIEE - it is feature - just not a good one, or one you would want to use for anything beyond posting comments in to a free text field. And even then you…

I know that this is not always an option for access reasons, but best is to create these type of variables in the rpd, then they are available in a consistent and simple manner across all of answers for the benefit of everyone.

Hi, not with filter, no, but you can filter filter results, or you could use SUM by with a case statement to achieve a similar result. Or you could use Bin logic. So there are a number of ways.

Hi, they will both tell you the same thing on this, in all manners licensing, speak to your Oracle Sales Representative...

Hi, I think your only option would be to precompute your ranks and store them, using your ETL, or use sql in an opaque view to create the equivalent, naturally the former performs better than the latter.

Sure, just have a default to one of your filters that will never return data.

I am pointing this out so much recently I think I should be on commission for Gianni ;-) https://gianniceresa.com/2017/03/scripts-to-use-agents-in-obiee-12c-mass-enabling-and-execution-from-a-page/

Hi, I was thinking of a filter in answers, not a filter formula, but you could also achieve your purpose using filter formula, or even by using equivalent case logic in a formula. Btw - word from the experienced, if you change your display name to something more user friendly then you are more likely to get people engaging…

Something like ;- Quarter in (@{SelectedQuarter}{2049Q4},substring(@{SelectedQuarter}{2049Q4},1,4)||"Q4") Not tested as not currently with an OBIEE instance.

Wow, okay, did not realise I had been overlooking field level redaction all of these years!!