dbTalk Databases Forums  

Non Additive Measure

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap Non Additive Measure

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


Discuss Non Additive Measure in the microsoft.public.sqlserver.olap forum.



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

Default Non Additive Measure - 10-05-2004 , 12:22 PM





I have a measure that "can" be additive but we decided
not to aggregate it in any of the dimensions. Also, this
measure is only relevant to one of our dimensions. The
measure can be additive and the client decided not to
have this aggregate. With that said, should I just make
this an attribute of its dimension? Or keep it as a
measure?

Reply With Quote
  #2  
Old   
Jamie
 
Posts: n/a

Default RE: Non Additive Measure - 10-05-2004 , 01:01 PM





Can you be a bit more specific?

Regards
Jamie Thomson

"anonymous (AT) discussions (DOT) microsoft.com" wrote:

Quote:
I have a measure that "can" be additive but we decided
not to aggregate it in any of the dimensions. Also, this
measure is only relevant to one of our dimensions. The
measure can be additive and the client decided not to
have this aggregate. With that said, should I just make
this an attribute of its dimension? Or keep it as a
measure?

Reply With Quote
  #3  
Old   
 
Posts: n/a

Default RE: Non Additive Measure - 10-05-2004 , 01:42 PM


The measure is "distance". The dimension
is "Origin/Destination (One-Way). This dimension
agregates to a round-trip but we are not going to use
the "distance" measure to aggregate. Should "distance" be
an attribute?

Quote:
-----Original Message-----
Can you be a bit more specific?

Regards
Jamie Thomson

"anonymous (AT) discussions (DOT) microsoft.com" wrote:

I have a measure that "can" be additive but we decided
not to aggregate it in any of the dimensions. Also,
this
measure is only relevant to one of our dimensions.
The
measure can be additive and the client decided not to
have this aggregate. With that said, should I just
make
this an attribute of its dimension? Or keep it as a
measure?

.

Reply With Quote
  #4  
Old   
Jamie
 
Posts: n/a

Default RE: Non Additive Measure - 10-05-2004 , 01:55 PM


This definately sounds like an attribute of the "Origin/Destination"
relationship to me hence it should be a member property of the
"Origin/Destination (One-Way)" dimension.

What is the purpose of your cube?
What is it intended to meaasure?
What is the grain of the cube?

Regards
Jamie Thomson

"anonymous (AT) discussions (DOT) microsoft.com" wrote:

Quote:
The measure is "distance". The dimension
is "Origin/Destination (One-Way). This dimension
agregates to a round-trip but we are not going to use
the "distance" measure to aggregate. Should "distance" be
an attribute?

-----Original Message-----
Can you be a bit more specific?

Regards
Jamie Thomson

"anonymous (AT) discussions (DOT) microsoft.com" wrote:

I have a measure that "can" be additive but we decided
not to aggregate it in any of the dimensions. Also,
this
measure is only relevant to one of our dimensions.
The
measure can be additive and the client decided not to
have this aggregate. With that said, should I just
make
this an attribute of its dimension? Or keep it as a
measure?

.

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top