In SQL 2000 I set an advance dimension property "Skipped Levels Column" with a perticular column. The dimension is parent-child ragged. Now after migration from sql 2000 to SQL 2005 my report based on this dimension is not working. Can someone help me in alternate option? Do I have to use any other dimension property or use some other technique, in order to get my existing report working?
Thanks in advance.