Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 15, 2012 6:57 AM by
No data for Parent-child hierarchy column in Pivot table view
Nov 4, 2012 8:29 AM
I used OBIEE 220.127.116.11.2 Version.
I drag one Parent-child hierarchy column and one measure and show result with a
pivot table view
But when I click "+" icon to show detail level data,
It messaged that: "*the layout of this view combined with the data,selections,drills,or prompt values chosen resulted in no data*."
But it can show every-level data when I used
It was so strange..
Did anybody meet this before?
Thanks in advance.
This content has been marked as final.
Show 1 reply
Re: No data for Parent-child hierarchy column in Pivot table view
Nov 15, 2012 6:57 AM
in response to
Yes, I have the same problem with pivot table for hierarchy dimension.
If you use a normal table (not pivot) it seem to work. Unfortunatley with restrictions as normal table view have.
Same problem still exist in 18.104.22.168.5
I have logged a SR to Oracle about this.