Am I alone in wondering how much of an asset OBIA could have been if they had developed it in partnership with a decent OBIEE / EBS partner?

Hi Charles, @Gianni Ceresa is correct as ever, it is purely there so if you want a heads up on what the differences are between what you had and what you will have then you have a means to see all of the changes. Might be worth doing with OBIA even if it is a size, then you can use it as a broadbrush on what you need to…

Others may disagree but my take on a subject area is; - a. It should relate to a single business area and make sense to group what is there in pure business terms b. It should not be possible for the end user to construct an analysis from the subject area that will not work - i.e. the end should need no specialist…

Okay, maybe if you can isolate your problem down then we can understand it and fix it. Can you filter to a single row in each union to get just a problem line? The reason I ask is to eliminate the possibility that this is not what you think it is, and to provide an isolated case of exactly what your problem looks like.…

So you can add a Not Equal to 0 filter on the formula column to remove the offending rows, or if this causes genuinely wanted zeroes to be removed then amend the formula to create a very specific value that would only happen as a consequence of the nullif and filter that out. Yes?

My thought with ifnull was when your COB date is null then use ifnull to replace it with the Comparison date formula (second half of your formula), this would mean that all where you comparison date is populated but your cob date is not would become zero, as any result minus itself would yield zero.

One more question, you talk about data(Dollars) and you give me the formula; Formula: "Measures"."Book Value USD" USING "Date"."COB Date" IN (@{pv1}{date '2018-11-30'}) and Formula: ("Measures"."Book Value USD" USING "Date"."COB Date" IN (@{pv1}{date '2018-11-30'}))- ("Measures"."Book Value USD" USING "Date"."Comparison…

Ok, can in your description you talk about calculating the difference between two dates - but this will be a number not a date so you cannot be union'ing that into the same field?! Can you clearly define the logic for what you want to see, and like the sql forums provide a small but perfectly formed piece of illustrative…

Hi, your filters are definable by you on each part of the union query and can be wholly independent of each other, so it is up to you to ensure you have wholly appropriate filters on the sources to get the data set that you want, and if there are two kinds of date that you are putting into the same field via the union then…

Both are based on the same subject area? The target has 'Is Prompted' filters on all of the columns you are trying to 'catch'? There is nothing else filter wise on the same columns that could be blocking? When you say 'navigation' do you mean an action link?

Thanks Jerry, was head down in other work but when I came back you had done a better job than I had, kudos!! ++Jerry

If you are talking about master detail, which is to say a master report where the user can click on a row and a detail report which listens then the detail report will catch ALL dimensions in the row that you click on. https://gerardnico.com/dat/obiee/obips/master_detail If you are talking about using an action link to…

There is only one way to move a mountain of **** and that is one handful at a time. (Allen Ginsburg) I have posted in the past that I think Essbase in OBIEE is not the wholly integrated product you would hope for. I have responded to this in the past by as extreme a step as putting the data and metadata through ODI to…

Thank you for the acknowledgement, you are most welcome, and courtesy is always appreciated here! Word from the wise - change your display name to something more user friendly - aliases are fine if you don't want to use your real name but forum users are more likely to respond to those who don't stick to the default number…

My mother didn't raise a quitter.... You want two groups of columns. You want the data to appear under the group heading that is appropriate. You currently have one group of columns. You copy these columns and you add a case statement using the function palette to specialise both groups, such that when the condition is met…

Amen! Data-centric not report centric - else in five years time you will have a shambling abomination that would make Dr Frankenstein cry...

You kind of lost me in the middle there... but if; - "I can't figure out how to give the same column that used twice a different name" - is the crux of it (?) then all you have to do is bring the same measure in twice (or formula if it has been built there) and give the second instance a different heading. So if it is…

Yes, duplicate the measures in the analysis. Then create a case on the measures to either present the value or not for the two groups, setting the appropriate heading for each group manually as you describe. Better yet, if this is a corporate requirement then create the two groupings in the rpd, as case logic can cause…

If you created two versions of the same analysis and used the advanced tab on one version to always bypass cache and gave the user an action link to open either cached either cached or non-cached then you could.... But I suspect if you did you would find out that your users always went for the 'live' data, there is not a…

Though speak to Oracle Sales people and no surprise on what they will try to sell you -> https://www.oracle.com/uk/engineered-systems/exalytics/