Analysis Services Error in Slicevalue when processing a dimension -
11-22-2004
, 08:23 AM
I am getting an error when processing a partition through DSO. I would
really appreciate your help.
Description of the error:
When adding a slicevalue to a partition through DSO and processing, I
am getting some sort of non-displayable characters between the levels.
Instead of being [All].[Year].[Quarter].[Month], each level appears
on a separate line with a non displayable character after each one
(maybe a newline?).
This is the error message:
Processing error [Object does not exist] '
[All]
[2003]
[Quarter 2]
[May]'
Part of my code:
Dim dsoPartition As DSO.MDStore
Dim dsoDim As DSO.Dimension
Dim dsoLevel As DSO.Level
dsoPartition = Type(m_dsoCube.MDStores.AddNew(CUBENAME), DSO.MDStore)
dsoPartition.SourceTable = m_dsoCube.SourceTable
dsoPartition.EstimatedRows = m_dsoCube.EstimatedRows / 24
dsoPartition.SourceTableFilter = m_dsoCube.SourceTableFilter & " AND "
& m_objData.DMSchema & "." & m_objData.FactTable & "." &
m_objData.PartitionKeyColumn & " = " &
rdPartition.GetValue(0).ToString
dsoPartition.Update()
For Each dsoDim In dsoPartition.Dimensions
If dsoDim.Name = "Time.Calendar" Then
For Each dsoLevel In dsoDim.Levels
If dsoLevel.Name = m_objData.PartitionLevelName Then
dsoLevel.SliceValue = "Sep 2002"
End If
if dsoLevel.Name = "Year" Then
dsoLevel.SliceValue = "2002"
End If
If dsoLevel.Name = "Quarter" Then
dsoLevel.SliceValue = "3Q2002"
End If
if dsoLevel.Name = "All" Then
dsoLevel.SliceValue = "All Time"
End If
Next
Next
dsoPartition.Update()
Thanks in advance,
Mart |