dbTalk Databases Forums  

How do you create a Calculated Member with DSO?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How do you create a Calculated Member with DSO? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bob Segrest
 
Posts: n/a

Default How do you create a Calculated Member with DSO? - 12-26-2004 , 03:37 PM






Hello Everyone,

Can anyone point me to an example of how to createor copy a Calculated Member
with DSO?

Bob Segrest, PMP

Bob Segrest, PMP
BSegE LLC
(540) 937-5875
http://www.BSegE.com

Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: How do you create a Calculated Member with DSO? - 12-26-2004 , 05:53 PM






try this type of script:
http://groups.google.ca/groups?hl=en...lserve r.olap

This VBScript working snippet should help:

set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect "LocalHost"
Set dsoCube= dsoServer.MDStores("Foodmart 2000").Cubes("Sales")
Set dsoCommand= dsoCube.Commands.AddNew("Test Member")
dsoCommand.CommandType=1
dsoCommand.Statement= "Create Member CURRENTCUBE.Measures.[Test Member] as
'[Measures].[Unit Sales] * 2'"
dsoCube.Update

good luck

"Bob Segrest" <Bob.Segrest (AT) BSegE (DOT) com> a écrit dans le message de news:
eZRLHP56EHA.3708 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Quote:
Hello Everyone,

Can anyone point me to an example of how to createor copy a Calculated
Member
with DSO?

Bob Segrest, PMP

Bob Segrest, PMP
BSegE LLC
(540) 937-5875
http://www.BSegE.com



Reply With Quote
  #3  
Old   
Bob Segrest
 
Posts: n/a

Default Re: How do you create a Calculated Member with DSO? - 12-26-2004 , 07:30 PM



Thank you!

I appreciate the pointer.

Bob Segrest, PMP
BSegE LLC
(540) 937-5875
http://www.BSegE.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.