Difference between revisions of "Analytica User FAQs"
(Added several standard tech support topics) |
|||
| Line 1: | Line 1: | ||
| − | + | = Training and Consulting Help = | |
| − | + | == How can I learn more about using Analytica? == | |
* Work through the ''Analytica Tutorial''. You can open it as an Adobe PDF document from inside Analytica by selecting '''Tutorial''' from the '''Help''' menu. The Tutorial is designed to help you learn the basics of navigating and running a model, and building a new model. | * Work through the ''Analytica Tutorial''. You can open it as an Adobe PDF document from inside Analytica by selecting '''Tutorial''' from the '''Help''' menu. The Tutorial is designed to help you learn the basics of navigating and running a model, and building a new model. | ||
| Line 11: | Line 11: | ||
| − | + | == Where can I find a consultant to hire for Analytica model building? == | |
* Lumina can refer you to an modeling consultant to help you build a model, or build it for you. Lumina has a few experts available, and can refer you to one of our affiliates -- all of whom we have certified as Analytica experts. Call us at 650-212-1212 to discuss your needs. | * Lumina can refer you to an modeling consultant to help you build a model, or build it for you. Lumina has a few experts available, and can refer you to one of our affiliates -- all of whom we have certified as Analytica experts. Call us at 650-212-1212 to discuss your needs. | ||
| − | + | == Can you help me re-code an existing Excel spreadsheet? == | |
Yes. Lumina and its affiliated consultants have a lot of experience translating Excel models into Analytica. Send us your spreadsheet in confidence, and we'll be glad to give you a quote. | Yes. Lumina and its affiliated consultants have a lot of experience translating Excel models into Analytica. Send us your spreadsheet in confidence, and we'll be glad to give you a quote. | ||
| − | + | ==I am a consultant with Analytica modeling experience. Can Lumina help put me in touch with potential clients? == | |
Yes. Please call us at 650-212-1212 to discuss what you can offer. If you are experienced with Analytica, and have expertise in a particular domain, you may be eligible to join our Affiliated Consultants Program. We can then refer clients with appropriate needs. | Yes. Please call us at 650-212-1212 to discuss what you can offer. If you are experienced with Analytica, and have expertise in a particular domain, you may be eligible to join our Affiliated Consultants Program. We can then refer clients with appropriate needs. | ||
| − | + | == How can I distribute my Analytica application for others to view or use? == | |
There are several ways to make your Analytica models available for others to review or use: | There are several ways to make your Analytica models available for others to review or use: | ||
| Line 37: | Line 37: | ||
= Application Integration = | = 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. | 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. | Use DbQuery and related functions in Chapter 21 of the Analytica User Guide. You'll need Analytica Enterprise. | ||
| Line 47: | Line 47: | ||
To query data from an OLAP server, such as Analysis Services, you'll need Analytica 4.0 Enterprise and will use the [[MdxQuery]] function. | 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 OLE linking for external applications that support it, such as Microsoft Office. | ||
| Line 53: | Line 53: | ||
* Use the new (to Analytica 4.0) [[LaunchConsoleProcess]]. 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. | * Use the new (to Analytica 4.0) [[LaunchConsoleProcess]]. 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. | + | * Analytica does not currently provide a direct COM, .NET or Java object interface. But, ADE does provide an API for COM and .NET. |
| + | |||
| + | = About ADE = | ||
| + | |||
| + | The Analytica Decision Engine (ADE) is sold as a separate product from Analytica. It allows you to make use of an Analytica model from the backend of a custom application, such as one written in a programming language like a Visual Basic, or from an web application using a technology such as Active Server Pages (ASP). | ||
| + | |||
| + | == Using ADE from Java == | ||
| + | |||
| + | The Analytica Decision Engine (ADE) exposes the full functionality of the Analyica Decision Engine with COM and ActiveX Automation programming interfaces (APIs). Calling ADE from a Java program requires a third-party component called a Java-to-COM bridge. There are several such products on the market, such as [http:www.ezjcom.com EZ JCom], [http:j-integra.intrinsync.com J-Integra], [http:www.nevaobject.com Java2Com], [http:danadler.com/jacob JACOB], [http:www.alphaworks.ibm.com/tech/bridge2java Interface Tool for Java], [http:www.jniwrapper.com Comfyj], and many others. Lumina does not have a recommendation on which bridge to use. | ||
| + | |||
| + | We highly recommend the use of ADE 4.0 (as opposed to ADE 3.1), even while it is still in beta, when doing this. Changes to the COM interface in 4.0 increase the interoperability in ways relevant to this integration. | ||
| + | |||
| + | = Installer Issues = | ||
| + | |||
| + | == Error 1607: Unable to install InstallShield Scripting Runtime. == | ||
| + | |||
| + | If you experience this error during the installation of Analytica, please visit [http://consumer.installshield.com/kb.asp?id=Q108340 this InstallShield Page], which describes the steps for resolving the problem: | ||
| + | |||
| + | == Error 1608: Unable to create InstallDriver instance, Return code: -2147024894 == | ||
| + | |||
| + | To resolve this problem, see [http://consumer.installshield.com/kb.asp?id=Q108440 this InstallShield page], which describes the possible causes and remedies. | ||
| + | |||
| + | = Memory Issues = | ||
| + | |||
| + | See: | ||
| + | * [[How To Access More Memory]] | ||
| + | * [[Managing Memory and CPU Time for large models]] | ||
| + | * [[Profiling Time and Memory Usage]] | ||
Revision as of 17:22, 23 February 2007
Training and Consulting Help
How can I learn more about using Analytica?
- Work through the Analytica Tutorial. You can open it as an Adobe PDF document from inside Analytica by selecting Tutorial from the Help menu. The Tutorial is designed to help you learn the basics of navigating and running a model, and building a new model.
- Attend a 2-day in-person training course. See Analytica training for dates, locations, and contents.
- Buy a Quick-start package: This gets you 4 hours coaching and help from an Analytica expert, via web-conference, phone, and email, at your convenience. The coach can give you tips, translate a spreadsheet into Analytica, review your model, and help you over obstacles.
- Review example models included with Analytica and others found within the Analytica Wiki.
- Attend Analytica User Group webinars.
- Watch for training articles posted to the Analytica Wiki.
Where can I find a consultant to hire for Analytica model building?
- Lumina can refer you to an modeling consultant to help you build a model, or build it for you. Lumina has a few experts available, and can refer you to one of our affiliates -- all of whom we have certified as Analytica experts. Call us at 650-212-1212 to discuss your needs.
Can you help me re-code an existing Excel spreadsheet?
Yes. Lumina and its affiliated consultants have a lot of experience translating Excel models into Analytica. Send us your spreadsheet in confidence, and we'll be glad to give you a quote.
I am a consultant with Analytica modeling experience. Can Lumina help put me in touch with potential clients?
Yes. Please call us at 650-212-1212 to discuss what you can offer. If you are experienced with Analytica, and have expertise in a particular domain, you may be eligible to join our Affiliated Consultants Program. We can then refer clients with appropriate needs.
How can I distribute my Analytica application for others to view or use?
There are several ways to make your Analytica models available for others to review or use:
- The Analytica Player is available free and lets users view and run Analytica models. Users can change inputs and generate results. They cannot modify the model structure or save model changes. You or your users can download a free copy of the Analytica Player.
- Analytica Power Player: When your end users need to save inputs, access databases, etc.
- Analytica Web Player (AWP): AWP lets people view and run models via a Web browser running as Web applications. You can upload models onto a server, and control access to them. AWP is currently in early testing. Please contact Lumina if you want to learn more.
- Analytica Decision Engine (ADE): For custom front-end user-interfaces or web apps.
Additional Reading
Reference Materials
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) LaunchConsoleProcess. 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.
About ADE
The Analytica Decision Engine (ADE) is sold as a separate product from Analytica. It allows you to make use of an Analytica model from the backend of a custom application, such as one written in a programming language like a Visual Basic, or from an web application using a technology such as Active Server Pages (ASP).
Using ADE from Java
The Analytica Decision Engine (ADE) exposes the full functionality of the Analyica Decision Engine with COM and ActiveX Automation programming interfaces (APIs). Calling ADE from a Java program requires a third-party component called a Java-to-COM bridge. There are several such products on the market, such as [http:www.ezjcom.com EZ JCom], [http:j-integra.intrinsync.com J-Integra], [http:www.nevaobject.com Java2Com], [http:danadler.com/jacob JACOB], [http:www.alphaworks.ibm.com/tech/bridge2java Interface Tool for Java], [http:www.jniwrapper.com Comfyj], and many others. Lumina does not have a recommendation on which bridge to use.
We highly recommend the use of ADE 4.0 (as opposed to ADE 3.1), even while it is still in beta, when doing this. Changes to the COM interface in 4.0 increase the interoperability in ways relevant to this integration.
Installer Issues
Error 1607: Unable to install InstallShield Scripting Runtime.
If you experience this error during the installation of Analytica, please visit this InstallShield Page, which describes the steps for resolving the problem:
Error 1608: Unable to create InstallDriver instance, Return code: -2147024894
To resolve this problem, see this InstallShield page, which describes the possible causes and remedies.
Memory Issues
See:
Comments
Enable comment auto-refresher