I am trying to create a new partition using DSO and receive this error
when I begin to process my partition, "Processing error [Object does
not exist] 'All Fiscal Week

..2004

..APRIL - 2004

..12' ; Time:4/7/2004 3:40:35 PM"

I have checked to make sure the Dimension I am using for a slicer has
been processed and the data exists for the appropriate partition
slice. I am finding out that I am not having the same problem when I
use a level that does not contain member properties. I am assuming my
problem exists simply with how the member properties are referenced
within the level.

'*****************************************
'Sets the slicer for the partition
'*****************************************

Set dsoDimension = dsoPartitionNew.Dimensions("Fiscal Week")

Set dsoLevel = dsoDimension.Levels("(All)")
dsoLevel.SliceValue = "All Fiscal Week"

Set dsoLevel = dsoDimension.Levels("Year")
dsoLevel.SliceValue = "2004"

Set dsoLevel = dsoDimension.Levels("Month")
dsoLevel.SliceValue = "APRIL - 2004"

Set dsoLevel = dsoDimension.Levels("Week")
dsoLevel.SliceValue = "12"

'*****************************************
'End
'*****************************************

Hi John,

I learned processing partition will fail with error "object does not exist"
on your side. Based on my experience, While doing a processing a dimension,
don't be performing inserts, updates and/or deletes on the underlying
relational table. Analysis Services may make several passes over the
relational data while performing dimension processing. Similarly, if
processing objects in parallel, you should not be processing a dimension
while at the same time processing a partition that uses it.

Please did the same thing (create a new partition and process) using
Analyzer Manager. Did the same problem persist?

This problem is strange. If the problem occurred regular and persist using
Analyzer Manager, please provide the detailed steps / codes and sample so
that I can reproduce it on my side.

I am looking forward to hearing from you soon.
Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Michael,
I am creating a new partition within my Sales cube. This partition will
handle all of the data for a week. Below is the code I used to create
this within my dtspackage:

'DTSGlobalVariables("FactTable").Value = 'dbo.POS_FACT_2004_WK_12'
'DTSGlobalVariables("OLAP_Server").Value = 'ECKOLAP01'
'DTSGlobalVariables("OLAP_DB").Value = 'ECK_ODS'
'DTSGlobalVariables("SliceLevel").Value = 'All Fiscal Weeks.2004.APRIL -
2004.11'
'DTSGlobalVariables("SliceDim").Value = 'Fiscal Week'
'DTSGlobalVariables("PartitionName").Value = 'Sales_2004_12'

' Code Begins
On Error Resume Next

Dim intDimCounter, intErrNumber
Dim strOlapDB, strCube, strDB, strAnalysisServer, strPartitionNew,
strSliceValue, strDim
Dim dsoServer, dsoDB, dsoCube, dsoPartition, dsoPartitionNew,
dsoDimension

' Initialize server, database, and cube name variables.
strAnalysisServer = DTSGlobalVariables("OLAP_Server").Value
strOlapDB = DTSGlobalVariables("OLAP_DB").Value
strCube = DTSGlobalVariables("OLAP_Cube").Value
strSliceValue = DTSGlobalVariables("SliceLevel").Value
strDim = DTSGlobalVariables("SliceDim").Value

' Connect to the Analysis server.
Set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect strAnalysisServer

' Ensure that a valid data source exists in the database.
Set dsoDB = dsoServer.mdStores(strOlapDB)

' Set the dsoCube variable to the desired cube.
Set dsoCube = dsoDB.MDStores(strCube)

' Set the dsoPartition variable to the desired partition.
Set dsoPartition = dsoCube.MDStores(dsoCube.MDStores.Count)

'Add for dimension
Set dsoDimension = dsoPartition.MDStores(strDim)

MsgBox "New partition will be based on existing partition: " &
chr(13) & chr(10) & dsoDB.Name & "." & dsoCube.Name & "." &
dsoPartition.Name, , "ClonePart.vbs"

' Get the quoting characters from the datasource, as
' different databases use different quoting characters.
Dim sLQuote, sRQuote
sLQuote = dsoPartition.DataSources(1).OpenQuoteChar
sRQuote = dsoPartition.DataSources(1).CloseQuoteChar


'************************************************* ********************
' Create the new partition based on the desired partition.
'************************************************* ********************

' Create a new, temporary partition.
strPartitionNew =
DTSGlobalVariables("PartitionName").Value '"NewPartition" &
dsoCube.MDStores.Count
Set dsoPartitionNew = dsoCube.MDStores.AddNew("~temp")

' Clone the properties from the desired partition to the new
partition.
dsoPartition.Clone dsoPartitionNew, cloneminorchildren

