I have a cube with no visible measures, and 2 visible calculated
members. If I use the MetaData Scripter to script out the cube and
then run the script file with no changes at all, the calculated
members fail to get created. Anyone have any idea why?

Here's the code that the scripter generated for the 2 members:
' Scripting cube command Inventory for cube Capacity012004_Shared
strStatement = ""
strStatement = strStatement & "CREATE MEMBER
CURRENTCUBE.Measures.[Inventory] AS
'IIF([Intel_Time].currentmember.level.ordinal =
[Intel_Time].[Month].ordinal,([Measures].[Inventory_sum]),Max(Descendants([Intel_Time].currentmember,[Quarter],AFTER),
[Measures].[Inventory_sum]))', NON_EMPT"
strStatement = strStatement & "Y_BEHAVIOR = 'Inventory_sum'"
BuildCubeCommand sstrName_Database, sstrName_Cube, "Inventory", 1, "",
strStatement, 0

' Scripting cube command Requirements for cube Capacity012004_Shared
strStatement = ""
strStatement = strStatement & "CREATE MEMBER
CURRENTCUBE.Measures.[Requirements] AS
'IIF([Intel_Time].currentmember.level.ordinal =
[Intel_Time].[Month].ordinal,([Measures].[Requirements_sum]),Max(Descendants([Intel_Time].currentmember,[Quarter],AFTER),
[Measures].[Requirements_sum]))',"
strStatement = strStatement & " NON_EMPTY_BEHAVIOR =
'Requirements_sum'"
BuildCubeCommand sstrName_Database, sstrName_Cube, "Requirements", 1,
"", strStatement, 0

Thanks,
John

You must have at least one visual member in a cube.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"John O'Brien" <jaobrien6 (AT) yahoo (DOT) com> wrote

ntel_Time].currentmember,[Quarter],AFTER),
([Intel_Time].currentmember,[Quarter],AFTER),

Visual member? Did you mean visible? I do have 2 visible measures, but
they are both calculated. This cube works perfectly fine if created
through Analysis Manager. Does DSO have a problem with cubes that only
have visible calculated measures? We've never had any problems with
this cube in the past, but when I script it out, and recreate it
directly from the vbscript file, the calculated measures don't show up
anymore.

Thanks,
John



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

No other information?

Thanks,
John


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!