I have an OLAP cube connected through Excel,having a Customer Table around 100.000 items.
When I drill through the field, it starts from "A" but ends with "S" because of the limitation of the excel which I get "The field has more than 32000 items under one or more parent items. Only the first 32000 items are displayed
under each parent item."
How can I bypass this, or how can I split the Customer Table or adding a hierarchy so the Cube field shows like this ;
View Complete Post