October 31, 2012 at 4:26 am
Hi everybody:
Right now I´m working in a BI solution and I received a set of tables with a multidimensional structure. I have a Fact table with transaction from customers and several dimensional tables. One of them is the KUNDE or customer table, in which the typical customer information is stored, like customer key, a key to another table (contact details), customer since date, etc. I also found numeric values in this table like "amount of purchases last 12 Month" or "Total shopping days" inside this table. That makes me wonder if it makes sense or not to store this measures inside the table, moreover, I'm building another table to store the customer data as a type II SCD and I´m not able to persuade the analyst to not include measures in this table.
What is your opinion about that?
Any comment would be appreciated.
Kind Regards,
October 31, 2012 at 8:17 am
Please do not crosspost. It wastes peoples time and fragments replies.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1379230-363-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 31, 2012 at 8:26 am
Sorry for that, I realized that my question has a better forum category after I summited here. I don´t know how to erase the post from this forum category.
Kind Regards
October 31, 2012 at 1:51 pm
Paul Hernández (10/31/2012)
Sorry for that, I realized that my question has a better forum category after I summited here. I don´t know how to erase the post from this forum category.Kind Regards
I don't think that's possible, only administrators can do that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply