>Hello comunity
>
>I would like to have your opinion about the best tool to use to build OLAP analyzes in VisualFox pro 9.
>Is there any open source software?
>Advise to use the Power of Excel pivot?
>Can you give me some software which can create my query with parameters in TSQL.
>
>What your suggestions ?
>
>Many thanks
>Luis Santos

Excel Pivot tables are powerful tools and can be used readily in VFP via Office Automation.

Here's an excerpt of some code I wrote for a client that creates an Excel pivot table from VFP data.

oSheet.Range("A5:D"+ ALLTRIM(STR(ln_recordcount +9))).Columns.Autofit()
    oSheet.Range("D6:D"+ ALLTRIM(STR(ln_recordcount +9))).NumberFormat = "###,###,###.00"
    oSourceData = oBook.Sheets[2].Range("A5:D"+ ALLTRIM(STR(ln_recordcount+5)))
    oDestination = oBook.Sheets[1].Range("A7")
    oPivotTable = oBook.Sheets[1].PivotTableWizard(xlDatabase, oSourceData, ;
      oDestination, "Location Summary", .T., .T.)
    oPivotTable.Addfields("postingdate","code")
    oPivotTable.PivotFields("totaldep").Orientation = xlDataField
    oPivotTable.PivotFields["Sum of totaldep"].NumberFormat = "###,###,###.00"
    oBook.ShowPivotTableFieldList = .F.
    oExcel.CommandBars("PivotTable").Visible = .F.
    oBook.Sheets[2].Activate()

I got started by using the book "Microsoft Office Automation with Visual FoxPro" by Tamar Granor and Della Martin.