Analytica Docs - User contributions [en]

User:AManandhar

2012-06-29T21:29:06Z

AManandhar:

[[Internal:AManandhar]]

[[Internal:UpgradeNotes]]

[[Internal:RLM8]]

[[Internal:AutoUpdateCheck]]

[[Internal:AWPDecisions]]

[[Ana:InstallerDesign/Welcome]]

[[Ana:AutomaticPatching]]

[[Internal:Webserver]]

[[Internal:ManualActivation]]

[[Internal:SalesForce Apex Code]]

=Links=

Salesforce Data Backup: http://sfdc.arrowpointe.com/2008/04/28/do-you-backup-your-salesforce-data/ <br>
Importing CSV data to SQL Server: http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html

<math>
\mbox{erfc}(x) =
\frac{2}{\sqrt{\pi}} \int_x^{\infty} e^{-t^2}\,dt =
\frac{e^{-x^2}}{x\sqrt{\pi}}\sum_{n=0}^\infty (-1)^n \frac{(2n)!}{n!(2x)^{2n}}
</math>

<math>\sqrt{2}</math>

=Internal Links=

Upgrade Website: http://www.lumina.com/ana/enterLic.htm <br>
Price calculator: http://awp.analyticaonline.com/pricingpolicy/Default.aspx

IPs
Cubeplan.com: 173.201.21.179

[[File:jpatetest.jpg]]

User:AManandhar

2012-06-26T10:18:46Z

AManandhar:

[[Internal:AManandhar]]

[[Internal:UpgradeNotes]]

[[Internal:RLM8]]

[[Internal:AutoUpdateCheck]]

[[Internal:AWPDecisions]]

[[Ana:InstallerDesign/Welcome]]

[[Ana:AutomaticPatching]]

[[Internal:Webserver]]

[[Internal:ManualActivation]]

=Links=

Salesforce Data Backup: http://sfdc.arrowpointe.com/2008/04/28/do-you-backup-your-salesforce-data/ <br>
Importing CSV data to SQL Server: http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html

<math>
\mbox{erfc}(x) =
\frac{2}{\sqrt{\pi}} \int_x^{\infty} e^{-t^2}\,dt =
\frac{e^{-x^2}}{x\sqrt{\pi}}\sum_{n=0}^\infty (-1)^n \frac{(2n)!}{n!(2x)^{2n}}
</math>

<math>\sqrt{2}</math>

=Internal Links=

Upgrade Website: http://www.lumina.com/ana/enterLic.htm <br>
Price calculator: http://awp.analyticaonline.com/pricingpolicy/Default.aspx

IPs
Cubeplan.com: 173.201.21.179

[[File:jpatetest.jpg]]

User:AManandhar

2012-06-22T17:50:29Z

AManandhar: /* Links */

[[Internal:AManandhar]]

[[Internal:UpgradeNotes]]

[[Internal:RLM8]]

[[Internal:AutoUpdateCheck]]

[[Internal:AWPDecisions]]

[[Ana:InstallerDesign/Welcome]]

[[Ana:AutomaticPatching]]

[[Internal:Webserver]]
[[Internal:ManualActivation]]

=Links=

Salesforce Data Backup: http://sfdc.arrowpointe.com/2008/04/28/do-you-backup-your-salesforce-data/ <br>
Importing CSV data to SQL Server: http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html

<math>
\mbox{erfc}(x) =
\frac{2}{\sqrt{\pi}} \int_x^{\infty} e^{-t^2}\,dt =
\frac{e^{-x^2}}{x\sqrt{\pi}}\sum_{n=0}^\infty (-1)^n \frac{(2n)!}{n!(2x)^{2n}}
</math>

<math>\sqrt{2}</math>

=Internal Links=

Upgrade Website: http://www.lumina.com/ana/enterLic.htm <br>
Price calculator: http://awp.analyticaonline.com/pricingpolicy/Default.aspx

IPs
Cubeplan.com: 173.201.21.179

[[File:jpatetest.jpg]]

User:AManandhar

2012-06-22T17:00:25Z

AManandhar: /* Links */

[[Internal:AManandhar]]

[[Internal:UpgradeNotes]]

[[Internal:RLM8]]

[[Internal:AutoUpdateCheck]]

[[Internal:AWPDecisions]]

[[Ana:InstallerDesign/Welcome]]

[[Ana:AutomaticPatching]]

[[Internal:Webserver]]
[[Internal:ManualActivation]]

=Links=

Salesforce Data Backup: http://sfdc.arrowpointe.com/2008/04/28/do-you-backup-your-salesforce-data/ <br>
Importing CSV data to SQL Server: http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html

<math>
\mbox{erfc}(x) =
\frac{2}{\sqrt{\pi}} \int_x^{\infty} e^{-t^2}\,dt =
\frac{e^{-x^2}}{x\sqrt{\pi}}\sum_{n=0}^\infty (-1)^n \frac{(2n)!}{n!(2x)^{2n}}
</math>

=Internal Links=

Upgrade Website: http://www.lumina.com/ana/enterLic.htm <br>
Price calculator: http://awp.analyticaonline.com/pricingpolicy/Default.aspx

IPs
Cubeplan.com: 173.201.21.179

[[File:jpatetest.jpg]]

User:AManandhar

2012-06-20T16:13:33Z

AManandhar:

[[Internal:AManandhar]]

[[Internal:UpgradeNotes]]

[[Internal:RLM8]]

[[Internal:AutoUpdateCheck]]

[[Internal:AWPDecisions]]

[[Ana:InstallerDesign/Welcome]]

[[Ana:AutomaticPatching]]

[[Internal:Webserver]]
[[Internal:ManualActivation]]

=Links=

Salesforce Data Backup: http://sfdc.arrowpointe.com/2008/04/28/do-you-backup-your-salesforce-data/ <br>
Importing CSV data to SQL Server: http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html

<math>
\operatorname{erfc}(x) =
\frac{2}{\sqrt{\pi}} \int_x^{\infty} e^{-t^2}\,dt =
\frac{e^{-x^2}}{x\sqrt{\pi}}\sum_{n=0}^\infty (-1)^n \frac{(2n)!}{n!(2x)^{2n}}
</math>

=Internal Links=

Upgrade Website: http://www.lumina.com/ana/enterLic.htm <br>
Price calculator: http://awp.analyticaonline.com/pricingpolicy/Default.aspx

IPs
Cubeplan.com: 173.201.21.179

[[File:jpatetest.jpg]]

User:AManandhar

2012-06-18T17:02:14Z

AManandhar:

[[Internal:AManandhar]]

[[Internal:UpgradeNotes]]

[[Internal:RLM8]]

[[Internal:AutoUpdateCheck]]

[[Internal:AWPDecisions]]

[[Ana:InstallerDesign/Welcome]]

[[Ana:AutomaticPatching]]

[[Internal:Webserver]]

=Links=

Salesforce Data Backup: http://sfdc.arrowpointe.com/2008/04/28/do-you-backup-your-salesforce-data/ <br>
Importing CSV data to SQL Server: http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html

<math>
\operatorname{erfc}(x) =
\frac{2}{\sqrt{\pi}} \int_x^{\infty} e^{-t^2}\,dt =
\frac{e^{-x^2}}{x\sqrt{\pi}}\sum_{n=0}^\infty (-1)^n \frac{(2n)!}{n!(2x)^{2n}}
</math>

=Internal Links=

Upgrade Website: http://www.lumina.com/ana/enterLic.htm <br>
Price calculator: http://awp.analyticaonline.com/pricingpolicy/Default.aspx

IPs
Cubeplan.com: 173.201.21.179

[[File:jpatetest.jpg]]

File:CoordinateTransformation.png

2012-05-18T19:23:37Z

AManandhar:

Excel Functions from ADE

2012-05-07T19:49:34Z

AManandhar: /* The Issue */

=The Issue=
Excel spreadsheet functions when invoked from an ADE Application through IIS seems to hang when ADE tries to bind to an instance of an Excel COM Object. This issue seems to arise because the user invoking Excel COM Objects (by default NETWORK SERVICES) does not have enough permissions. Two possible solutions are provided below for this issue.

=The Fix=

#Create a new standard user. E.g. 'ExcelRunner' with a password.
#Set the Excel COM Objects to be invoked by this newly created user instead of the default Launching User.
##Launch DCOM Config: Start→Administrative Tools→Component Services→Computers→My Computer→DCOM Config.
##*Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command Start > Run > 'mmc comexp.msc /32'
##Right click on 'Microsoft Excel Application' and then on 'Properties'.
##Click on the Identity tab.
##Choose "This user." as the account to run Excel Applications and type in the username and password of the new account.
##Click OK.
#Give the new user Read/Write permission on the folder with the Excel file.

=Alternative Fix=

#Navigate to the folder given below:
#* Windows 64 Bit: C:\Windows\SysWOW64\config\systemprofile\
#* Windows 32 Bit: C:\Windows\System32\config\systemprofile\
#Create directory "Desktop"
#Give the NETWORK SERVICES user Read/Write permission on the Desktop folder.
#Give the NETWORK SERVICES user Read/Write permission on the AppData folder in the same directory.
#Give the NETWORK SERVICES user Read/Write permission on the folder with the Excel file.

