Unfortunately, the only ways to add additional fields to the Analysis Cubes for Excel cubes require developer skills.
There are two ways of doing this:
-
Modify the original cubes. Microsoft does provide for download the original project source for these analysis cubes. You can find it on Partnersource, and I would assume also on customersource. Do a search for analysis cubes. This method isn't always the right choice. I would tend to choose this method if the data set behind the cube is very large (let's say 10+ or 20+ GB of data). This is the more efficient method. However, this is also more difficult to upgrade. When Microsoft releases a fix or upgrade, these changes will probably have to be recreated.
-
Create a Virtual Cube. SQL Analysis Services allows you to create a virtual cube based on a physical cube. In this case,you can create a "Sales With Details" cube, which is based upon Microsoft's Sales cube, but adds in additional details, like some custom user defined fields. The benefit is that this would be more likely to ugprade easily, but it will be lower performance since the entire cube will not be processed as a whole. I'm not absolutely sure of this, but this is my understanding.
I hope this helps. Take care.
orRon Draganowski
Senior Solution Developer
Olsen Thielen Technologies, Inc.
rdrag@ottechnologies.com
www.ottechnologies.com
Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski