Hi,

System: Analysis-Server 2000 SP4, Excel XP

I want to create an offline-cube via VBScript (within DTS) and it works
finde. If I connect with Excel directly to AS, the one ragged dimension
is displayed correctly in Excel. With the offline-version of this cube
the dimension is NOT ragged. So I want to put the option HIDE-MEMBER_IF
PARENT_NAME to the VBScript

Code-Snippet from the create-global-cube-statement:

SCreateCube = sCreateCube & " DIMENSION [kDfA].[MA]" & vbCrLf
SCreateCube = sCreateCube & " (" & vbCrLf
SCreateCube = sCreateCube & " LEVEL [(Gesamt)] ," & vbCrLf
SCreateCube = sCreateCube & " LEVEL [Ma3] HIDE_MEMBER_IF PARENT_NAME,"
& vbCrLf
SCreateCube = sCreateCube & " LEVEL [Ma2] HIDE_MEMBER_IF PARENT_NAME,"
& vbCrLf
SCreateCube = sCreateCube & " LEVEL [Ma1] HIDE_MEMBER_IF PARENT_NAME,"
& vbCrLf
SCreateCube = sCreateCube & " LEVEL [Msd] HIDE_MEMBER_IF PARENT_NAME"
& vbCrLf
SCreateCube = sCreateCube & " )," & vbCrLf

Any hints?

thanks in advance

Bernhard Saemmer