Analytica User FAQs/Application Integration

How can I import data from Excel into Analytica?

Use either Copy/Paste (to copy the data once), or OLE linking for a hot link that will propagate any changes from Excel to Analytica. Set up a 2-D table in Analytica having the same number of cells as your Excel source, then Copy/Paste or Copy/Paste link.

How do I access data in an external Database?

Use DbQuery and related functions in Chapter 21 of the Analytica User Guide. You'll need Analytica Enterprise.

To query data from an OLAP server, such as Analysis Services, you'll need Analytica 4.0 Enterprise and will use the MdxQuery function.

How can I call an external application from my model

• Use OLE linking for external applications that support it, such as Microsoft Office.

• Use the new (to Analytica 4.0) RunConsoleProcess. It provides a general facility to call an external application, pass it data directly or via a file, let it run in parallel or wait for it to return and get results via a file.

• Analytica does not currently provide a direct COM, .NET or Java object interface. But, ADE does provide an API for COM and .NET.