InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 05:55:10 GMT20http://www.sqlservercentral.com/Forums/Topic1379228-147-1.aspx[quote][b]Paul Hernández (10/31/2012)[/b][hr]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[/quote]I don't think that's possible, only administrators can do that.Wed, 31 Oct 2012 13:51:39 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1379228-147-1.aspxSorry 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 RegardsWed, 31 Oct 2012 08:26:17 GMTPaul Hernándezhttp://www.sqlservercentral.com/Forums/Topic1379228-147-1.aspxPlease do not crosspost. It wastes peoples time and fragments replies.Original thread with replies can be found here:[url]http://www.sqlservercentral.com/Forums/Topic1379230-363-1.aspx[/url]Wed, 31 Oct 2012 08:17:53 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1379228-147-1.aspxHi 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,Wed, 31 Oct 2012 04:26:35 GMTPaul Hernández