Cubes 设计（完结）

selectthe cube name which you used when you add field in step 2

 

 

 

add"Amount" and "Location" to data area

 

 

At last, we can see the values there.

 

 

CA client side:

1/ install MS office with query option

 

2/install MS core XML service SP2
3/install OLE_DB_Provider_10.0
4/ Use theExcel pivot chart wizard to create the report

 

 

 

 

 

 

 

 

 

 

 

 

*ForSQL Server 2005, download and install Microsoft SQL Server 2005 AnalysisServices 9.0 OLE DB Provider.
*For SQLServer 2008, download and install Microsoft SQL Server 2005 Analysis Services10.0 OLE DB Provider.

Validate:
1/ launchthe Case Analyzer Client Configuration Tool

2/ after the configuration done, we can open one xls file under C:\Program Files (x86)\IBM\FileNet\Case Analyzer Client\ootbreport\xxxx

The excel file may contains old data inside, just click the ! button to refresh.