Excel Functions from ADE

2012-05-07T19:49:02Z

AManandhar:

=The Issue=
Excel spreadsheet functions when invoked from an ADE Application through IIS seems to hang when ADE tries to bind to an instance of an Excel COM Object. This issue seems to arise because the user invoking Excel COM Objects (by default NETWORK SERVICES) does not have enough permissions. Two possible fixes are provided below for this issue.

=The Fix=

#Create a new standard user. E.g. 'ExcelRunner' with a password.
#Set the Excel COM Objects to be invoked by this newly created user instead of the default Launching User.
##Launch DCOM Config: Start→Administrative Tools→Component Services→Computers→My Computer→DCOM Config.
##*Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command Start > Run > 'mmc comexp.msc /32'
##Right click on 'Microsoft Excel Application' and then on 'Properties'.
##Click on the Identity tab.
##Choose "This user." as the account to run Excel Applications and type in the username and password of the new account.
##Click OK.
#Give the new user Read/Write permission on the folder with the Excel file.

=Alternative Fix=

#Navigate to the folder given below:
#* Windows 64 Bit: C:\Windows\SysWOW64\config\systemprofile\
#* Windows 32 Bit: C:\Windows\System32\config\systemprofile\
#Create directory "Desktop"
#Give the NETWORK SERVICES user Read/Write permission on the Desktop folder.
#Give the NETWORK SERVICES user Read/Write permission on the AppData folder in the same directory.
#Give the NETWORK SERVICES user Read/Write permission on the folder with the Excel file.

Excel Functions from ADE

2012-05-07T19:47:43Z

AManandhar: /* The Fix */

=The Issue=
Excel spreadsheet functions when invoked from an ADE Application through IIS seems to hang when ADE tries to bind to an instance of an Excel COM Object.

=The Fix=
Configuring the following settings on the machine seem to fix this issue.

#Create a new standard user. E.g. 'ExcelRunner' with a password.
#Set the Excel COM Objects to be invoked by this newly created user instead of the default Launching User.
##Launch DCOM Config: Start→Administrative Tools→Component Services→Computers→My Computer→DCOM Config.
##*Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command Start > Run > 'mmc comexp.msc /32'
##Right click on 'Microsoft Excel Application' and then on 'Properties'.
##Click on the Identity tab.
##Choose "This user." as the account to run Excel Applications and type in the username and password of the new account.
##Click OK.
#Give the new user permission to write files in the directory with the Excel file.

=Alternative Fix=
This issue seems to arise because the user invoking Excel COM Objects (by default NETWORK SERVICES) does not seem to have enough permissions.

#Navigate to the folder given below:
#* Windows 64 Bit: C:\Windows\SysWOW64\config\systemprofile\
#* Windows 32 Bit: C:\Windows\System32\config\systemprofile\
#Create directory "Desktop"
#Give the NETWORK SERVICES user Read/Write permission on the Desktop folder.
#Give the NETWORK SERVICES user Read/Write permission on the AppData folder in the same directory.
#Give the NETWORK SERVICES user Read/Write permission on the folder with the Excel file.

Excel Functions from ADE

2012-05-07T19:29:58Z

AManandhar:

Functions to Write Data to Excel Worksheets

2012-05-07T19:28:49Z

AManandhar: /* See Also */

[[Category:Database Functions]]
[[Category:Doc Status C]] 

