Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I can't for the life of me rember h
- Thread starter afzalz
- Start date
Hi, Afzalz!
In visual basic this job can be done by the next code:
Dim dsoCube as As DSO.MDStore
Set dsoCube = dsoDB.MDStores("MyCube"
Dim dsoCalculatedMember As DSO.Command
Set dsoCalculatedMember = dsoCube.Commands.AddNew("MyCalc"
dsoCalculatedMember.CommandType = cmdCreateMember
'set the MDX statement that defines the calculated member
dsoCalculatedMember.Statement = "CREATE MEMBER MyCube.Measures.[MyCalc] AS '#WRITE HERE YOUR CALCULATED MEMBER FORMULA#'"
dsoCube.Update
please, notify me if it helped you to solve your problem
My best regards, Issahar
Issahar
In visual basic this job can be done by the next code:
Dim dsoCube as As DSO.MDStore
Set dsoCube = dsoDB.MDStores("MyCube"
Dim dsoCalculatedMember As DSO.Command
Set dsoCalculatedMember = dsoCube.Commands.AddNew("MyCalc"
dsoCalculatedMember.CommandType = cmdCreateMember
'set the MDX statement that defines the calculated member
dsoCalculatedMember.Statement = "CREATE MEMBER MyCube.Measures.[MyCalc] AS '#WRITE HERE YOUR CALCULATED MEMBER FORMULA#'"
dsoCube.Update
please, notify me if it helped you to solve your problem
My best regards, Issahar
Issahar
- Status
Similar threads
- Locked
- Question
- Locked
- Question