MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Pivot & list

  Asked By: Joseph    Date: Jun 18    Category: MOSS    Views: 1403

Currently our company uses excel to store a list and a pivot to analyze the data. We are in the process of re-writing it in MOSS 2007. Can we store the data in sharepoint lists and use KPI/? to do the same thing instead of excel. Can you please point me to right artcile on how to achieve pivot functionality with out excel and sql?



1 Answer Found

Answer #1    Answered By: Sunny Delacruz     Answered On: Jun 18

I dont think you can pivot  a list. You will have to Export it to excel  and then pivot. You can also use excel calulation services provided you have a moss  Enterprise version where you can punblish the pivoted list  and it will show as a excel file on the web.

The other approach would be to dump the data  into sql table create MOLAP cubes using SQL Server Analysis Services. You can define your KPI's . This inherently will giev you pivoted results and you will have a robust BI solution rather than relying on Excel files.

Didn't find what you were looking for? Find more on Pivot & list Or get search suggestion and latest updates.