Aggregate value

View previous topic View next topic Go down

Aggregate value

Post  ObjectiveC on Fri Mar 25, 2011 5:15 am

Hello everyone,

I was wondering if it's acceptable to calculate an aggregate_value by aggregating a measurement from the fact_table and by subtracting from a value located in another dimension.

ObjectiveC

Posts : 25
Join date : 2011-03-18

View user profile

Back to top Go down

Re: Aggregate value

Post  Jeff Smith on Fri Mar 25, 2011 9:00 am

I would give the measure a different name from what it has in the detailed fact table. If the measure is called "Balance" in the fact, I'd call it "adjusted balance" in the aggregate.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Aggregate value

Post  ObjectiveC on Fri Mar 25, 2011 11:25 am

Thank you for your advice Jeff, will do just that

ObjectiveC

Posts : 25
Join date : 2011-03-18

View user profile

Back to top Go down

Re: Aggregate value

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum