Difference between revisions of "MS Excel"

From DataSelf Knowledge Base
Jump to navigation Jump to search
 
Line 9: Line 9:
  
 
== MS Excel as a Report Writer ==
 
== MS Excel as a Report Writer ==
 +
 +
[[Excel PivotTable from SQL Table or View]]
  
 
[[Excel OLAP Pivot Table Reporting]]
 
[[Excel OLAP Pivot Table Reporting]]
Line 16: Line 18:
 
[[Excel Troubleshooting]]
 
[[Excel Troubleshooting]]
  
[[Excel PivotTable from SQL Table or View]]
 
 
== [[Excel Lock Files]] ==
 
( " … is locked for editing by …" message)
 
  
 
== [[Excel Reporting and Distribution Module]] ==
 
== [[Excel Reporting and Distribution Module]] ==

Latest revision as of 23:36, 13 March 2015

Excel can be used as an end-user report writer with data sources of the data warehouse SQL views, and from SQL cubes.

MS Excel as a Report Writer

Excel PivotTable from SQL Table or View

Excel OLAP Pivot Table Reporting

Excel Features

Excel Troubleshooting


Excel Reporting and Distribution Module