|
发表于 2014-6-23 04:47:33
|
显示全部楼层
Rayan12 wrote:I am fully agree with you not to setup 'Salesman' in Accounts Dimension, Reason is with out sales man it will be 10,000 Accounts list in Dimension. After breaking by Salesman in Accounts Dimension , Now list is small.
Won't it be 10,000 accounts with or without Salesmen? It's just that the salesmen allow you to create an intermediate consolidation, rather than rolling up the 10,000 accounts directly to "All Accounts"? I hope I'm understanding the problem correctly.
You could use a different level of intermediate consolidation, for example a letter of the alphabet, or the region if that will work (but it may not if accounts can be in multiple regions).
Or you could just have the 10,000 accounts rolling direcly into "All Accounts". I know it's ugly and really annoying if you accidentally leave the Properties Window open in subset explorer, then click on "All Accounts", because it takes a while to load all the properties. But that's a lot less ugly and annoying than having a cube that's wrong/difficult to use!
I think your proposed solution will work, but not sure what you mean by "Create 2nd mix Cubes". If you mean having two cubes then I think that's the wrong solution. You should only need one cube for this data, it just needs to be dimensioned correctly. But it sounds like Sales Man, Account and Category are the correct dimensions to use. |
|