OBIEE 11g Dashboard Drill-Down Analysis replacing one column's data with another column

b77b83f0-ba5c-46aa-8d8e-52f30f687478

All,

I am a novice 11g user and am experiencing an issue I'm hoping you can provide help with.

I have a dashboard that has a pivot table that allows for drill down by agent name.  The drill-down calls a separate table analysis that shows raw ticket data.  This table contains only 8 columns of ticket data, all from the agent that was drilled down.

The issue I'm experiencing is the one of the columns in the analysis is over-writing the data on another column.  As an example, the columns listed are Ticket Number, Agent Name, Date Opened, Date Closed, Assignee Department, Application Name, Sub-Component and MTTR.  When you run the analysis by itself, it pulls back all the data correctly.  But if you run the dashboard, then drill-down by agent, which calls this analysis, the MTTR column shows the Agent Name data.

I've re-created the table analysis from scratch and re-wrote the filters manually and the issue still occurs.  It occurs no matter what agent you drill down.  If you remove the MTTR field in the table, the Agent Name data will just over-write on another available column.

Any suggestions on how to troubleshoot this issue?