Get Subdimension (outrigger) count (built using Bridge Table)

View previous topic View next topic Go down

Get Subdimension (outrigger) count (built using Bridge Table)

Post  raghuk on Thu Sep 10, 2009 3:02 pm

Hello,

How do I get the subdimension count?

I have a table

FactPolicyAggregate
DimAutoVehicles
DimAutoDrivers

AutoVehicles and AutoDrivers have effective and expiration dates.

How do I get the number of AutoVehicles and AutoDrivers, who are

1) Active as of the end of month.
2) Not active at the end of the month?

Thanks,

Raghu.

raghuk

Posts : 8
Join date : 2009-06-16

View user profile

Back to top Go down

Re: Get Subdimension (outrigger) count (built using Bridge Table)

Post  ngalemmo on Fri Sep 18, 2009 11:20 am

Usually, things like this are handled by building a snapshot aggregate table. Trying to do this as queries against a detailed fact table using traditional BI tools is problematic and slow. It gets worse if the user wishes to do time comparisons (such as year over year). Building a snapshot allows you to embed classification logic in an ETL procedure or stored procedure, making queries simple and fast for the end user.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Get Subdimension (outrigger) count (built using Bridge Table)

Post  raghuk on Fri Sep 18, 2009 1:53 pm

Nick,

Thank you for your insightful answers, as always.

So, is it a correct statement if I say 'Aggregate tables should always be a star schema for ease of operations'?

Thanks,

Raghu.

raghuk

Posts : 8
Join date : 2009-06-16

View user profile

Back to top Go down

Re: Get Subdimension (outrigger) count (built using Bridge Table)

Post  ngalemmo on Fri Sep 18, 2009 2:25 pm

Yes.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Get Subdimension (outrigger) count (built using Bridge Table)

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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