OBIEE export incorrect field content from 'drill' report

Question

Hi, my OBIEE version is 11.1.1.9.0

We have a dashboard page which has an action link to move the user from summarised to transaction level data.

This works as expected.

If the end user exports the data to (say) csv content then the Value field in the exported content appears the same as the value drilled from for every row of the data, which was not the data seen on the target drill report.

Anyone seen this, know of a fix?

thanks,

Robert.,

Robert Angel · Answer

Hello again Thomas,

the columns need to be in both filter and display columns.

I have noticed that the side effect only happens on larger data volumes, could this be related to configured limits on streams / java heap etc?

thanks again,

Robert.

Thomas Dodds · Answer

I'm thinking that the dump includes ALL criteria columns ... if the purpose is filter only, try just having the column in the filter on the advanced tab and not in the criteria tab.

Robert Angel · Answer

Hi Thomas,

on export, I could not agree with you more, but since when do end users listen to us...

On the criteria, this is classic action link where the end user clicks on a value in the source report and this 'throws' parameters that are 'caught' by filters (is prompted typically, though also presentation variables)

thanks for your input Thomas.