In 10g, I have a name and an id column. When I drag them to the pivot table page (prompt) it combines the two columns into a single drop-down. In 11g, placing the columns in the prompt area creates a separate drop-down for each column.
I assume this is the correct behavior now in 11g, but wanted to make sure, since there is no documentation on this.
Yes You are right.
Mark if helps.
You can do a best thing. Go to Help drop down >> Help Contents >> Oracle BI EE >> and search for pivot (click on Editing Table and Pivot Table Views).
That shows pivot table prompt for two columns and 'YES' thats provided by Oracle (So you can prove yourself ).
Hope this answered/ helped.