AMO: Could I processfull on a measuregroup ONLY?

hi, friends,

I add/delete a measure in AMO. I want to know I need to processfull the whole cube or ONLY the measuregroup that associated?

Thanks!

I am quoting the Darren Gospbell's Reply to this quetion raised earlier in this forum:

"If you add a measure you are changing the structure of the cube which will invalidate the cube, the easiest way to get the cube "fully operational" again would be to do a processFull. The same thing applies when removing a measure.

Thanks

Subhash Subramanyam

|||

You mean that I need to process the WHOLE cube?

But I only process the measuregroup associated to the measure I just added, and no error reported.

I still think I need only to process the measuregroup associated.

What do you think?

Thanks.

|||

You only need to process the MeasureGroup. It is true that adding or removing a measure is a structural change that would clear the data (so re-processing is required), but the MeasureGroup is the most immediate parent containing the Partitions (who store the actual data) and Aggregations (who would need to be re-generated), so processing just the MeasureGroup should be enough.

But when saving the MeasureGroup (because you deleted the Measure), you might need to re-save the entire cube (with the ExpandFull option passed to the Update method) if you have Perspectives objects using that Measure.

Adrian Dumitrascu

|||

Thank you all!

AMO: Could I processfull on a measuregroup ONLY?

hi, friends,

I add/delete a measure in AMO. I want to know I need to processfull the whole cube or ONLY the measuregroup that associated?

Thanks!

I am quoting the Darren Gospbell's Reply to this quetion raised earlier in this forum:

"If you add a measure you are changing the structure of the cube which will invalidate the cube, the easiest way to get the cube "fully operational" again would be to do a processFull. The same thing applies when removing a measure.

Thanks

Subhash Subramanyam

|||

You mean that I need to process the WHOLE cube?

But I only process the measuregroup associated to the measure I just added, and no error reported.

I still think I need only to process the measuregroup associated.

What do you think?

Thanks.

|||

You only need to process the MeasureGroup. It is true that adding or removing a measure is a structural change that would clear the data (so re-processing is required), but the MeasureGroup is the most immediate parent containing the Partitions (who store the actual data) and Aggregations (who would need to be re-generated), so processing just the MeasureGroup should be enough.

But when saving the MeasureGroup (because you deleted the Measure), you might need to re-save the entire cube (with the ExpandFull option passed to the Update method) if you have Perspectives objects using that Measure.

Adrian Dumitrascu

|||

Thank you all!

Aluminum block with steel liner

What are the amnufacturing problem associated with cast in steel line
with aluminum dia casting process. Will it be better to insert the steel
liners after the machining process on the aluminum block.
*** Sent via Developersdex http://www.examnotes.net ***Since SQL Server is set associative it shouldn't matter the order in which
you do the join.
"joe inciong" wrote:

> What are the amnufacturing problem associated with cast in steel line
> with aluminum dia casting process. Will it be better to insert the steel
> liners after the machining process on the aluminum block.
>
> *** Sent via Developersdex http://www.examnotes.net ***
>|||On Wed, 15 Feb 2006 09:26:27 -0800, "Matthew Speed"
<MatthewSpeed@.discussions.microsoft.com> wrote:
>Since SQL Server is set associative it shouldn't matter the order in which
>you do the join.
>"joe inciong" wrote:
>
LOL.
J.|||This guy is way past lost.
Is there really a news group for aluminum die casting?
Sorry... I just answered my own question.
rec.crafts.metalworking
"Matthew Speed" <MatthewSpeed@.discussions.microsoft.com> wrote in message
news:42AA28A6-B5C5-4E7F-AFA5-327514E3D5E5@.microsoft.com...
> Since SQL Server is set associative it shouldn't matter the order in which
> you do the join.
> "joe inciong" wrote:
>|||Steel liners in an aluminum block sounds like a piston engine to me...
"Raymond D'Anjou" wrote:

> This guy is way past lost.
> Is there really a news group for aluminum die casting?
> Sorry... I just answered my own question.
> rec.crafts.metalworking
> "Matthew Speed" <MatthewSpeed@.discussions.microsoft.com> wrote in message
> news:42AA28A6-B5C5-4E7F-AFA5-327514E3D5E5@.microsoft.com...
>
>|||Yes. Diesel engine especially also small engine like in lawn tractors. Most
cars engine are either cast iron or alumnin. Wait a miniute am i replyin in
the wrgon group?
Yes. Diesel engine and small engine like in lawn tractors. Most cars engine
is either cast iron or aluminum with no sleeves but there are some.
"Matthew Speed" <MatthewSpeed@.discussions.microsoft.com> wrote in message
news:5788352E-D44A-4BED-8C80-D67CB3644CB4@.microsoft.com...
> Steel liners in an aluminum block sounds like a piston engine to me...
> "Raymond D'Anjou" wrote:
>|||
"Grant" wrote:

> Yes. Diesel engine especially also small engine like in lawn tractors. Mos
t
> cars engine are either cast iron or alumnin. Wait a miniute am i replyin i
n
> the wrgon group?
>
It depends. Are you a SQL Server user or was this a response to a very
badly cross-posted message. My original response was just to have fun with
the fact that I could make an association between RDBMS and reciprocating
engine technology. If you are trying to give a real answer to the original
question take it to the correct group. This group is going to take it
absolutely nowhere.|||Opps. I was having fun until I offended you and yes I am a sql programmer.
Every one has a different sense of humor. It's a big world and it revolves
around the sun not you.
Cheer and now I will run away....
"Matthew Speed" <MatthewSpeed@.discussions.microsoft.com> wrote in message
news:C1FDD56B-F659-4A91-9C91-57538D9F6EF8@.microsoft.com...
>
> "Grant" wrote:
>
> It depends. Are you a SQL Server user or was this a response to a very
> badly cross-posted message. My original response was just to have fun
> with
> the fact that I could make an association between RDBMS and reciprocating
> engine technology. If you are trying to give a real answer to the
> original
> question take it to the correct group. This group is going to take it
> absolutely nowhere.|||"Grant" <email@.nowhere.com> wrote in message
news:uLAFGpvMGHA.3264@.TK2MSFTNGP11.phx.gbl...
> Opps. I was having fun until I offended you and yes I am a sql programmer.
> Every one has a different sense of humor. It's a big world and it revolves
> around the sun not you.
Not nearly as much as you offended me. You completely left out the plastic
lawn mower engines. You know, the ones with the little balls that bounce
around when you mow the lawn?

>
> Cheer and now I will run away....
>|||LAMO!!! my ten month old son has that.
"Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
news:%23dtGE0wMGHA.516@.TK2MSFTNGP15.phx.gbl...
> "Grant" <email@.nowhere.com> wrote in message
> news:uLAFGpvMGHA.3264@.TK2MSFTNGP11.phx.gbl...
> Not nearly as much as you offended me. You completely left out the
> plastic
> lawn mower engines. You know, the ones with the little balls that bounce
> around when you mow the lawn?
>
>