Hi,

I have a partitioned cube in Analysis Services, Through a
VB .NET program I am trying to change the fact table for
one of its partitions. I am using Decision Support Objects
(DSO) 5.1. The statement used is :
dsoPartitionNew.SourceTable="ABC"

I have traced the execution of this program and verified
that control reaches this statement. However, the value of
the SourceTable property does not change even after it
passes this statement. The value of the property remains
what it was.
However, for a different cube, this works fine and I am
able to change the fact tables for different partitions.
Can somebody suggest what might be lacking in the
problematic cube or in the code?

Thanks
Yash

Are you issuing the update statement after you execute that line of code?



--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Yash" <yashgt (AT) indiatimes (DOT) com> wrote

I am calling Update after the statement. But the problem
is that the statement itself is not working. When I trace,
I find that the SourceTable property of the DSO object
itself does not change.