<div>
<div class="content wysiwyg-content">
Question: 
Can an Excel 2007 PivotTable connected to an SSAS 2005 SP2 cube expand a dimension to show facts in a single column? (see Scenario B, below for an example) 
i.e. 
Project Expenditure (all time) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Scenario A - this is achieveable: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hardware &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Software &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Services 
ProjectX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;125,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;75,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100,000 
ProjectY &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100,000 
ProjectZ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;150,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;150,000 
Grand Total &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;375,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;225,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;350,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Scenario B - is this layout achieveable:? &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
- ProjectX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;300,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; &nbsp;Hardware &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;125,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; &nbsp;Software &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;75,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; &nbsp;Services &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
+ ProjectY &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;250,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
+ ProjectZ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;400,000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 
If it is possible, what needs to be done in SSAS 2005 SP2 and/or Excel 2007 to achieve the desired result?
</div>
</div>

Question:
Can an Excel 2007 PivotTable connected to an SSAS 2005 SP2 cube expand a dimension to show facts in a single column? (see Scenario B, below for an example)
i.e.
Project Expenditure (all time)			
Scenario A - this is achieveable:			
	Hardware	Software	Services
ProjectX	125,000	75,000	100,000
ProjectY	100,000	50,000	100,000
ProjectZ	150,000	100,000	150,000
Grand Total	375,000	225,000	350,000	
			
Scenario B - is this layout achieveable:?		
	USD		
- ProjectX	300,000		
   Hardware	125,000		
   Software	75,000		
   Services	100,000		
+ ProjectY	250,000		
+ ProjectZ	400,000		

If it is possible, what needs to be done in SSAS 2005 SP2 and/or Excel 2007 to achieve the desired result?

Can Excel expand a dimension to show facts in rows?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.