EssSetCurrency

Description

Sets Essbase currency information for the specified spreadsheet.

Syntax

EssSetCurrency([workbookName]sheetName, currencyIdentifier)

Where [workbookName]sheetName is the text name of the workbook and worksheet where the information is retrieved.

currencyIdentifier is the text name of the form:

CurName->CurTime->CurCategory->CurType

Not all currency items must be included. For example, here is one currency identifier:

 "Qtr1->Yen"

Example

=EssSetCurrency("[Sample$.xls]Sheet1", "FEB->STERLING")

Notes: