Difference between revisions of "Analytica User FAQs"
Line 21: Line 21:
  
 
= Reference Materials =
 
= Reference Materials =
 +
 +
= Distributing Models =
 +
 +
== How can I distribute my Analytica application for others to view? ==
 +
 +
Options:
 +
* Analytica Player (free)
 +
* Analytica Power Player: When your end users need to save inputs, access databases, etc.
 +
* (coming soon) Analytica Web Player
 +
* Analytica Decision Engine (ADE): For custom front-end user-interfaces or web apps.
 +
 +
= Application Integration =
 +
 +
== How do I import data from my Excel spreadsheet into Analytica? ==
 +
 +
Use either Copy/Paste (to copy the data once), or OLE linking (to link it).
 +
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 query data in an external Database? ==
 +
 +
You'll need Analytica Enterprise.  Use the [[Ana:DbQuery]] and related functions, as described in the Analytica User Guide.
 +
 +
To query data from an OLAP server, such as Analysis Services, you'll need Analytica 4.0 Enterprise and will use the [[Ana:MdxQuery]] function.
 +
 +
== How can I call an external application from my model ==
 +
 +
* OLE linking (for external applications that support it)
 +
* Use the [[Ana:LaunchConsoleProcess]] function provides a quite general ability to integrate.
 +
 +
Analytica does not currently provide a direct COM, .NET or Java object interface.

Revision as of 22:48, 17 January 2007

Training Resources

What are the best ways to learn Analytica?

  • Go through the tutorial (access it from the Analytica Help menu).
  • Attend a 2-day in person training course.
  • Buy a Quick-start package, and have an expert modeler assist you in structuring your model initially.
  • Review example models included with Analytica and others found within the Analytica Wiki.
  • Attend regular Analytica User Group webinars.
  • Watch for training articles posted to the Analytica Wiki.

Consulting resources

Where can I find a consultant to hire for Analytica model building?

Can you help me re-code and existing Excel spreadsheet?

I am a consultant looking for Analytica modeling work. Can Lumina help put me in touch with potential clients?

Additional Reading

Reference Materials

Distributing Models

How can I distribute my Analytica application for others to view?

Options:

  • Analytica Player (free)
  • Analytica Power Player: When your end users need to save inputs, access databases, etc.
  • (coming soon) Analytica Web Player
  • Analytica Decision Engine (ADE): For custom front-end user-interfaces or web apps.

Application Integration

How do I import data from my Excel spreadsheet into Analytica?

Use either Copy/Paste (to copy the data once), or OLE linking (to link it). 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 query data in an external Database?

You'll need Analytica Enterprise. Use the Ana:DbQuery and related functions, as described in the Analytica User Guide.

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

How can I call an external application from my model

  • OLE linking (for external applications that support it)
  • Use the Ana:LaunchConsoleProcess function provides a quite general ability to integrate.

Analytica does not currently provide a direct COM, .NET or Java object interface.

Comments


You are not allowed to post comments.