For a start you could compare the execution plans between 10g and 11g to understand what the issue might be. When migrating to DWH solutions to Exadata one generaly re-evaluate the indexing strategy. Did you do such an exercise?
Are you using the Exadata datasource ?
What version of OBIEE are you using ?