Local Cube - measure formats

• neil ashworth

  SSC Enthusiast

  Points: 158

  More actions

  September 6, 2010 at 3:10 am

  #157182

  I am creating a local cube using the "CREATE GLOBAL CUBE" statement (SSAS 2005). This particular cube is for our South African division so the currency for value measures is South African Rand which is easily acheived by setting the language property on the cube. However when I browse the Local cube in excel 2010 it defaults to my local currency settings. Is there any way around this?

  thanks

  neil

• tpraveenkumarmsbi

  Newbie

  Points: 9

  More actions

  August 28, 2013 at 11:40 pm

  #1645832

  Hi,

  How u are accessing the data from the local cube,when the local is created.

  I have also created a local cube using MDX query and unable to connect the local cube and access the cube

  can any one help me how to access the local cube?

  Thanks & regards

  Praveen