Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    2

    Unanswered: Updating Calc Members using DSO

    I am simply trying to set the visible property to true (or false) for a selected set of calc members. The string sStatement is a string and returns the create member statement of the calc. I.e


    Set dsoSelectedCommand = dsoServer.CreateObject(clsCubeCommand)
    dsoSelectedCommand.Name = MemName

    dsoSelectedCommand.CommandType = cmdCreateMember
    dsoSelectedCommand.Statement = sStatement


    'dsoSelectedTrgtCube.Commands.Add dsoSelectedCommand

    dsoSelectedTrgtCube.Update

    However, this works fine when I need to create a new calc member and set its visible property to false. Any ideas would he appreciated.

    Mark Frank

  2. #2
    Join Date
    May 2002
    Posts
    2
    Got it myself. Was missing

    dsoSelectedCommand.Statement = sStatement

    on the other side of an if command.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •