This content has been marked as final. Show 4 replies
Try to set the Value Suppression to repeat in column properties and then check. Let me know if that works.
Thanks for the reply, I changed the Suppression Value to repeat for all the levels of the hierarchy and it is still exporting just the major level only.
This is a bug see below.
Bug 13083479 : EXPORT DATA TO CSV FORMAT DOES NOT DOWNLOAD EXPANDED HIERARCHICAL COLUMNS
Proposed workaround : OBIEE 126.96.36.199: Pivot Table Report Export To Csv Does Not Include Hierarchical Data [ID 1382184.1]
Mark if answered.!
do it in the Selection Steps, Add all members of the hierarchy