dbTalk Databases Forums  

creating calculated members on local cubes

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


Discuss creating calculated members on local cubes in the microsoft.public.sqlserver.olap forum.



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

Default creating calculated members on local cubes - 08-08-2003 , 04:18 PM






Hello,
I tried to create a local cube by ADO, using a VB app.
It has to contain a calculated member. I tried the next
code:

Dim cmd
cmd = "CREATECUBE=CREATE CUBE MyCube (
DIMENSION Dim1 ...,
MEASURE...,
COMMAND (CREATE MEMBER Dim1.NewMember as '...'))

the cube is ok, but if I try to open this cube by pivot
table (excel) or ProClarity, I see all but not calculated
member.

Is it something wrong on syntax (it executed it without
error !)
I used MSOLAP provider and I also tried MOLAP.2

Can anyone help me?

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.