Dear Anyone,
We seem to have encountered a bug o a limitation but we're not sure what to make of it.
We are using Analysis Services 2005 RTM. Went have a 3 level dimension. We noticed that when we used the dimension in the page field of the pivot table, we noticed that not all members of some parents in the 2nd level does not display. We double checked by browsing the dimension using the Management studio and we confirmed that not all members in the lowest level is being displayed. The ratio is somewhere in the numbers of 45900/2500. The lower number being the only number of members that are being displayed.
The weird part is that we didnt encounter this problem with the Analysis Services 2000. Our current OLAP project now is a migrated version of our old data warehouse.
Any insights anyone?
Thanks,
Joseph
Couple of things to try.
One: Try to browse your cube using cube browser and not dimension browser in the SQL Management studio.
Two. Try building a simpler cube (just few dimensions) in AS2000 and migrate it to AS2005. Compare results in Excel. See if you see different results when browsing cubes of exact the same structure.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
No comments:
Post a Comment