Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Local Cube - measure formats Expand / Collapse
Author
Message
Posted Monday, September 06, 2010 3:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:12 AM
Points: 132, Visits: 103
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
Post #980967
Posted Wednesday, August 28, 2013 11:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:48 AM
Points: 1, Visits: 55
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
Post #1489535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse