Hello I am creating a analysis view with SQL Server 2005 using mondrian jdbc and odbc connection...Connection is ok...View is working but the problem is that it is not accessing namecolum field data in the view it shows only #null value. Please suggest solutions....Thankx in advance Nawab