Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
1:n relationship fact to dimension
The cube analysis product data. In the Fact table I'm counting products and in the dimensions the products are specified. But for example one product can have several failures. So what to do, not to loose any of the failures, but not to explode the fact table as well? It isn't possible to...- Pumuckel
- Post #5
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
1:n relationship fact to dimension
Hi @all, I'm quite new to OLAP. My issue now is, that I have some facts in my fact table, which are linked to several members in a dimension. How can I solve this problem, without blowing up my fact table and without loosing any relations to the dimension as well? Thx- Pumuckel
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
