Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Aggregate value

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Aggregate value Empty Aggregate value

Post  ObjectiveC 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

Back to top Go down

Aggregate value Empty Re: Aggregate value

Post  Jeff Smith 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

Back to top Go down

Aggregate value Empty Re: Aggregate value

Post  ObjectiveC 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

Back to top Go down

Aggregate value Empty Re: Aggregate value

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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