I wonder if anyone can help. I am using CREATE GLOBAL CUBE to create a
local cube file for offline analysis and it works OK, eg:

CREATE GLOBAL CUBE [Cub_Local]
Storage 'C:\Temp\External.cub'
FROM [DSA_External]
(
MEASURE [DSA_External].[System Active Uses Count],
DIMENSION [DSA_External].[Aging Bracket],
DIMENSION [DSA_External].[BDS Systems],
DIMENSION [DSA_External].[External System Operator ID]

)

but I can't seem to get

i) The dimensions to sort by any attribute except the key.
ii) Export the Name instead of the Key

Any help would be appreciated,

Cheers

Tim