Difference between revisions of "Transferring Data Between ACP and Desktop Analytica"
| Line 1: | Line 1: | ||
| + | [[Category: Analytica Cloud Player]] | ||
[[Analytica Cloud Player|<< ACP]] | [[Analytica Cloud Player|<< ACP]] | ||
== Moving Model Results from ACP to Excel == | == Moving Model Results from ACP to Excel == | ||
| − | Often one wants to move the results of a model run in ACP and transfer them into Excel. There a few ways of doing this. At the upper right of the result table, there is a Copy Table icon. If you click it, the table's contents as displayed in ACP is copied to the clipboard. Then just switch focus to Excel and select Paste. | + | Often one wants to move the results of a model run in [[Analytica Cloud Player]] (ACP) and transfer them into Excel. There a few ways of doing this. At the upper right of the result table, there is a Copy Table icon. If you click it, the table's contents as displayed in ACP is copied to the clipboard. Then just switch focus to Excel and select Paste. |
If the result table has more than 2 dimensions, you can download the results for the entire table as a text file by right clicking the Copy Table icon, and select the 'Download results file'. | If the result table has more than 2 dimensions, you can download the results for the entire table as a text file by right clicking the Copy Table icon, and select the 'Download results file'. | ||
| Line 11: | Line 12: | ||
== Database == | == Database == | ||
| − | It is possible to connect models in ACP to a remote database (i.e. a database on another computer) using an ODBC connection. With this type of connection, your model can read in input data from the database and write out model results to the database. Setting up the database connection may require some assistance from us so just email us at acp@lumina.com for help. | + | It is possible to connect models in ACP to a remote database (i.e. a database on another computer) using an ODBC connection. With this type of connection, your model can read in input data from the database and write out model results to the database. Setting up the database connection may require some assistance from us so just email us at [mailto:acp@lumina.com acp@lumina.com] for help. |
| + | |||
| + | ==See Also== | ||
| + | * [[Media:Getting results from AWP to Excel.mp4|Getting results from AWP to Excel.mp4]] | ||
| + | * [[Analytica Cloud Player]] | ||
Revision as of 01:07, 20 February 2016
Moving Model Results from ACP to Excel
Often one wants to move the results of a model run in Analytica Cloud Player (ACP) and transfer them into Excel. There a few ways of doing this. At the upper right of the result table, there is a Copy Table icon. If you click it, the table's contents as displayed in ACP is copied to the clipboard. Then just switch focus to Excel and select Paste.
If the result table has more than 2 dimensions, you can download the results for the entire table as a text file by right clicking the Copy Table icon, and select the 'Download results file'.
Watch this video to see these two approaches demonstrated.
Database
It is possible to connect models in ACP to a remote database (i.e. a database on another computer) using an ODBC connection. With this type of connection, your model can read in input data from the database and write out model results to the database. Setting up the database connection may require some assistance from us so just email us at acp@lumina.com for help.
Enable comment auto-refresher