No problem Lynn! Your feedback was very important for me! Thanks for that!!

Regards,

Pedro

Lynn,

Again... I know that If I use this aggregate table I'll lose some detail information that your refer! I told you from the begining that I can have a requirement...

Dear Lynn,

Thank you for your reply.

I didn't wrote that your questions were not valid.. Are very important if I need more information like you referred:

"How many items of each...

@paul-2,

I'm also a teacher, for that reason I'm being soo specific and trying to get detail information about Kimball approaches.

Regards,

@Lynn,

You're always answering with a question... and...

Thank you for the reply... I understand you if you assume that the same product in the same transaction could have different discounts, correct?

Take a look here:

http://en.wikipedia.org/wiki/Fact_table

Transactional

A transactional...

Of course...

One thing is the grain by the transaction (CASE 01)

Another thing is the grain by the transaction per item line (CASE 02)

Where in CASE 01 you have a row...

Exactly... at the order level which has the TransactionID.

The grain is the transaction...

But in a Transaction Fact Table Type the grain is the transaction per line item as Kimball refer in his methodology.

Regards, 🙂

Pedro

HI Lynn,

Thanks again... I know you the tips and suggestions you gave me... I understand that you are trying to help me! 🙂

My issue is about the summary table... that...

Thank you Lynn for you reply.

Again, I need to have a Fact Table (CASE 01) with just the information stored in the ORDER_Header (DATE, CUSTOMER and TRANSACTIONID) and the aggregate...

Paul,

Thanks again for your reply...

I made the CASE 02 just for explain my issue.

And finally you answered my question! 🙂

Ok... you think the CASE 01 is a Summary Table... of...

Paul and Lynn,

Thank you for your replies! Although I think you are not focusing in my issue... I know I can include unitPrice (but I may decide to not include...

Thank you for the reply!

Ok... I missed the quantity sold, but the doubt still present.

CASE 02

Date Customer TransactionIDProductIDQuantitySales Ammount

20120101CLI01FAC0005PROD013300 €

20120101CLI01FAC0005PROD022500 €

20120101CLI01FAC0006PROD011100 €

20120101CLI02FAC0007PROD015500 €

20120102CLI01FAC0008PROD014340 €

20120102CLI02FAC0009PROD016560 €

The question is objective... Which type...

The CASE 02 is the fact Table that has the more detailed data... And from them you can see that the count of products from each order(transaction) is

FAC00052

FAC00061

FAC00071

FAC00081

FAC00091

Correct?

Now, you can...

HI Paul,

Thanks for you reply.

Imagine the case that the previous step demonstrate replicate the orginal sales invoice... That you in a E-R model has the something like this to represent...