dbTalk Databases Forums  

Analysis Services Error in Slicevalue when processing a dimension

comp.databases.olap comp.databases.olap


Discuss Analysis Services Error in Slicevalue when processing a dimension in the comp.databases.olap forum.



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

Default 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

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.