Hi I am sort of stuck with this issue ...I want to be able to Filter Hierarchy to exclude member that are null... Basically what I got is what we called leveled table ....that maintain alternative hierarchies..... Dimension called accounts ..it has three hierarchies .... the underlying table has following...

Hi, Can you be more specific and outline the steps to achieve this? Thanks Ram

Hi Experts, Can you recommend a good websites, articles or free e-book that I can use to learn about the basic of OLAP or Analysis Services by SQL Server 2000/2005? I've been using SQL Server but this time my new role as report developer requires me to learn about OLAP or Analysis Services. Thanks...