dbTalk Databases Forums  

All member formula

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


Discuss All member formula in the microsoft.public.sqlserver.olap forum.



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

Default All member formula - 05-24-2005 , 09:01 AM






Hello,
Does anyone has a sample code for updating all member formula via DSO? And,
the same thing for CREATE CUBE statement?
Thanks,

Resho

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: All member formula - 05-24-2005 , 12:02 PM






The Metadata Scripter from the SQL Server 2000 Resource Kit is your friend.
Simply create a cube and then run Metadata Scripter -- it will generate VB6
code to generate that object.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Resho" <Resho (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,
Does anyone has a sample code for updating all member formula via DSO?
And,
the same thing for CREATE CUBE statement?
Thanks,

Resho



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.