dbTalk Databases Forums  

CustomProperties("DimensionSlice")

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


Discuss CustomProperties("DimensionSlice") in the microsoft.public.sqlserver.olap forum.



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

Default CustomProperties("DimensionSlice") - 09-13-2005 , 08:43 AM






All,

I keep getting an "Object Required" vbscript error when trying to set the
data slice name for a newly created partition

Has anyone seen this error before?

dsoPartitionNew.Dimensions("Fiscal").CustomPropert ies("DimensionSlice")
=cstr(yr)&"."&cstr(qtr)&"."&cstr(pd) &"."& cstr(wk)

Thanks,

Jim

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

Default Re: CustomProperties("DimensionSlice") - 09-13-2005 , 06:09 PM






You might look at getting a copy of the Metadata Scripter from the SQL
Server 2000 Resource Kit. If you use it to create a VB program with a data
slice setup, you will see the DSO code needed. I don't know if this is the
problem, but one issue is that you don't have brackets around the member
name []. But your best bet is to use the Metadata Scripter -- it can save
you hours of debugging time.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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

Quote:
All,

I keep getting an "Object Required" vbscript error when trying to set the
data slice name for a newly created partition

Has anyone seen this error before?

dsoPartitionNew.Dimensions("Fiscal").CustomPropert ies("DimensionSlice")
=cstr(yr)&"."&cstr(qtr)&"."&cstr(pd) &"."& cstr(wk)

Thanks,

Jim



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.