' Change the partition name from "~temp" to the name intended for the
new partition.
dsoPartitionNew.Name = strPartitionNew

dsoPartitionNew.AggregationPrefix = strPartitionNew & "_"

' Set the fact table for the new partition.
dsoPartitionNew.SourceTable = sLQuote &
DTSGlobalVariables("FactTable").Value & sRQuote

' Set the FromClause and JoinClause properties of the new partition.
dsoPartitionNew.FromClause = Replace(dsoPartition.FromClause,
dsoPartition.SourceTable, dsoPartitionNew.SourceTable)
dsoPartitionNew.JoinClause = Replace(dsoPartition.JoinClause,
dsoPartition.SourceTable, dsoPartitionNew.SourceTable)

'Sets the slicer for the partition
Set dsoDimension = dsoPartitionNew.Dimensions("Fiscal Week")

Set dsoLevel = dsoDimension.Levels("(All)")
dsoLevel.SliceValue = "All Fiscal Week"

Set dsoLevel = dsoDimension.Levels("Year")
dsoLevel.SliceValue = "2004"

Set dsoLevel = dsoDimension.Levels("Month.Fiscal Mth Abbr")
dsoLevel.SliceValue = "APRIL - 2004"

Set dsoLevel = dsoDimension.Levels("Week.Fiscal Wk Name")
dsoLevel.SliceValue = "12"


' Estimate the rowcount.
dsoPartitionNew.EstimatedRows = 18325

' Add another filter. The SourceTableFilter provides an additional
opportunity to add a WHERE clause to the SQL query that will
' populate this partition. We're using this filter to ensure our new
partition contains zero rows. For the purposes of this sample code
' we don't want to change the data in the FoodMart cube. Comment out
this line if you want to see data in the new partition.

' Save the partition definition in the metadata repository
dsoPartitionNew.Update

' Check the validity of the new partition structure.
IF dsoPartitionNew.IsValid Then
MsgBox "Partition is valid"
End If

MsgBox strPartitionNew & " has been created."

' The next statement, which is commented out, would process the
partition.
' In a real partition management system, this would likely be a
separate
' process, perhaps managed via DTS.
' dsoPartitionNew.Process

' Clean up.
Set dsoPartition = Nothing
Set dsoPartitionNew = Nothing
Set dsoCube = Nothing
Set dsoDB = Nothing
dsoServer.CloseServer
Set dsoServer = Nothing

Main = DTSTaskExecResult_Success
End Function



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi John,

Thanks for the information you kindly provided. After a quick code review,
it seems you did not define the global variable OLAP_Cube, which will be
used in the following code.
strCube = DTSGlobalVariables("OLAP_Cube").Value
Set dsoCube = dsoDB.MDStores(strCube)

Also, if you have Microsoft Windows 2000, Microsoft Visual InterDev 6.0 or
the Microsoft Windows NT 4.0 Option Pack installed, you can use the script
debugger supplied with those products to troubleshoot your Microsoft
ActiveX scripts. Please try to locate the code inducing "Object does not
exist" error.

I found the following articles for your reference.
Debugging ActiveX Scripts
http://doc.ddart.net/mssql/sql2000/h...df_ax_0bg3.htm

I am looking forward to hearing from you soon.
Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Hello John,

How is the issue going on your side? Let us know if you need further
assistance on this issue.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Mike,
Still dead in the water. I have actually been waiting to hear back from
you. I can not find much documentation on how to handle the slicer
code, and here is why. When I try to use this code:

dsoPartitionNew.Dimensions(DTSGlobalVariables("Sli ceDim").Value).Levels(
"(All)").SliceValue = "All Fiscal Week"

dsoPartitionNew.Dimensions(DTSGlobalVariables("Sli ceDim").Value).Levels(
"Year").SliceValue = "2004"

dsoPartitionNew.Dimensions(DTSGlobalVariables("Sli ceDim").Value).Levels(
"Month").SliceValue = "APRIL - 2004"

dsoPartitionNew.Dimensions(DTSGlobalVariables("Sli ceDim").Value).Levels(
"Week").SliceValue = "12"

I received the error, "Processing error [Object does not exist] 'All
Fiscal Week
2004
APRIL - 2004
12' ; Time:4/15/2004 8:47:12 AM" Although when I look at it in the
process dialog box it appears as, "All Fiscal Week2004APRIL - 200412" I
know the values are being applied although I am missing something. When
I look at the newly created partition (Edit), the slicer looks correct,
but I can not process it. I did see another post similar to mine
although no answer had been presented yet. This is frustrating!!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!