issue with ssrs 2005

• scottichrosaviakosmos

  SSCommitted

  Points: 1889

  More actions

  November 14, 2014 at 9:04 am

  #397643

  we have a report which is currently in ssrs 2005 using ssas 2005. We are doing a migration from sql 2005 to sql 2012.

  this report which works fine when connected to ssas 2005 is not working when with ssas 2012. We have converted the SSRS report to 2012 and deployed in reportserver(using bids 2012) and is working fine when connect to ssas 2005 but not when connect to ssas 2012.

  While doing some analysis it seems a query using STRTOMEMBER is creating some issues. when we remove this function then the results are proper.

  When we run this below query we get the results as ALL for all the rows. but when we remove Strtomember and take some value instead of parameter then we get desired output.

  interestingly as soon as connect again to SSAS 2005 the report works normally. Any idea?. below is the query with issue.

  WITH

  MEMBER [Measures].[Prmval] as StrToMember('[Country].[' + @prmhello +'].CURRENTMEMBER').UNIQUENAME

  MEMBER [Measures].[Prmlbl] as strtomember('[Country].[' + @prmhello + '].CURRENTMEMBER').name

  SELECT

  {[Measures].[Prmval] , [Measures].[Prmlbl]} on columns

  nonempty(.....)

  from abc