Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
waveydavey
Starting Member
2 Posts |
 Posted - 2009-03-03 : 09:19:26
|
| I have a fact table2 dimensions customer and supplierI have created a calculated member to rank member by sales by supplierand another calculation which groups the ranks into top 50, second 50 etc. using a case statement.I need to create a report using the cube in excel and have supplier then drill down to groups of 50 and drill down to the appropriate members.Is it possible to add the grouping to the members dimension in order to drill down by rank group.Any help would be gratefully appreciated. |
|
|
waveydavey
Starting Member
2 Posts |
Posted - 2009-03-06 : 04:48:06
|
| Still needing some help.Going gray really quickly now.I may have been on the wrong track.I have a supplier dimension and customer dimensionThe customers are ranked by sales against each supplier using a calculation in measures.What I want to achieve is:In the row fields have suppliers then drill down to members but have the members grouped in blocks of 50.--+suppliers----+drilldown to groups of 50 (Top 50, Second 50 etc)------+drilldown further to the customers in the groups of 50 based on their rank.A solution to this will allow me to sleep soundly once more. |
 |
|
|
|
|
|
calculated member in dimension