Hi Christian, I knew you were fast but I think you just broke the laws of space / time!! There was a young lady called bright Who travelled much faster than light She departed one day in a relative way And returned the previous night. Seriously though, I think he is looking for a way to have his dashboard prompt ignored by…

Indeed, you are the second person today who turned out to be in the UK, when from their display name I would have guessed otherwise. Good to meet you, though Lancastrian - that is a wide gulf ;-) I mean you have two decent football teams for one thing ;-)

Cheers for the tip, you have me curious, I will test this on a Planning application and see if it lets you get away with it without massive rewrites as a 'real' dimension would.

If supervisor name is one of the 10 filters in your detail report then you have found your reason and deleting that filter would yield the result you want, with this requirement.

I found it odd that Oracle the Corporation named themselves after dubious predictions based on toxic poisoning

Thanks for explaining my delphic oracle type utterances...

ROTFL

We are good but not psychic. Without sight of your subject area, your filters on the target analysis, what kind of action link it is we cannot even start to guess why your two reports are different. But - here goes with my Professor X powers - we are talking a drill down action - if that is the case then OBIEE will…

Function palette is what you open when you edit a column in answers, accessed via the control that looks like a cog at the side of the column in question in the first pane in answers. Your pivot table would not change if you edit an existing column, but would need editing to include a new column if you start anew for the…

Your other alternative is to use filters in the function palette, an approach I typical use if I am manually putting together KPI type measures that do not exist in the rpd / subject area. https://gerardnico.com/dat/obiee/obips/filter_function

For case statements it is much more reliable if you can do the calculation as a physical measure in the rpd. If this is not an option have you tried forcing that column to calculate in the DB layer (server complex aggregate)?

Only if I get to watch ;-)

I sometimes wish I could write a virus that would corrupt all data that is exported to excel. Then I remember that there is no need as there are already end users.

Do you also get the same behavior using a straight tabular view, does the order of the columns work / yield the error then?

You can also do; - case when CustomerName = 'Whatever' then 'ChangeToThis' else CustomerName end But this is the thin end of the wedge to a bug riddled poorly performing OBIEE solution, all so someone can pretend that you have good controls on your master data. My best advice, tell the truth and shame the devil - your…

No, I would not expect the order of columns to have that effect, have you put diagnostics up to full and compared what is logged in the two cases?

Sum by.... Sum(YourMeasure By CustomerId) Simples! Ideally you want some data cleansing on your source data.

I would be surprised if you get any traction with support, as they will allude to flattening the measures as an acceptable solution, but sincerely wish you success with this as I agree that the proposed solution is less than ideal, especially as Essbase cubes invariably have dynamic dimension members.

Yes, if you have the unmapped columns in your report at the level of detail that they are unmapped then it will error. Check also that you content levels are set correctly on the FACT / Dimension LTS.

Like creating a pure action link on the same dashboard, or embedding it in a text area...