I've posted my issue before but I haven't heard any reply yet.
Currently I'm using MSAS 2000 Cubes and i've tested it through the excel and I do not have any issue to drill down up to bottom level of any dimensions with cubes. So I can say the cube sturucture is okay.
However in crytal report, I can't get the right bottom levels in some dimensions. For example, I put customer information and product details in rows and time and measures in columns and when I select the bottom level in product dimension, all product details are not displayed and some of them are missing. If I move customer dim to slice section then it works fine. Also, if I unselect the 'filter null value' then i can have all information including all null value. But users do not want to see all null values and I can privide them as a solution.
I do not understand this behavior right now, and want to know whether anybody has a similar issue and this is a bug in crytal report or my own issue.
Any kinds of advice would be greatly appreciated.
Thanks.
Currently I'm using MSAS 2000 Cubes and i've tested it through the excel and I do not have any issue to drill down up to bottom level of any dimensions with cubes. So I can say the cube sturucture is okay.
However in crytal report, I can't get the right bottom levels in some dimensions. For example, I put customer information and product details in rows and time and measures in columns and when I select the bottom level in product dimension, all product details are not displayed and some of them are missing. If I move customer dim to slice section then it works fine. Also, if I unselect the 'filter null value' then i can have all information including all null value. But users do not want to see all null values and I can privide them as a solution.
I do not understand this behavior right now, and want to know whether anybody has a similar issue and this is a bug in crytal report or my own issue.
Any kinds of advice would be greatly appreciated.
Thanks.