What is your security model? Do the links go missing as admin user? What browser are you using? Have you tested the behaviour is the same for other users / other browsers?

What about the physical joins, if you select the fact folder and the dimension folder that has the organisation in it and then use the rpd query tool to see the underlying physical tables, what is the result and what are the joins, is item 'in the picture at all'?

No, more probably something is amiss in your business modelling, what is the content level set for on that measure? - is it detail against everything? - is there any row level security that might force item id into the query?

And am I understanding you correctly, is your measure created along these lines? https://www.kpipartners.com/blog/bid/185891/Using-Level-Based-Measures-in-OBIEE

And what was the level based dimension / level of granularity that the measure should be reflecting? - from your comment - if I understand you correctly - organization id??

If I think you are asking what I think you are asking then you need to use sum ... by .. in your calculation as an alternative to the level based measure. SUM("Sales Facts"."Amount Sold" BY Customers."Cust Id") Note: level based measure only guarantees that the measure is "always calculated to a specific level of…

Hi, sorry it was where you were pitching the question (OBIEE space!) that threw me, you would be have been better with Essbase on-premise for that perhaps...

How do you create the calculated item? If we are talking using a formula, then yes, just use the layout editor to drag your column to its new place., preview and save. If we are tallking a pivot table 'layer' then no, they are displayed last, but any reason you cannot create the equivalent using a formula as described…

Hi, it is not unusual for a subject area to have one 'formal' time dimension and then numerous date columns that are not part of the time dimension, but which act more like descriptor columns. In your case, as the learned Mr @Christian Berg rightly says just because you want to calculate distinct issues opened and distinct…

Mass data dumping; - verb - to provide large amounts of data to those with limited skills in data handling and tools ill suited to the task to produce reports of un-certifiable quality or with the aim of direct consumption of inorganically large volumes of data within the finite resources of human rationality, perception…

Yes, maybe that is one for the ideas section, would explain why a lot of people never mark their answered questions.

Odd - I wonder if they have taken that away recently, you used to be able to do it, and I have done it myself when I wanted to share long hours research that finally hit gold - you get no points for doing so, it is purely altruistic

Thanks for this (sincerely!) it might help others and I did not think to double check the basics!! (Mark yourself correct!!)

If Javascript is not a hack too far you might want to look at this -> Pivot Table And Sections - Display horizontally

You want a section, but you want it vertical not horizontal. You cannot use pivot table calculated columns because they would appear on the right. You could use Bins to add a column that groups your AT01 / AT02 / AT25 / AT36 / AT68 (and repeat for the other groups) into a single group, then use some means to make it not…

Nasty, nasty, hacky idea, but have you tried creating a formula column that is just ' ' (or however many spaces you need) suppress the heading and put it in place...

Take a look at this in 'My Oracle Support' - note you need an Oracle Account to log in-> OBIEE 11g - Union Report Fails With '[nQSError: 59107] Set operation failed due to incompatible sort order' (Doc ID 1573959.1)…

Yes, basically, just make sure if you have any 'hard coded' filters on your target that you don't want restricting by the more finite data drilled from that you use protection to prevent those filters being "overruled" in the same way as the 'Is Prompted' values.

See also -> OBIEE 11g – Using Action Links in Analyses & Dashboards - Red Stack Tech

Steps; - 1. Create report you want to drill to 2. Put 'Is Prompted Filters' on target report - assuming from same subject area 3. Put action link on source report to navigate to target report Job done.