[[What's new in Analytica 4.2?]] >

The functions let you to write directly to an Excel spreadsheet. They complement the [[SpreadsheetCell]] and [[SpreadsheetRange]] functions for [[Functions To Read Excel Worksheets|reading data from Excel worksheets]]. They are a simpler alternative to OLE linking or [[DbQuery|ODBC]], two other methods for sending data to spreadsheets. They are only available from the Enterprise edition or higher, including ADE.

When you use these functions to write data to a spreadsheet, the values are sent when the function is evaluated. If upstream Analytica variables change, the result is not automatically transfered to Excel unless the variable (or button) that calls these functions is re-evaluated. This aspect differentiates it somewhat from outgoing OLE links when the ''Auto recompute outgoing OLE links'' preference is on. If the spreadsheet is currently loaded in Excel when these are evaluated, the running copy of the spreadsheet is altered. The changes only persist when [[#SpreadsheetSave|SpreadsheetSave]] is called.

Only the functions relevant to writing data are described on this page. For the functions that read data, see [[Functions To Read Excel Worksheets]].

<div id="SpreadsheetSave" >
= SpreadsheetSave( workbook'', filename'' ) =
</div>

Saves «workbook», which was originally obtained via [[SpreadsheetOpen]], but which may have been modified since it was first opened, to the indicated filename, or to the original file if «filename» is omitted. The «filename» is interpreted relative to the [[CurrentDataDirectory]].

<div id="SpreadsheetSetCell" >
= SpreadsheetSetCell( workbook, sheet, col, row, value ) =
</div>

Writes «value» (either a number or text) to the cell identified by «sheet», «col» and «row». Can also be used to write multiple values via array abstraction when col, row and value share one or more indexes. The first parameter, «workbook» must be an object obtained from the [[SpreadsheetOpen]]() function.

For writing very large arrays, [[#SpreadsheetSetRange|SpreadsheetSetRange]] is faster.

The «value» is written to the formulas of each cell. Using textual values beginning with a '=' character, you can thus set actual cell formula such as "=Sum(D4:D24)".

== Examples ==

For these, ''wb'' is a variable defined as a call to [[SpreadsheetOpen]], such as <code>[[SpreadsheetOpen]]("MyWorkbook.xls")</code>.

Either of the following two calls write the value 3.5 to cell Sheet1!C5. Note that «col» can use either the character label or the numeric column position:
:SpreadsheetSetCell( wb, "Sheet1", "C", 5, 3.5 )
:SpreadsheetSetCell( wb, "Sheet1", 3, 5, 3.5 )

Here A is a 1-D array indexed by I. Writes the array as a column-vector starting at cell "D5":
:SpreadsheetSetCell( wb, "Sheet1", 4, 4+@I, A )

Writes the same 1-D array as a row-vector starting at cell "E1":
:SpreadsheetSetCell( wb, "Sheet1", "E", @I, A )

Writes a 2-D array B, indexed by I and J, to the sheet with the upper-left corner at cell B7, with the I dimension on the horizontal, the J on the vertical:
:SpreadsheetSetCell( wb, "Sheet1", 1+@I, 6+@J, B )

<div id="SpreadsheetSetRange" >

= SpreadsheetSetRange( workbook, range, value'', colIndex, rowIndex, sheet'' ) =
</div>

Writes «value» to a worksheet range, which may be identified either by a named range label or by a cell range. When «range» is a named range label, it is not necessary to specify the worksheet. When «range» is a cell coordinate range, such as 'C6:F9', then the «sheet» must also be specified. The sheet can be specified using the optional «sheet» parameter with either a textual sheet name or a numeric sheet number, or it may be specified in the range using the notation 'Sheet1!C6:F9'. You can also specify a single cell, e.g., 'C9'.

«value» may be atomic (i.e., a number or text), 1-D or 2-D. When 1-D, one of the optional index parameters, «colIndex» or «rowIndex», must be specified. When 2-D, both must be specified.

Ideally, the target range matches the data in terms of being rectangular with the same number of rows and columns. If the number of columns in «colIndex» exceeds the number of columns in «range», then only the first ''[[Size]](colIndex)'' points are written. If «value» has only one column, then the same data is repeated for all rows in «range». If «value» has more than 1 column but less than the number of columns in «range», then the remaining cells in «range» are populated with #N/A.

The formula of the cell is written. When your value is numeric, this is equivalent to setting this to a numeric value. If value is textual and begins with the '=' character, then the formula is used in the spreadsheet.

== Examples ==

Writes the value 6.0 to the cell Sheet1!B5:
:SpreadsheetSetRange( wb, "Sheet1!B5", 6.0)

Writes the 1-D array Cash_flow as a column-vector to a named range, already labelled as "Cash_flow":
:SpreadsheetSetRange( wb, "Cash_flow", Cash_flow, Time )

Writes a 1-D array B, indexed by I, as a row-vector, here in the third worksheet:
:SpreadsheetSetRange( wb, "D5:D15", B, , I, sheet:3)

Writes a 2-D array ShippingCosts, indexed by Destination and Origin, to the range labelled "Shipping_costs":
:SpreadsheetSetRange( wb, "Shipping_costs", ShippingCosts, Destination, Origin )

= Other Notes =

In early 4.2 beta builds, before 4.2.0.21, these functions were present as [[SaveExcelWorkbook]], [[WriteWorksheetCell]] and [[WriteWorksheetRange]]. Those names have now been deprecated. They will still work for a while, but may be removed in a future Analytica build. Also, the parameters of [[SpreadsheetSetRange]] differ slightly from [[WriteWorksheetRange]] -- the sheet parameter has been made optional and moved from being the 2nd parameter to being the last parameter. It is now not necessary for named ranges.

= See Also =

* [[Functions To Read Excel Worksheets]]
* [[Excel Functions from ADE]]

Functions To Read Excel Worksheets

2012-05-07T19:28:36Z

AManandhar: /* See Also */

[[Category:Database Functions]]
[[Category:Doc Status C]] 

[[What's new in Analytica 4.2?]] >

[[What's new in Analytica 4.4?]] >

These functions let you to easily read and write cells and ranges from and to an Excel spreadsheet. They are generally simpler to use than OLE linking or [[DbQuery|ODBC]], two alternative methods for integrating Analytica with spreadsheets. They may be also used from ADE.

These functions read from or write to the spreadsheet when evaluated, but do not maintain dependencies. So, if the spreadsheet data changes, it will not invalidate or cause recomputation of the Analytica results, as would a change in an Analytica variable, or a change in the spreadsheet using OLE linking. But, when you restart your model (or otherwise cause the functions to be re-evaluated), it will read the most recent data from your spreadsheet.

See also [[Functions to Write Data to Excel Worksheets]].

<div id="SpreadsheetOpen" >
= SpreadsheetOpen( filename'', showDialog'' ) =
</div>

Opens the Excel file at the indicated filename and returns a ''Workbook'' object for use by the other spreadsheet read and write functions. The result displays in a result table as '''<<ExcelWorkbook>>'''.

The '''filename''' parameter is relative to the [[CurrentDataDirectory]].

If you set ''showDialog'' to true, it displays a file browser to let you specify the file interactively, even if the file '''filename''' exists. If ''showDialog'' is false (the default), it displays the dialog only if it can't find the file (similar to [[ReadTextFile]]).

The '''filename''' can also accept a workbook name that is currently open in Excel, even if it is not yet saved.

== Example ==

SpreadsheetOpen( "C:\MyModels\Sales Numbers.xls" ) → ''«ExcelWorkbook»''

<div id="SpreadsheetCell">

== Use with Office 2010 ==

Use of Excel by an application such as Analytica may not be possible if you have installed the "Click-to-Run" version of Office 2010. This is a new "feature" of the 2010 version of Office that apparently disables lots of previously common operations. If you installed over the web using the click-to-run option, you may need to re-install the MSI-based version of office. Instructions for changing the Click-to-run edition to the MSI-based edition are found at:

[http://office.microsoft.com/en-gb/excel-help/click-to-run-switch-to-using-a-full-office-edition-HA101850538.aspx http://office.microsoft.com/en-gb/excel-help/click-to-run-switch-to-using-a-full-office-edition-HA101850538.aspx]

= SpreadsheetCell( workbook, sheet, column, row'', what'' ) =
</div>

Reads the contents of one cell of a worksheet given its coordinates. The function fully array abstracts, so you can use it to read a range of cells by specifying the column and/or row as an array.

Parameters:
* «workbook»: A workbook object returned by SpreadsheetOpen
* «sheet»: The name of a worksheet inside the workbook, or its number, where 1 is the first worksheet, etc.
::(''new to [[Analytica 4.4]]'') You can pass "*" to «sheet» to get the cell contents at ''column,row'' in all existing sheets. The result is indexed by <code>.Sheet</code>, and the local index's values contains the names of the worksheets. Hence, using <code>sheet:"*"</code> you can obtain a list of all existing worksheets in the workbook.
* «column»: The column label, e.g., "A", "B", or "AB", or the column number as an integer.
* «row»: The row number as an integer
* «what»: optional. (''new to [[Analytica 4.3]]'') Indicates whether you want to retrieve the value or the formula. Possible values:
** "Value": The computed value. In [[Analytica 4.3]] and later, dates are read as date-time numbers, and thus display in Analytica as dates.
** "NumericValue": The computed value, but the numeric value of dates is read, so they display as numbers.
** "Formula": The textual cell formula in the format you normally see in the Excel interface, e.g., "=Sum(D4:D10)"
** "RelativeFormula": The cell formula in relative offset format, e.g., "=Sum(RC[-9]:R[+6]C[-9])"
*:''These require [[Analytica 4.4]] or later:''
** "NumberFormat": Textual description of the cell number format
** "BackColor": Cell background color, integer value: red*65536 + green*256 + blue
** "TextColor": Font color, integer value: red*65536 + green*256 + blue
** "FontName": Name of the font used to display the cell
** "FontSize": Point size of font used to display the cell
** "FontStyle": Special font styles for cell separated by spaces, may include "bold italic underline strikethrough subscript superscript outline shadow"
** "WrapText": 0 or 1 indicating whether text should be word wrapped in the cell.
** "Border[Left|Right|Up|Down]Color": Color of the indicated side of the border. E.g., "BorderLeftColor" returns an integer equal to red*65535+green*256+blue
** "Border[Left|Right|Up|Down]Style": Style of indicated border, or [[Null]] if not set. May be "Solid", "Dash", "DashDot", "DashDotDot", "Dot", "Double", or "SlantDashDot".
** "Border[Left|Right|Up|Down]Weight": Thickness of indicated border, usually between 1 and 4
** "DirectPrecedents": Description of cells that are referenced directly by the cell formula in the cell. This includes only precedents in the same worksheet. It unfortunately does not include references to cells appearing on other sheets. Each cell or cell range is separated by a comma.
** "DirectPrecedentsRelative": Same as "DirectPrecedents", but cells are identified by their offset relative to the current cell, e.g., R[-3]C[6].
** "DirectDependents": Description of cells that reference the given cell in their formula. This includes only dependents in the worksheet. It unfortunately does not include references to dependents appearing in other sheets. Each cell or cell range description is separated by a comma.
** "DirectDependentsRelative": Same as "DirectDependents", but cells are identified by their offset relative to the current cell, e.g., R[-3]C[6].
** "Precedents": Description of all cells in the current worksheet that the given cell formula depends on directly or indirectly. It does not include cells reached by paths passing through other sheets.
** "PrecedentsRelative": Same as "Precedents", but cells are identified by their offset relative to the current cell, e.g., R[-3]C[6].
** "Descendants": Description of all cells in the current worksheet that depend directly or indirectly on the given cell. It does not include cells reached by paths passing through other sheets.
** "DirectDescendantsRelative": Same as "DirectDescendants", but cells are identified by their offset relative to the current cell, e.g., R[-3]C[6].

:The «what» parameter defaults to "Value" when not specified.

If the worksheet cell is empty, it returns Null. It flags an error if «workbook» is not a valid workbook, if it does not contain «sheet», or if the coordinates are invalid.

If you change the cell after evaluating a variable that uses SpreadsheetCell(), it has no effect, unless and until you recompute the variable.

== Examples ==

These expressions are different ways to get the same result, the value from cell C7 in the first sheet, "Sheet1" of workbook:
SpreadsheetCell( workbook, "Sheet1", "C", 7 )
SpreadsheetCell( workbook, "Sheet1", 3, 7 )
SpreadsheetCell( workbook, 1, 3, 7 )

Suppose the spreadsheet contains a 2-D table in the region C4:J19. The columns of this table correspond to the years 2008..2015. The rows correspond to different assets. It is easier to refer to the columns by number, so that the columns "C" thru "J" are columns 3 thru 10. To hold this 2-D table, we need two indexes in Analytica, ''Time'' and ''Asset''.

[[Index]] Time := 2008..2015
[[Index]] Asset := 1..16
Variable Workbook := SpreadsheetOpen( "C:\Asset Data.xls" )
Variable Data := SpreadsheetCell( workbook, "Sheet1", @Time+2, @Asset+3 )

<div id="SpreadsheetRange">

= SpreadsheetRange(workbook, range'', colIndex, rowIndex, howToIndex, sheet, what'') =
</div>

Reads a range of cells from an Excel worksheet. The range can be the name of a named range in the Excel workbook, or it can be a cell range such as: "C7" or "C7:F12".

Parameters:
* «workbook»: A workbook object returned by SpreadsheetOpen
* range: A cell range. This may be a named range label in the spreadsheet, or it may be of the form "Sheet1!A1:BC99" or "A1:BC99". If you don't mention the sheet name, you must specify «sheet» as a parameter.
::(''new to [[Analytica 4.4]]'') You can specify the range as "Sheet1!", with nothing following the "!", to identify the smallest rectangular range surrounding all used cells within the sheet. Or you can omit this parameter and specify only the «sheet» parameter.
* «colIndex»: (optional) A pre-existing index for indexing the column dimension of the result.
* «rowIndex»: (optional) A pre-existing index for indexing the row dimension of the result.
* «howToIndex»: (optional) A set of flags controlling how the result is indexed when colIndex or rowIndex is not specified. Any of the following values can be added together for this parameter:
** 1 = Force column index. Forces a column index to be included even if the range spans only a single column. Has no effect if ''colIndex'' is specified.
** 2 = Force row index. Forces a row index to be included even if the range spans only a single row. Has no effect if ''rowIndex'' is specified.
** 4 = Use first row for column labels: The first row in the range is not included in the result returned, but the values in the first row are used as the column labels for the local index ''.Column''.
** 8 = Use first column for row labels: The first column in the range is not included in the result returned, but the values from the first column are used as row labels for the local index ''.Row''.
** 16 = Do not issue an error if the supplied ''colIndex'' or ''rowIndex'' are not the correct length.
* «sheet»: The name of a worksheet inside the workbook, or a number.
* «what»: optional. (''new to [[Analytica 4.3]]'') Indicates whether you want to retrieve the value or the formula. Possible values:
** "Value": The computed value. In [[Analytica 4.3]] and later, dates are read as date-time numbers, and thus display in Analytica as dates.
** "NumericValue": The computed value, but the numeric value of dates is read, so they display as numbers.
** "Formula": The textual cell formula in the format you normally see in the Excel interface, e.g., "=Sum(D4:D10)"
** "RelativeFormula": The cell formula in relative offset format, e.g., "=Sum(RC[-9]:R[+6]C[-9])"
*:''These require Analytica 4.4:''
** "NumberFormat": Textual description of the cell number format
** "BackColor": Cell background color, integer value: red*65536 + green*256 + blue
** "Text Color": Font color, integer value: red*65536 + green*256 + blue
** "FontName": Name of the font used to display the cell
** "FontSize": Point size of font used to display the cell
** "FontStyle": Special font styles for cell separated by spaces, may include "bold italic underline strikethrough subscript superscript outline shadow"
** "WrapText": 0 or 1 indicating whether text should be word wrapped in the cell.
** "Border[Left|Right|Up|Down]Color": Color of the indicated side of the border. E.g., "BorderLeftColor" returns an integer equal to red*65535+green*256+blue
** "Border[Left|Right|Up|Down]Style": Style of indicated border, or [[Null]] if not set. May be "Solid", "Dash", "DashDot", "DashDotDot", "Dot", "Double", or "SlantDashDot".
** "Border[Left|Right|Up|Down]Weight": Thickness of indicated border, usually between 1 and 4
** "DirectPrecedents": Description of cells that are referenced directly by the cell formula in the cell. This includes only precedents in the same worksheet. It unfortunately does not include references to cells appearing on other sheets. Each cell or cell range is separated by a comma.
** "DirectPrecedentsRelative": Same as "DirectPrecedents", but cells are identified by their offset relative to the current cell, e.g., R[-3]C[6].
** "DirectDependents": Description of cells that reference the given cell in their formula. This includes only dependents in the worksheet. It unfortunately does not include references to dependents appearing in other sheets. Each cell or cell range description is separated by a comma.
** "DirectDependentsRelative": Same as "DirectDependents", but cells are identified by their offset relative to the current cell, e.g., R[-3]C[6].
** "Precedents": Description of all cells in the current worksheet that the given cell formula depends on directly or indirectly. It does not include cells reached by paths passing through other sheets.
** "PrecedentsRelative": Same as "Precedents", but cells are identified by their offset relative to the current cell, e.g., R[-3]C[6].
** "Descendants": Description of all cells in the current worksheet that depend directly or indirectly on the given cell. It does not include cells reached by paths passing through other sheets.
** "DirectDescendantsRelative": Same as "DirectDescendants", but cells are identified by their offset relative to the current cell, e.g., R[-3]C[6].
:The «what» parameter defaults to "Value" when not specified.

''Note: Options 4, 8 and 16 require release 4.1.1 or later.''

Depending on the dimensions of the cell range, the result may be a scalar (single cell), a column vector, a row vector, or a 2-D array.

If the range spans more than one column in the spreadsheet, the result must be indexed by a column index. If you already have this index, you can specify it in the optional colIndex parameter; otherwise, it creates a local index named ''.Column'' as a dimension of the result. By default, the elements of the column index are set to the sheet's column labels, e.g., "A","B",...."AA","AB",..].
If desired, you can also use the first row of values as elements for the .Column index (this row is then not included in the actual array retrieved -- thus should only be used when the range spans at least two rows). To use the first row for the elements of the local column index, specify ''howToIndex:4'' and leave the «colIndex» parameter unspecified.

If your result falls entirely within a single column, but you wish to force a local column index to be included, so that the result is a 2-dimensional array of size 1xR, rather than a 1-D vector of length R, then specify ''howToIndex:1''. If you are using a named range and don't know how many columns there actually are, and it is possible there is only one, then you would want to force a column index so that an error doesn't occur if you use [[Dot_operator::A.I|result.Column]] in an expression.

If the range spans more than one row in the spreadsheet, then a row index must dimension the result. If you already have this index, specify it in the ''rowIndex'' parameter; otherwise, if the range spans more than one row, a local index named ''.Row'' is created by the function and used to dimension the result. The local ''.Row'' index that is created contains the row numbers from the spreadsheet as its elements, so for example, if the range is "C7:F12", the ''.Row'' index would contain the elements [7,8,9,10,11,12]. To force the creation of a local ''.Row'' index when the result spans only a single row, specify ''howToIndex:2''. To use the values from the first column as the elements of the local ''.Row'' index, specify ''howToIndex:8''.

If you specify «colIndex» or «rowIndex», and the length of the indexes do not match the length of the specified range, the range is truncated if the index is too short, or the result filled out with [[Null]] values if the index is too long. If the flag ''howToIndex:16'' is specified, it issues an error if the index length does not match.

Empty cells in the range are [[Null]] in the result.

No dependency is maintained between the original data in the spreadsheet and the result. The data retrieved are the value that were there at the time the function is evaluated. If the data in the spreadsheet changes after the function has been evaluated, the results are not invalidated and continue to retain the original values.

''(Requires [[Analytica 4.4]] or later)'' You can obtain the entire used range of a worksheet named "Sheet1" by specifying the «range» as "Sheet1!" or by omitting the «range» parameter and specifying just the «sheet» parameter.

== Examples ==

These example use the following spreadsheet:

[[Image:WorksheetRange ExcelShot.jpg]]

In the above spreadsheet, several cell ranges are labelled as named ranges, as follows:
{| border="1"
! Label !! Range
|-
| Rate || B1
|-
| Year || B3:F3
|-
| Cash_flow || B4:F4
|-
| Divisions || A7:A9
|-
| Employee_count || B7:F9
|}

SpreadsheetRange( wb, "Rate" ) → 0.08

SpreadsheetRange( wb, "Sheet1!B1") → 0.08

SpreadsheetRange( wb, "Sheet1!B3:F3" ) →
{| border="1"
! .Column → !! 'B' !! 'C' !! 'D' !! 'E' !! 'F'
|-
| || 2008 || 2009 || 2010 || 2011 || 2012
|}

[[Index]] Year := [[CopyIndex]]( SpreadsheetRange( wb, "Year", howToIndex:1 ) );
SpreadsheetRange( wb, "Cash_flow", colIndex:Year )
→
{| border="1"
! .Year → !! 2008 !! 2009 !! 2010 !! 2011 !! 2012
|-
| || -100 || 10 || 30 || 50 || 60
|}

''Note: howToIndex:1 was specified for Year here so that we would have a 1-D array even if only one year were present in the spreadsheet.''

SpreadsheetRange( wb, "Employee_count" ) →
{| border="1"
! !! .Column → !! 'B' !! 'C' !! 'D' !! 'E' !! 'F'
|-
! rowspan="3" | .Row<br>↓ !! 7
| 24 || 27 || 28 || 32 || 35
|-
! 8
| 13 || 13 || 13 || 13 || 13
|-
! 9
| 25 || 22 || 21 || 19 || 16
|}

[[Index]] [[Time]] := [2008,2009,2010,2011,2012];
SpreadsheetRange( wb, "A7:F9", colIndex:Time, howToIndex:8, sheet:1)
→
{| border="1"
! !! Time → !! 2008 !! 2009 !! 2010 !! 2011 !! 2012
|-
! rowspan="3" | .Row<br>↓ !! "Div A"
| 24 || 27 || 28 || 32 || 35
|-
! "Div B"
| 13 || 13 || 13 || 13 || 13
|-
! "Div C"
| 25 || 22 || 21 || 19 || 16
|}

''The examples below require Analytica 4.4 or later:''

To obtain the list of worksheet names:

SpreadsheetCell(wb, "*", 1, 1).Sheet

To obtain all used cells in sheet named "Sheet2":

SpreadsheetRange(wb,sheet:"Sheet2")

To obtain the number format of all cells in "Sheet2":

SpreadsheetRange(wb,sheet:"Sheet2",what:"NumberFormat")

= Legacy Notes =

Functions for reading cells from Excel were first present in Analytica 4.1 with functions named [[OpenExcelFile]], [[WorksheetCell]] and [[WorksheetRange]], although these were labelled as ''experimental'', and the present functions were not officially available until 4.2.0. The old names are now deprecated, replaced with [[SpreadsheetOpen]], [[SpreadsheetCell]] and [[SpreadsheetRange]]. The old functions still work at present, but may be removed in future Analytica builds. The parameters have changed slightly from [[WorksheetRange]] to [[SpreadsheetRange]], with the sheet parameter moved from being the second to being the last parameter and now optional -- no longer required for named ranges or ranges of the form "Sheet1!A1:Z99".

= See Also =

* [[Functions to Write Data to Excel Worksheets]] -- [[SpreadsheetSetCell]], [[SpreadsheetSetRange]] and [[SpreadsheetSave]]
* [[DbQuery]] -- ODBC can also be used to read from Excel worksheets
* [[ReadTextFile]]
* [[ReadCsvFile]]
* [[Excel Functions from ADE]]

Excel Functions from ADE

2012-05-07T19:25:27Z

AManandhar:

=Issue=
Excel spreadsheet functions when invoked from an ADE Application through IIS seems to hang when ADE tries to bind to an instance of an Excel COM Object.

=Fix=
Configuring the following settings on the machine seem to fix this issue.

#Create a new standard user. E.g. 'ExcelRunner' with a password.
#Set the Excel COM Objects to be invoked by this newly created user instead of the default Launching User.
##Launch DCOM Config: Start→Administrative Tools→Component Services→Computers→My Computer→DCOM Config.
##*Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command Start > Run > 'mmc comexp.msc /32'
##Right click on 'Microsoft Excel Application' and then on 'Properties'.
##Click on the Identity tab.
##Choose "This user." as the account to run Excel Applications and type in the username and password of the new account.
##Click OK.
#Give the new user permission to write files in the directory with the Excel file.

Excel Functions from ADE

2012-05-07T19:23:17Z

AManandhar: Created page with "Excel spreadsheet functions when invoked from ADE through IIS seems to hang when ADE tries to bind to an instance of an Excel COM Object. Configuring the following settings on th..."

Excel spreadsheet functions when invoked from ADE through IIS seems to hang when ADE tries to bind to an instance of an Excel COM Object. Configuring the following settings on the machine will fix this issue.

#Create a new standard user. E.g. 'ExcelRunner' with a password.
#Set the Excel COM Objects to be invoked by this newly created user instead of the default Launching User.
##Launch DCOM Config: Start→Administrative Tools→Component Services→Computers→My Computer→DCOM Config.
##*Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command Start > Run > 'mmc comexp.msc /32'
##Right click on 'Microsoft Excel Application' and then on 'Properties'.
##Click on the Identity tab.
##Choose "This user." as the account to run Excel Applications and type in the username and password of the new account.
##Click OK.
#Give the new user permission to write files in the directory with the Excel file.

File:Box-like-plots.ana

2012-01-30T16:14:21Z

AManandhar:

OptStatusText

2012-01-18T18:45:35Z

AManandhar: /* OptStatusText(opt) */

[[Category:Optimization Functions]]
[[Category:Doc Status D]] 

''[[New to Analtyica 4.3]]. For earlier releases, this was called [[LpStatusText]].''

= OptStatusText(opt) =

When you attempt to solve an optimization problem, either linear, quadratic, non-linear, or mixed-integer varieties of these, it is important to check the status that results. Calling [[OptStatusText]] ensures that the optimization search has taken place, and returns an English-language description of the status, usually indicating the condition that led to the termination of the search. The «opt» is an optimization problem specification returned by a call to [[DefineOptimization]].

The [[OptStatusNum]] function provides a numeric code corresponding to the status, while [[OptStatusText]] returns an English-language description. Be aware that the set of codes has changed in Analytica 4.0 from the set of possible codes returned in Analytica 3.1, as a result of an upgrade to Frontline System's newer and restructured solver library.

The following table needs to be cleaned up here, but provides a listing of the possible text that can be returned from LpStatusText. See also [[OptStatusNum]] for the numeric values. This should be re-organized here into a two column table, with LpStatusNum in the first column (as an integer) and [[OptStatusText]] in the second.

<pre>
case Optimize_Status_Invalid: return "Invalid status";
case Optimize_Status_Ignore: return "Ignore status. Used when dummy result code needs to be overridden.";
case Optimize_Status_Lic_Problem: return "Invalid license status. (License expired, missing, invalid, etc.)";
case Optimize_Status_Optimal: return "Optimal solution has been found.";
case Optimize_Status_Converged: return "The Solver has converged to the current solution.";
case Optimize_Status_No_Remedies: return "No remedies: All remedies failed to find better point.";
case Optimize_Status_Iterate_Limit: return "Iterates limit reached. Indicates an early exit of the algorithm.";
case Optimize_Status_Unbounded: return "Optimizing an unbounded objective function.";
case Optimize_Status_Unfeasible: return "Feasible solution could not be found.";
case Optimize_Status_User_Abort: return "Optimization aborted by user.";
case Optimize_Status_Linear_Invalid:return "Invalid linear model. Returned when a linearity assumption renders incorrect.";
case Optimize_Status_Bad_Dataset: return "Bad data set status. Returned when a problem data set renders inconsistent.";
case Optimize_Status_Float_Err: return "Float error status. (Internal float error.)";
case Optimize_Status_Time_Out: return "Time out status. Returned when the maximum allowed time has been exceeded. Indicates an early exit of the algorithm.";
case Optimize_Status_Memory_Dearth: return "Memory dearth status. Returned when the system cannot allocate enough memory to perform the optimization.";
case Optimize_Status_Interpret_Err: return "Interpretation error. (Parser, Diagnostics, or Executor error.)";
case Optimize_Status_Api_Err: return "Fatal API error. (API not responding.)";
case Optimize_Status_Incumb_Cand: return "The Solver has found an integer solution within integer tolerance.";
case Optimize_Status_Bbnode_Limit: return "Branching and bounding node limit reached.";
case Optimize_Status_Bbmips_Limit: return "Branching and bounding maximum number of incumbent points reached.";
case Optimize_Status_Probable: return "Probable global optimum reached. Returned when MSL (Bayesian) global optimality test has been satisfied.";
case Optimize_Status_Bounds_Missing:return "Missing bounds status. Returned for EV/MSL Require Bounds when bounds are missing.";
case Optimize_Status_Bounds_Conflict: return "Bounds conflict status. Indicates = >= bounds conflict with existing binary or alldifferent constraints.";
case Optimize_Status_Bounds_Inconsist: return "Bounds inconsistency status. Returned when the lower bound value of a variable is grater than the upper bound value, i.e. lb[i] > ub[i] for some variable bound i.";
case Optimize_Status_Derivative_Err:return "Derivative error. Returned when API_Jacobian has not been able to compute gradients.";
case Optimize_Status_Cone_Overlap: return "Cone overlap status. Returned when a variable appears in more than one cone.";
case Optimize_Status_Exception: return "Exception occurred status. Returned when an exception has been caught by try/catch top-level. Optimize_Status_Custom_Base 1000 Custom base status. (Base for Solver Engine custom results.)";
case 1101: return "No problem information is available"; // custom SOCP error code, should never occur in the SDK, but could occur in Excel version
case 1102: return "The quadratic constraints are non-convex. The SOCP engine cannot solve this problem.";
default:
return "unknown Frontline solver status code";
</pre>

Custom or add-on solver engines may return additional status codes not listed here. In these cases, [[OptStatusText]] will generally return "unknown Frontline solver status code", but [[OptStatusNum]] will vary.

Add-on solver engines may issue [[OptStatusNum]] codes greater than or equal to 1000. These are not unique, with the error message depending on the particular solver engine.

Add-on solver engines may issue "Invalid license status. (License expired, missing, invalid, etc.)" status also when the add-on solver engine DLL installed is not compatible with the Analytica release. You should install Version 10 of the add-on solver engine for Analytica 4.3 and Version 11 for Analytica 4.4.

= See Also =

* [[OptStatusNum]]
* [[OptSolution]]
* [[DefineOptimization]]

Configuring an RLM Server

2011-12-13T20:13:53Z

AManandhar: /* Installation Steps */

This page describes the steps required for installing and configuring a Reprise License Manager for use with Lumina software. The instructions are relevant for an IT manager within your organization who manages software licenses.

Analytica end-users, who wish to install the software, should see [[How to Install Analytica 4.2 -- Individual License]] and [[How to Install Analytica 4.2 -- Centrally Managed License]].

You can watch a video showing the installation of the RLM server, use of the RLM administration console, and activation of Lumina codes here: [http://AnalyticaOnline.com/WebinarArchive/2009-06-04-RLM_Install.wmv RLM_Install.wmv] (22 minutes). This video is a little rough around the edges.

= What you need =

;License Server computer
:You'll need to identify a server computer that will host the Reprise License Manager (RLM) server. This computer needs to be on your internal company network where it can be reached by all the computers in your organization that may need to check out licenses. It should also be a server with high availability -- i.e., that isn't turned off. It can serve licenses for other products from other vendors that also use RLM as well.
:The load imposed on the server from RLM, especially from Analytica applications, is extremely light, so it by no means needs to be a dedicated server. You can easily use a computer whose primary purpose is for something else.
:The Server can be nearly any platform, including Windows or Unix (i.e., any platform supported by Reprise).
:RLM does support redundant failover servers, but this is seldom required and isn't covered here.

;Generic RLM Server Software
:If you are already running RLM for other applications using RLM 7 or higher, then you already have what you need. Otherwise, download the end-user bundle from [http://reprisesoftware.com/enduser_downloads.htm reprisesoftware.com]. For a windows platform, this is downloaded as a file '''x86_w1.enduser.zip'''.
:You'll also need the lumina-specific settings file (right click, select '''Save Target As...''') [[media:lumina.set|lumina.set]], and save it in your RLM directory.

;Analytica or ADE license(s).
:These are provided to you by Lumina when you purchase ADE or Analytica.
:They should contain 16 numeric digits, such as: 1234-5678-9012-3456
:If you have a multi-seat license, then each activation key also has a ''count'' (aka ''number of seats'') associated with it. Most commonly, licenses are 1-seat licenses, so if you were not given a count with your activation key, you can assume it is a 1-seat license.

= Installation Steps =

The installation steps are given here for a Windows machine, but are the same with just minor differences on Unix servers. In Windows computers, especially if Vista, you'll probably need to be in an administrator account to perform these steps.

1. Download the [http://reprisesoftware.com/enduser_downloads.htm RLM end-user bundle] for Windows.

2. Double click the file and extract it to a directory of your choice, such as:

:'''C:\Program Files (x86)\Reprise\RlmServer''' (On 64 bit windows)
:'''C:\Program Files\Reprise\RlmServer''' (On 32 bit windows)

[[File:Extract_screenshot.png]]

3. Copy the [[media:lumina.set|lumina.set]] file to the same directory.

4. Start a CMD-line window. Navigate to the chosen directory (''cd c:\program files\reprise\rlmserver'').
:On Windows Vista and Windows 7, start the CMD-line window as Administrator. To start CMD-line window as Administrator:
# Click on the Start menu on the bottom left.
# Type in '''cmd''' in the Search box.
# Press '''Ctrl + Shift + Enter'''

5. Type
:'''rlm -dlog "c:\Program Files (x86)\Reprise\RlmServer\rlm.log" -install_service''' (On 64 bit windows)
:'''rlm -dlog "c:\Program Files\Reprise\RlmServer\rlm.log" -install_service''' (On 32 bit windows)
* You must include the full path to the log file, without using relative paths.
* There are additional configuration options, for a listing help type: rlm -?
* The local system account (which the RLM service will run under) must have write permissions to the RlmServer directory, so that it can write activated license files and the log file.

6. Type: '''net start rlm'''
:The RLM service should now be running.

[[File:RlmServer_install.png]]

7. Enter the administration panel:
* Point a browser to [http://localhost:5054 http://localhost:5054].

8. Install any Analytica or ADE licenses.
:Lumina should have provided you with Activation keys for your Analytica or ADE wiki.lumina.comon keys contain 16 numeric digits, such as:
::1234-5678-9012-3456
* Click the "Activate License" button
* Click "BEGIN License Activation", then enter these fields:
** Click Other (URL) and enter '''AnalyticaOnline.com''' into the text-box. <br>[[File:ActivationServerUrl.jpg]]
** ISV: lumina.
** License activation key: 1234-5678-9012-3456      {Your activation code here}<br>[[File:ISV_lumina.png]]
** License Server hostid: { Use the value filled in for you }
** License count: { The number of seats. Normally 1. }
** License File to create: { A *.lic file in the licenses directory from step 4}
** Press ''REQUEST LICENSE''.
** When prompted, restart RLM server to reread licenses.

9. Click on Status
* Verify that the Lumina ISV is listed.

10. If you have more than one activation key, repeat step 7-8 for each.

= Additional Configuration =

You, as an IT manager, may want to configure RLM permissions to control who can use the Analytica licenses and who can manage the RLM server. On the bottom left of the RLM Administration Console, there is a link to the '''RLM Manual...'''

To control access to the RLM server, and administration of its capabilities, see the section on '''RLM Options File'''. Among the access control settings you can configure are these (copied from that manual):

{| border="1"
!Privilege
!Name to use in RLM options file
!Meaning
|-
|edit_options||edit_options||Allows editing options files for ISV servers
|-
|edit_rlm_options||edit_rlm_options||Allows editing options files for the rlm server
|-
|edit_transfer||edit_transfer||Allows editing server-server license transfer settings for ISV servers
|-
|reread||reread||Allows access to the functions which do reread commands on license servers
|-
|shutdown||shutdown||Allows access to the functions which shut down license servers
|-
|status||status||Allows display of status and debug log information from the license servers
|}

You may also want to restrict which users can checkout licenses, for example, restricting usage to specific users in your department. For that, see the section '''The ISV Options File''' in the '''RLM Manual'''. Also consult that section for information on assigning named-user licenses to specific users.

= See Also =

* [http://AnalyticaOnline.com/WebinarArchive/2009-06-04-RLM_Install.wmv RLM_Install.wmv]: Video - installing RLM and Activating centrally managed Analytica licenses (22 minutes).
* [http://lumina.com/ana/manualActivation.htm Manual Activation]
* [[What License do I Purchase?]]
* [[How to Install Analytica 4.2 -- Individual License]]
* [[How to Install Analytica 4.2 -- Centrally Managed License]]

<comments />

Configuring an RLM Server

2011-12-13T20:13:08Z

AManandhar: /* Installation Steps */

This page describes the steps required for installing and configuring a Reprise License Manager for use with Lumina software. The instructions are relevant for an IT manager within your organization who manages software licenses.

Analytica end-users, who wish to install the software, should see [[How to Install Analytica 4.2 -- Individual License]] and [[How to Install Analytica 4.2 -- Centrally Managed License]].

You can watch a video showing the installation of the RLM server, use of the RLM administration console, and activation of Lumina codes here: [http://AnalyticaOnline.com/WebinarArchive/2009-06-04-RLM_Install.wmv RLM_Install.wmv] (22 minutes). This video is a little rough around the edges.

= What you need =

;License Server computer
:You'll need to identify a server computer that will host the Reprise License Manager (RLM) server. This computer needs to be on your internal company network where it can be reached by all the computers in your organization that may need to check out licenses. It should also be a server with high availability -- i.e., that isn't turned off. It can serve licenses for other products from other vendors that also use RLM as well.
:The load imposed on the server from RLM, especially from Analytica applications, is extremely light, so it by no means needs to be a dedicated server. You can easily use a computer whose primary purpose is for something else.
:The Server can be nearly any platform, including Windows or Unix (i.e., any platform supported by Reprise).
:RLM does support redundant failover servers, but this is seldom required and isn't covered here.

;Generic RLM Server Software
:If you are already running RLM for other applications using RLM 7 or higher, then you already have what you need. Otherwise, download the end-user bundle from [http://reprisesoftware.com/enduser_downloads.htm reprisesoftware.com]. For a windows platform, this is downloaded as a file '''x86_w1.enduser.zip'''.
:You'll also need the lumina-specific settings file (right click, select '''Save Target As...''') [[media:lumina.set|lumina.set]], and save it in your RLM directory.

;Analytica or ADE license(s).
:These are provided to you by Lumina when you purchase ADE or Analytica.
:They should contain 16 numeric digits, such as: 1234-5678-9012-3456
:If you have a multi-seat license, then each activation key also has a ''count'' (aka ''number of seats'') associated with it. Most commonly, licenses are 1-seat licenses, so if you were not given a count with your activation key, you can assume it is a 1-seat license.

= Installation Steps =

The installation steps are given here for a Windows machine, but are the same with just minor differences on Unix servers. In Windows computers, especially if Vista, you'll probably need to be in an administrator account to perform these steps.

1. Download the [http://reprisesoftware.com/enduser_downloads.htm RLM end-user bundle] for Windows.

2. Double click the file and extract it to a directory of your choice, such as:

:'''C:\Program Files (x86)\Reprise\RlmServer''' (On 64 bit windows)
:'''C:\Program Files\Reprise\RlmServer''' (On 32 bit windows)

[[File:Extract_screenshot.png]]

3. Copy the [[media:lumina.set|lumina.set]] file to the same directory.

4. Start a CMD-line window. Navigate to the chosen directory (''cd c:\program files\reprise\rlmserver'').
:On Windows Vista and Windows 7, start the CMD-line window as Administrator. To start CMD-line window as Administrator:
# Click on the Start menu on the bottom left.
# Type in '''cmd''' in the Search box.
# Press '''Ctrl + Shift + Enter'''

5. Type
:'''rlm -dlog "c:\Program Files (x86)\Reprise\RlmServer\rlm.log" -install_service''' (On 64 bit windows)
:'''rlm -dlog "c:\Program Files\Reprise\RlmServer\rlm.log" -install_service''' (On 32 bit windows)
* You must include the full path to the log file, without using relative paths.
* There are additional configuration options, for a listing help type: rlm -?
* The local system account (which the RLM service will run under) must have write permissions to the RlmServer directory, so that it can write activated license files and the log file.

6. Type: '''net start rlm'''
:The RLM service should now be running.

[[File:RlmServer_install.png]]

7. Enter the administration panel:
* Point a browser to [http://localhost:5054 http://localhost:5054].

8. Install any Analytica or ADE licenses.
:Lumina should have provided you with Activation keys for your Analytica or ADE wiki.lumina.comtivation keys contain 16 numeric digits, such as:
::1234-5678-9012-3456
* Click the "Activate License" button
* Click "BEGIN License Activation", then enter these fields:
** Click Other (URL) and enter '''AnalyticaOnline.com''' into the text-box. <br>[[File:ActivationServerUrl.jpg]]
** ISV: lumina.
** License activation key: 1234-5678-9012-3456      {Your activation code here}<br>[[File:ISV_lumina.png]]
** License Server hostid: { Use the value filled in for you }
** License count: { The number of seats. Normally 1. }
** License File to create: { A *.lic file in the licenses directory from step 4}
** Press ''REQUEST LICENSE''.
** When prompted, restart RLM server to reread licenses.

9. Click on Status
* Verify that the Lumina ISV is listed.

10. If you have more than one activation key, repeat step 7-8 for each.

= Additional Configuration =

You, as an IT manager, may want to configure RLM permissions to control who can use the Analytica licenses and who can manage the RLM server. On the bottom left of the RLM Administration Console, there is a link to the '''RLM Manual...'''

To control access to the RLM server, and administration of its capabilities, see the section on '''RLM Options File'''. Among the access control settings you can configure are these (copied from that manual):

{| border="1"
!Privilege
!Name to use in RLM options file
!Meaning
|-
|edit_options||edit_options||Allows editing options files for ISV servers
|-
|edit_rlm_options||edit_rlm_options||Allows editing options files for the rlm server
|-
|edit_transfer||edit_transfer||Allows editing server-server license transfer settings for ISV servers
|-
|reread||reread||Allows access to the functions which do reread commands on license servers
|-
|shutdown||shutdown||Allows access to the functions which shut down license servers
|-
|status||status||Allows display of status and debug log information from the license servers
|}

You may also want to restrict which users can checkout licenses, for example, restricting usage to specific users in your department. For that, see the section '''The ISV Options File''' in the '''RLM Manual'''. Also consult that section for information on assigning named-user licenses to specific users.

= See Also =

* [http://AnalyticaOnline.com/WebinarArchive/2009-06-04-RLM_Install.wmv RLM_Install.wmv]: Video - installing RLM and Activating centrally managed Analytica licenses (22 minutes).
* [http://lumina.com/ana/manualActivation.htm Manual Activation]
* [[What License do I Purchase?]]
* [[How to Install Analytica 4.2 -- Individual License]]
* [[How to Install Analytica 4.2 -- Centrally Managed License]]

<comments />

Analytica User FAQs/ADE

2011-11-30T01:18:16Z

AManandhar:

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application, however, I can launch ADE (e.g., using AdeTest) from my user account just fine.

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5: '''{Computer Name}\ASPNET'''

IIS 6 and 7: '''NETWORKSERVICE''' (identity) or '''IIS_IUSRS''' (user)

IIS 7.5: '''ApplicationPoolIdentity '''(identity)  or '''IIS AppPool\DefaultAppPool''' (user)<br>

== Setting the permission for the special account ==

#Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config'''
##Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command '''Start''' > '''Run''' > ''''mmc comexp.msc /32''''
#Right click on ''Analytica Decision Engine Local Server 4.4'', select '''Properties'''→Security
#Click '''Launch and Activate Permissions'''→ Customize → Edit...
#'''Add...''' the appropriate account depending on your version of IIS.
#For this account, check '''Local Launch''' and '''Local Activation''' permissions
#Click OK or Apply to save the permission changes.

Analytica User FAQs/ADE

2011-11-30T01:17:52Z

AManandhar:

Analytica User FAQs/ADE

2011-11-30T01:14:32Z

AManandhar:

Analytica User FAQs/ADE

2011-11-30T01:14:06Z

AManandhar:

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application, however, I can launch ADE (e.g., using AdeTest) from my user account just fine.

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5: '''{Computer Name}\ASPNET'''

IIS 6 and 7: '''NETWORKSERVICE''' (identity) or '''IIS_IUSRS''' (user)

IIS 7.5: '''ApplicationPoolIdentity '''(identity)  or '''IIS AppPool\DefaultAppPool''' (user)<br>

== Setting the permission for the special account ==

#Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config'''
##Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command '''Start''' > '''Run''' > '''mmc comexp.msc /32'''
#Right click on ''Analytica Decision Engine Local Server 4.4'', select '''Properties'''→Security
#Click '''Launch and Activate Permissions'''→ Customize → Edit...
#'''Add...''' the appropriate account depending on your version of IIS.
#For this account, check '''Local Launch''' and '''Local Activation''' permissions.

Analytica User FAQs/ADE

2011-11-30T01:12:17Z

AManandhar:

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application, however, I can launch ADE (e.g., using AdeTest) from my user account just fine.

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5: '''{Computer Name}\ASPNET'''

IIS 6 and 7: '''NETWORKSERVICE''' (group) or '''IIS_IUSRS''' (user)

IIS 7.5: '''IIS AppPool\DefaultAppPool'''<br>

== Setting the permission for the special account ==

#Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config'''
##Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command '''Start''' > '''Run''' > '''mmc comexp.msc /32'''
#Right click on ''Analytica Decision Engine Local Server 4.4'', select '''Properties'''→Security
#Click '''Launch and Activate Permissions'''→ Customize → Edit...
#'''Add...''' the appropriate account depending on your version of IIS.
#For this account, check '''Local Launch''' and '''Local Activation''' permissions.

Analytica User FAQs/ADE

2011-11-30T01:08:10Z

AManandhar: /* Setting the permission for the special account */

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application:

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.

However, I can launch ADE (e.g., using AdeTest) from my user account just fine.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5: '''{Computer Name}\ASPNET'''

IIS 6 and 7: '''NETWORKSERVICE''' (group) or '''IIS_IUSRS''' (user)

IIS 7.5: '''IIS AppPool\DefaultAppPool'''<br>

== Setting the permission for the special account ==

#Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config'''
##Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command '''Start''' > '''Run''' > '''mmc comexp.msc /32'''
#Right click on ''Analytica Decision Engine Local Server 4.4'', select '''Properties'''→Security
#Click '''Launch and Activate Permissions'''→ Customize → Edit...
#'''Add...''' the appropriate account depending on your version of IIS.
#For this account, check '''Local Launch''' and '''Local Activation''' permissions.

Analytica User FAQs/ADE

2011-11-30T01:03:31Z

AManandhar: /* Finding the special account */

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application:

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.

However, I can launch ADE (e.g., using AdeTest) from my user account just fine.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5: '''{Computer Name}\ASPNET'''

IIS 6 and 7: '''NETWORKSERVICE''' (group) or '''IIS_IUSRS''' (user)

IIS 7.5: '''IIS AppPool\DefaultAppPool'''<br>

== Setting the permission for the special account ==

#Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config'''
##Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command '''mmc comexp.msc /32''' instead of the above step.
#Right click on ''Analytica Decision Engine Local Server 4.4'', select '''Properties'''→Security
#Click '''Launch and Activate Permissions'''→ Customize → Edit...
#'''Add...''' NETWORK SERVICE (or the name in step 4 above) and IUSR_IUSRS (if using IIS7) or IWAM_(computer name) under IIS6
#For each of these accounts, check '''Allow...''' ''Local Launch'' and ''Local Activation''.

Analytica User FAQs/ADE

2011-11-30T01:00:47Z

AManandhar: /* Setting the permission for the special account */

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application:

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.

However, I can launch ADE (e.g., using AdeTest) from my user account just fine.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5: '''{Computer Name}\ASPNET'''

IIS 6 and 7: '''NETWORKSERVICE''' (group) or '''IIS_IUSRS''' (user)

IIS 7.5: '''IIS AppPool\DefaultAppPool'''<br>

== Finding the special account ==
To set permissions, if using IIS7 do the following:

#Launch Internet Information Services (IIS) Manager
#In the left-hand side Connections pane, open «your server»→'''Application Pools'''
#Click on the application pool used by your web app, then press '''Advanced Settings...'''
#Find '''Identity'''. Make a note the account name. Is usually NETWORK SERVICE.

== Setting the permission for the special account ==

#Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config'''
##Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command '''mmc comexp.msc /32''' instead of the above step.
#Right click on ''Analytica Decision Engine Local Server 4.4'', select '''Properties'''→Security
#Click '''Launch and Activate Permissions'''→ Customize → Edit...
#'''Add...''' NETWORK SERVICE (or the name in step 4 above) and IUSR_IUSRS (if using IIS7) or IWAM_(computer name) under IIS6
#For each of these accounts, check '''Allow...''' ''Local Launch'' and ''Local Activation''.

Analytica User FAQs/ADE

2011-11-30T00:59:02Z

AManandhar:

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application:

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.

However, I can launch ADE (e.g., using AdeTest) from my user account just fine.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5: '''{Computer Name}\ASPNET'''

IIS 6 and 7: '''NETWORKSERVICE''' (group) or '''IIS_IUSRS''' (user)

IIS 7.5: '''IIS AppPool\DefaultAppPool'''<br>

== Finding the special account ==
To set permissions, if using IIS7 do the following:

#Launch Internet Information Services (IIS) Manager
#In the left-hand side Connections pane, open «your server»→'''Application Pools'''
#Click on the application pool used by your web app, then press '''Advanced Settings...'''
#Find '''Identity'''. Make a note the account name. Is usually NETWORK SERVICE.

== Setting the permission for the special account ==

#Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config'''
##Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command '''mmc comexp.msc /32''' instead of the above step.
#Right click on ''Analytica Decision Engine Local Server 4.2'', select '''Properties'''→Security
#Click '''Launch and Activate Permissions'''→ Customize → Edit...
#'''Add...''' NETWORK SERVICE (or the name in step 4 above) and IUSR_IUSRS (if using IIS7) or IWAM_(computer name) under IIS6
#For each of these accounts, check '''Allow...''' ''Local Launch'' and ''Local Activation''.

Analytica User FAQs/ADE

2011-11-30T00:55:32Z

AManandhar:

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application:

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.

However, I can launch ADE (e.g., using AdeTest) from my user account just fine.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5 : '''{Computer Name}\ASPNET'''

IIS 6 and 7 : '''NETWORKSERVICE''' (group) or '''IIS_IUSRS''' (user)

IIS 7.5: '''IIS AppPool\DefaultAppPool'''<br>

To set permissions, if using IIS7 do the following:

#Launch Internet Information Services (IIS) Manager
#In the left-hand side Connections pane, open «your server»→'''Application Pools'''
#Click on the application pool used by your web app, then press '''Advanced Settings...'''
#Find '''Identity'''. Make a note the account name. Is usually NETWORK SERVICE.

For all, do this:

#Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config'''

#Right click on ''Analytica Decision Engine Local Server 4.2'', select '''Properties'''→Security
#Click '''Launch and Activate Permissions'''→ Customize → Edit...
#'''Add...''' NETWORK SERVICE (or the name in step 4 above) and IUSR_IUSRS (if using IIS7) or IWAM_(computer name) under IIS6
#For each of these accounts, check '''Allow...''' ''Local Launch'' and ''Local Activation''.

Analytica User FAQs/ADE

2011-11-30T00:49:15Z

AManandhar: /* ADE won't launch from IIS 7. Access Permissions */

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.

= Cannot instantiate an ADE instance through IIS in an ASP.net application =

The following exception is encountered when attempting to create an instance of ADE in an ASP.NET application:
Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {C1D8F050-CD44-11D1-AEA4-0040054234B1} failed due to the following error: 80070005.
However, I can launch ADE (e.g., using AdeTest) from my user account just fine.

IIS launches COM objects through a special account. This exception is encountered when this special account does not have the required permissions (Local Launch and Local Activation) to create an instance of ADE. The accounts used by different versions of IIS is given below:

IIS 5 : <<Computer Name>>\ASPNET
IIS 6 and 7 : NETWORKSERVICE or IIS_IUSRS
IIS 7.5: IIS AppPool\DefaultAppPool

In IIS 7 the Windows group named IUSR_IUSRS must have the correct permissions to launch ADE (although this can be configured to a different account/group). In IIS6 and earlier, IUSR_WPG group must have these permissions. In each case, the ADE engine will run in the NETWORK SERVICE account.

To set permissions, if using IIS7 do the following:
# Launch Internet Information Services (IIS) Manager
# In the left-hand side Connections pane, open «your server»→'''Application Pools'''
# Click on the application pool used by your web app, then press '''Advanced Settings...'''
# Find '''Identity'''. Make a note the account name. Is usually NETWORK SERVICE.

For all, do this:
# Launch: '''Start→Administrative Tools→Component Services→My Computer→DCOM Config
# Right click on ''Analytica Decision Engine Local Server 4.2'', select '''Properties'''→Security
# Click '''Launch and Activate Permissions'''→ Customize → Edit...'''
# '''Add...''' NETWORK SERVICE (or the name in step 4 above) and IUSR_IUSRS (if using IIS7) or IWAM_(computer name) under IIS6
# For each of these accounts, check '''Allow...''' ''Local Launch'' and ''Local Activation''.

Analytica 4.4 beta Release Notes

2011-10-28T15:53:13Z

AManandhar: /* Notes for Individual Builds */

[[Beta Tester Page|<< Beta Tester Page]]

* For a thorough list of 4.4 enhancements, see [[What's new in Analytica 4.4?]].

= Notes for Individual Builds =

Substantial changes or fixes that have occurred since the previous beta build are listed on the individual pages below.

* [[Analytica 4.4 beta Release Notes/Changes in 4.4.0.13|Build 4.4.0.13]]
* [[Analytica 4.4 beta Release Notes/Changes in 4.4.0.12|Build 4.4.0.12]]
* [[Analytica 4.4 beta Release Notes/Changes in 4.4.0.9|Build 4.4.0.9]]
* [[Analytica 4.4 beta Release Notes/Changes in 4.4.0.7|Build 4.4.0.7]]
* Build 4.4.0.6: First beta release

Beta Tester Page

2011-10-28T15:52:29Z

AManandhar: /* Beta 4.4 downloads */

[[Analytica 4.4]] is now in beta testing. As an Analytica user with active support, we invite you to become a beta tester. Send bugs and feedback to [mailto:support@lumina.com support@lumina.com].

= Becoming a Beta Tester =

* [[Beta Tester Page/Becoming a Beta Tester|Becoming a Beta Tester]], includes:
** How to become a beta tester
** Why become a beta tester
** Responsibilities of a beta tester
** Contributing to the Analytica Wiki
* [[Beta Tester Page/Submitting a Bug Report|Submitting a Bug Report]]

= What's New in 4.4? =

* Enhancements listed at [[What's new in Analytica 4.4?]]
* Changes from beta-build to beta-build are enumerated in [[Analytica 4.4 beta Release Notes|release notes]].

= Beta 4.4 downloads =

The current release is 4.4.0.12. The latest beta-build installers can be downloaded from:

* [http://AnalyticaOnline.com/ANA4.4/AnaSetup4_4_0_13.exe Analytica 32-bit]
* [http://AnalyticaOnline.com/ANA4.4/Ana64Setup4_4_0_13.exe Analytica 64-bit]
* [http://AnalyticaOnline.com/ANA4.4/AdeSetup4_4_0_13.exe ADE 32-bit]
* [http://AnalyticaOnline.com/ANA4.4/Ade64Setup4_4_0_13.exe ADE 64-bit]



= Beta Testing Licenses =

To get the beta software you need a beta-tester license. As a beta tester, you will normally have:
* An individual license for Analytica 4.2 or 4.3 already installed on your computer
* Active support
* An internet connection
In that case, the installer should automatically obtain the necessary beta license and you need to do nothing more (a feature that itself is being beta-tested).

If you are set up with a centrally-managed license for Analytica 4.2 or 4.3 (e.g., a floating license), the installer should still be able to obtain a beta license for you automatically, assuming you have active support and an internet connection.

If you use a floating license with active support and want to install a 4.4 beta license on the RLM server for easy use by anyone in your organization, please contact us via support@lumina.com.



== [[Analytica 4.4 beta Release Notes| Release Notes]] ==

See [[Analytica 4.4 beta Release Notes| release notes]] for what's changed in each beta release. It lists new features and fixes to significant problems.

== Known issues ==

* See the [[Pending Analytica 4.4 Issues]] page for known issues in the current beta build.
* See [[Analytica 4.4 beta Release Notes]] for issues that present in early beta bulids, but since fixed.

= FAQs: Frequently Asked Questions =

See [[Analytica User FAQs]] for frequently asked questions not specific to 4.4 or to beta.

= Other =
== User Group and Special 4.4 Webinars ==

Check the [[Analytica User Group]] page for information on webinars covering new 4.4 features and other topic of general interest to the Analytica community.

Consider being a presenter at a webinar yourself!

Analytica 4.4 beta Release Notes/Changes in 4.4.0.13

2011-10-26T22:52:25Z

AManandhar:

[[Analytica 4.4 beta Release Notes|<< Analytica 4.4 beta Release Notes]]

This page lists fixes in beta build 4.4.0.13 since the previous [[Analytica 4.4 beta Release Notes/Changes in 4.4.0.12|beta build 4.4.0.12]]. For major enhancements since 4.3, see [[What's new in Analytica 4.4?]].

= Expression Assist =

*Expression Assist does not add an extra opening parenthesis if one already exists.

*Expression Assist handles Dynamic contexts more intelligently.

= Tables =

*Fixed issue with very large tables not scrolling all the way to the end.

*Tables do not clip a pixel of the text being edited in a table.

= Animate Window =

*Added a feature to control Window animation feature. Type '''Sys_AnimateWindows : 0''' to turn window animation off and '''Sys_AnimateWindows : 1''' to turn it back on.

*Fixed an issue which caused a window to leave artifacts when closing.

= Slice using local index =

* No need to specify the Variable name when specifying a local index to slice a variable. E.g. '''A[A.I = 1]''' can now be written as '''A[.I = 1]'''

= Graphing =

*Graphs with line-style squared, area fill and stacked options display correctly.

= Object Window =

*Pressing '''Esc''' does not advance focus to the next control.

*Fixed an issue that displayed an erroneous warning when setting Cell Default value to '''Undefined'''

*Object window buttons do not clip the button labels below the baseline.

= List of labels =

*Deleting text of an item from a list of labels now changes it to and empty string, '',''instead of '0'.

= Typescript =

*Fixed issue that caused the Typescipt window to draw itself on the Diagram window.

*Fixed issue that caused the Typescript prompt to get clipped.

= Diagram window =

*Moving nodes around dont leave being artifacts.

= Choice input nodes =

*Fixed a crashing bug caused when a Choice node is defined as a Domain of an index and an input node is created for the Choice node.

*Fixed issues when a Choice node is defined on '''Self''' and an input node is created for it.

= Memory =

*Fixed a crashing bug caused when memory use exceeds 2GB on a 32-bit Windows system.

= File Handling =

*Fixed a crashing bug caused when trying to open corrupted Analytica models.