BW Hierarchy data not showing in Crystal
I am trying to create a Crystal Report from an existing 3.5/7.0 BW query with a hierarchy. I have followed a BO white paper and the blog from Ingo on how to do this but my data does not appear.
Before I even build the report in Crystal I context menu on any of my hierarchy db fields under Field Explorer to Browse Data but it is empty. If I do the same for my Key Figure I do see the data.
Looks to me like a setting on BW that I am missing??