Default parameters (MDX for cube)

• Bunx

  SSC-Addicted

  Points: 473

  More actions

  May 18, 2010 at 9:41 am

  #235192

  I was wondering whether anyone has had a problem with report parameters when dealing with a cube data source...

  I have a country filter which is bases on a dataset. The, for instance, I want 'Australia' as the default member. So I specify [Country].[Country].&[Australia] as the defualt value. This works fine when run in the visual studio report designer, however when I view it through the browser (IE8 i think) it shows up blank.

  Has anyone come across this and is there a workaround?

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  July 2, 2010 at 3:22 am

  #1188083

  Have you tried this in your SSRS parameter:

  ="[Country].[Country].&[Australia]"

  gsc_dba