Can I add measures for a partition using DSO?

#1

Hi:

I have a cube with multiple partitions. Since each partition has a different
fact table, I have to add the same measures for each partition (is this
right?). I'm trying to add a new measure like this:

DSO.PartitionMeasure measure = (DSO.PartitionMeasure) part.Measures.AddNew
("sales", DSO.SubClassTypes.sbclsRegular);

I got error message:
"Additional information: Object variable or With block variable not set".

Anyone knows what it means?

Thanks

#2

Hi, Thanks for your info. But I'm using C#, not VB.

"akshayk" <akshay349 (AT) hotmail (DOT) com> wrote

Quote:

syntactically statement should be :-
SET DSO.PartitionMeasure measure = (DSO.PartitionMeasure)
part.Measures.AddNew("sales", DSO.SubClassTypes.sbclsRegular);
You are missing "SET"
"Polaris" <etpolaris (AT) hotmail (DOT) com> wrote in message
news:OarKMjbbDHA.2548 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hi:

I have a cube with multiple partitions. Since each partition has a
different
fact table, I have to add the same measures for each partition (is this
right?). I'm trying to add a new measure like this:

DSO.PartitionMeasure measure = (DSO.PartitionMeasure)
part.Measures.AddNew
("sales", DSO.SubClassTypes.sbclsRegular);

I got error message:
"Additional information: Object variable or With block variable not
set".

Anyone knows what it means?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Can I add measures for a partition using DSO?

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

Can I add measures for a partition using DSO? - 08-28-2003 , 06:05 PM

Re: Can I add measures for a partition using DSO? - 08-29-2003 , 03:52 PM