And your action link is at row level and is invoked on the highlighted column? As a workaround you could create a dashboard prompt for the same column, and set a presentation variable with it, filtering based on the presentation variable. You can then display the presentation variable whilst testing and that way you will…

Are both reports based on the same subject area? Does the target report include an is prompted filter on the field in question? Is it a field, not based on a calculation?

No values are stored, it is all on the fly. if you need to capture them at a point in time then you could easily view the physical sql using the logs and use that as the basis of an ETL to capture your KPI at a moment in time - all of which would be 'custom' ETL development.

Last, but by no means least, if you can do this in the ETL then do.

Btw - I would do this in more than one measure, you don't have to expose them all to the user. For the case logic make it a physical calculation. For the max logic base it on the physical case logic calculation. Pin as previously noted to the detail level of route.

Do you have a dimension hierarchy associated with Route? If so try pinning the max measure to the detail level.

Sure - middleware again!

I can suggest a workaround in the form of a client tool called data loader, or you could drop them out into excel and work some VB magic on the column in question. But Christian as ever is 100% correct, there is nothing without interceding middleware in your scenario.

Btw - good report design - would you try and eat a banquet on a single plate? No you would serve it manageable portions! Should you replicate a business' legacy reports as is just because that is what they have always done? No - to get the best out of BI report based communication to the user should be focused, think of a…

Have you checked your logs to see if any errors are reported, sounds like it might be temporary memory, but that it just an educated guess, which is why I am saying check your logs...

See my answer to OBIEE and Oracle SOA If you 'break it', then you can roll back to a previous snapshot, provided you keep a previous snapshot that is.

Hi, once you have downloaded the virtual box you then download the Business Intelligence pre-built application - the second link I provided as above - just scroll down until you find the Business Intelligence pre-built download. From memory I think you also need to install the extension first. The pre-built gives you an OS…

Hi, if you want OBIEE fast then try downloading Oracle Virtualbox and then install the Oracle prebuilt package for Business Intelligence, provided it is all for non-production purposes there are no license implications. Oracle VM VirtualBox - Downloads | Oracle Technology Network | Oracle Pre-Built Developer VMs for Oracle…

That sounds horrible. On so many levels... Could you get the same effect by union (all) the two data sets (with their independent filters) and pivoting the results?

Okay, but why can't you achieve it all in one analysis? Two reports might work today but they have a habit of getting slightly out of kilter and then the whole effect is ruined.

Now you have lost me - is it hidden because you have more than one analysis format; table, graph, pivot table; coming from the same data source? Or is it hidden because you are using it in the pivot table to give a sort order or a grouping, or it is part of logic in the non-hidden column? In short, can you explain why it…

Could you not achieve what you need in a single column, without the need for a separate column?

Hi, turn your diagnostics up, run a query, look at the log and the physical sql therein. Try running the physical sql directly against your database. Does that give you any clues? Also, do you have any row level security applied which could be failing?

Hi Febin, go_url syntax includes the option to specify css, and also to present the page in a portal style, have you tried either of these options? Other than that you can rebrand / debrand the OBIEE pages, but it is no small task.

Didn't mean to rush you, just thought you might not 'know the ropes' with your newbie status. No apologies necessary!