Hierarchy behaving wierdly
978451Dec 27 2012 — edited Dec 28 2012Hi,
I have a 5 level hierarchy set up.
The first one is the Date column and has around 10 days worth of data.
What's happening is that, when I click on the title "Date" to drill down to the next level, the data set that gets returned gives back only 3 days worth of data, I lose the other 7 days. The weird part is that on drilling down further by clicking the next title "Line of Business", I get back all my dates and all my data perfectly.
Why do I lose my data for the first drill down and get it back for the second drill down. Any takes anyone?
Thanks.