I'm triying to create an offline cube through Excel or MDX. I use
this to create it:

CREATE GLOBAL CUBE [GMTLocal]
STORAGE 'C:\GMTLocal.cub'
FROM [GMT]
(
MEASURE [GMT].[Value],
DIMENSION [GMT].[Time],
DIMENSION [GMT].[Indicator],
)

The problem is [Value] is a calculated member. When I use a simple measure works fine, but when I use calculated member instead of, an error ocurrs. Can you help me???


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

All calculated members are automatically included in local cubes created
with the CREATE GLOBAL CUBE command. If you try to reference a calculated
member, the creation statement will fail with a message stating that the
particular measure doesn't exist.

However, the calculated member will not be in the local cube if any of the
objects it uses aren't available or if the calculated member is invalid for
some other reason. If you want a calculated member to appear, but not the
measures it depends on, you can mark those measures as "Hidden". However, if
there are other calculated members based on these same measures it is
impossible to exclude them, if you are using CREATE GLOBAL CUBE. If you
switch to the CREATE LOCAL CUBE command you have full control over which
caculated members are excluded or included (but you'll also have a lot more
work writing you code).

Here's how your CREATE GLOBAL STATEMENT should appear. Include all Base
Measures that are used in the calculation for Value. The only measure that
will be displayed in the local cube will be Value, unless there are other
calculated members using the same Base Measures.

CREATE GLOBAL CUBE [GMTLocal]
STORAGE 'C:\GMTLocal.cub'
FROM [GMT]
(
MEASURE [GMT].[BaseMeasure1] HIDDEN,
MEASURE [GMT].[BaseMeasure2] HIDDEN,
DIMENSION [GMT].[Time],
DIMENSION [GMT].[Indicator],
)

I hope this is helpful.

Tim Peterson
www.localcubetask.com

"Alexis Escobar" <vinito1974 (AT) yahoo (DOT) es> wrote

Can you help me???

So what you're saying Tim is that it is possible to have calc members in a
local cube under giving circumstances ? Thought it couldn't be done at
all...


"Tim Peterson" <tpeterson (AT) sdgcomputing (DOT) com> wrote