×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Indicators in dimensional tables

Indicators in dimensional tables

Indicators in dimensional tables

(OP)
Hi,

On a star model, let assume I have one fact tables with the details of sales and a set of dimension tables (products/clients/stores).
The client table contain some indicators that come directly from the production system.

Now I need to make some queries on the star model and mix the indicators from the client table and from the fact tables :

for example :
select client.client_id,client.ind_client,sales.amount_sales,sales.date_sales
from client, sales
where client.client_id = sales.client_id


The result is that the ind_client indicator is multiplied for each sale record and if I sum this indicator for a set of clients, then the calculation will be wrong.

How can I resolve this issue ? By designing differently the star model or by writing differently the query ?

Many thanks for your answers

RE: Indicators in dimensional tables

What's an example of the indicator?   

RE: Indicators in dimensional tables

(OP)
These are customers indicators like annual income. These indicators are not calculated in the datawarehouse.

RE: Indicators in dimensional tables

Typically, you don't aggregate dimension attributes.  In this scenario, one would typically create an Income Range attribute.  For example:

< $20,000
$20,000 to $40,000
$40,000 to $60,000
etc.
etc.

You can then group on the range.

 

RE: Indicators in dimensional tables

What is the business question you are trying to answer?

Are these indicators slowly changing over time?

In your original question, why would you sum the indicator, but not the amount_sales?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close