The basis for this post is here:
A many-to-many relationship exists in the database to record the ownership of an asset.
The result I want to produce in the cube is (Company is divided by pipes, we see comp A owend asset 1 in 1996, 1997, 2002 and 2003; Company B in 1998, 1999, and 2000): (imagine data for each column is financial)
Company A | Company B | Company C |
Company A | Company D
1996 1997 | 1998 1999 2000 | 2001
| 2002 | 2003
View Complete Post