Returns data audit information from a given range of audit records that meet the specified filtering criteria; the filtering criteria include dimension members, date range, application server, and username. Audit information is returned in several arrays that have a one-to-one correspondence, with data values of audited cells returned as formatted strings.
To return data values of audited cells as doubles instead of strings, or to return data audit information without filtering by dimension members, use EnumDataAuditItems. To get the history of a given cell, use GetCellHistory. |
The lStartRecord and lEndRecord arguments specify the starting and ending indexes of the range of records, and the pvarlTotalRecords argument returns the total number of records that match the filtering criteria. To iterate through all the matching records, in the first call to EnumDataAuditItems pass 0 to lStartRecord, then use the count returned by pvarlTotalRecords to loop through the remaining records.
The number of matching records can change after you call EnumDataAuditItems2. For example, a user might delete some or all of the audit records. |
An application stores audit histories only if the audit-related application settings have been turned on. For more information, see the Oracle Hyperion Financial Management, Fusion Edition Administrator's Guide.
<HFMwData>.EnumDataAuditItems2 dStartTime, dEndTime, vbAllServers, bstrServer, vbAllUsers, bstrUserName, varabstrMemberFilter, lStartRecord, lEndRecord, pvaravarlScenarios, pvaravarlYear, pvaravarlPeriod, pvaravarlEntity, pvaravarlParent, pvaravarlValue, pvaravarlICP, pvaravarlAccount, pvaravarlCustom1, pvaravarlCustom2, pvaravarlCustom3, pvaravarlCustom4, pvaravarbstrServers, pvaravarbstrUserNames, pvaravardTimeModified, pvaravarlActivityCode, pvarabstrValues, pvaravarlNoData, pvarlTotalRecordsThe timestamp of the date range’s starting time and date. The timestamp must be expressed as a Double that can be cast into a valid date. | |
The timestamp of the date range’s closing time and date. The timestamp must be expressed as a Double that can be cast into a valid date. | |
A flag that determines whether to return data audit information for all application servers. Pass TRUE for all servers, FALSE to filter by a specific application server. If you pass FALSE, use the bstrServer argument to specify the application server by which to filter. | |
The name of the application server by which to filter. This argument is used only if the vbAllServers argument is set to FALSE. | |
A flag that determines whether to return data audit information for all users. Pass TRUE for all users, FALSE to filter by a specific username. If you pass FALSE, use the bstrUserName argument to specify the username by which to filter. | |
The username by which to filter. This argument is used only if the vbAllUsers argument is set to FALSE. | |
An array that contains the dimension member names by which to filter cells. The array contains 12 items–one item for each dimension–and is indexed by the HFMConstants type library constants listed in Dimension ID Constants; however, do not use the constant that represents parent Entity members, because parents cannot be used as filters. If you do not want to filter by a given dimension, pass an empty string as the corresponding array item. For example, the following array filters by only the Scenario and Account dimensions: vaFilter(DIMENSIONACCOUNT) = "Sales" vaFilter(DIMENSIONCUSTOM1) = "" vaFilter(DIMENSIONCUSTOM2) = "" vaFilter(DIMENSIONCUSTOM3) = "" vaFilter(DIMENSIONCUSTOM4) = "" vaFilter(DIMENSIONENTITY) = "" vaFilter(DIMENSIONICP) = "" vaFilter(DIMENSIONPERIOD) = "" vaFilter(DIMENSIONSCENARIO) = "Actual" vaFilter(DIMENSIONVALUE) = "" vaFilter(DIMENSIONVIEW) = "" vaFilter(DIMENSIONYEAR) = "" | |
The index of the first record in the range of records to retrieve. This is a zero-based index. | |
The index of the last record in the range of records to retrieve. This is a zero-based index. | |
Returns an array containing the member IDs of the Scenario dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Year dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Period dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Entity dimension members for the data changes’ cells. | |
Future use. Since only data for base entities is tracked for audit purposes in this release, this argument returns an array of items containing the value -1. | |
Returns an array containing the member IDs of the Value dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Intercompany Partner dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Account dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Custom 1 dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Custom 2 dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Custom 3 dimension members for the data changes’ cells. | |
Returns an array containing the member IDs of the Custom 4 dimension members for the data changes’ cells. | |
Returns an array containing the names of the application servers on which the data changes were made. | |
Returns an array containing the usernames of the users who made the data changes. | |
Returns an array containing the timestamps of the data changes. These are returned as Double values that can be cast to the Date format. | |
Returns an array containing the IDs of the user activities that caused the data changes. Valid values are represented by the HFMConstants type library constants listed in User Activity Constants. | |
Returns an array containing the cell values that the data changes resulted in. The values are returned as formatted strings. | |
Returns an array containing that indicates whether cells contain data or no data. Valid values are as follows: | |
Returns the total number of audit records in the database that meet the filtering criteria. |
The following subroutine displays information about the cells that match the filtering criteria. The subroutine takes an array of dimension member filters and the start and end indexes of the range of audit records to retrieve. Note that the labels of the cells’ dimension members are concatenated in a string and obtained by passing the member IDs returned by EnumDataAuditItems2 to HFMwDimension.GetMemberLabel.
Sub PrintDataAudit(vaMemFilter, lStart, lEnd)
Dim cData, vaScen, cMeta, vaYear, vaPer, vaEnt, vaPar
Dim vaValue, vaICP, vaAccount, vaCustom1, vaCustom2
Dim vaCustom3, vaCustom4, vaServers, vaUsers, vaTimeModified
Dim vaActivities, vaValues, vaNoData, vaRecs
Set cData = Server.CreateObject("Hyperion.HFMwData")
Set cMeta = Server.CreateObject("Hyperion.HFMwMetadata")
' cHFMSession is a previously set HFMwSession object
cData.SetWebSession cHFMSession
cMeta.SetWebSession cHFMSession
cData.EnumDataAuditItems2 0, CDbl(Now), True, "", True, "", _
vaMemFilter, lStart, lEnd, vaScen, vaYear, vaPer, vaEnt, _
vaPar, vaValue, vaICP, vaAccount, vaCustom1, vaCustom2, _
vaCustom3, vaCustom4, vaServers, vaUsers, vaTimeModified, _
vaActivities, vaValues, vaNoData, vaRecs
For i = LBound(vaScen) To UBound(vaScen)
' the following lines concatenate the labels of the
' cell's members
strPOV = cMeta.dimension(DIMENSIONSCENARIO).GetMemberLabel _
(vaScen(i)) + ", " + cMeta.dimension(DIMENSIONYEAR) _
.GetMemberLabel(vaYear(i)) + ", " + cMeta.dimension _
(DIMENSIONPERIOD).GetMemberLabel(vaPer(i)) + ", " + _
cMeta.dimension(DIMENSIONENTITY).GetMemberLabel(vaPar(i)) _
+ "." + cMeta.dimension(DIMENSIONENTITY).GetMemberLabel _
(vaEnt(i)) + ", " + cMeta.dimension(DIMENSIONVALUE). _
GetMemberLabel(vaValue(i)) + ", " + cMeta.dimension _
(DIMENSIONICP).GetMemberLabel(vaICP(i)) + ", " + _
cMeta.dimension(DIMENSIONACCOUNT).GetMemberLabel _
(vaAccount(i)) + ", " + cMeta.dimension(DIMENSIONCUSTOM1). _
GetMemberLabel(vaCustom1(i)) + ", " + cMeta.dimension _
(DIMENSIONCUSTOM2).GetMemberLabel(vaCustom2(i)) + ", " + _
cMeta.dimension(DIMENSIONCUSTOM3).GetMemberLabel _
(vaCustom3(i)) + ", " + cMeta.dimension(DIMENSIONCUSTOM4). _
GetMemberLabel(vaCustom4(i))
Response.Write "<p>POV: " & strPOV & " --User: " & _
vaUsers(i + 1) & " -- Modified: " &CDate(vaTimeModified(i)) _
& " Amount: " & vaValues(i + 1) & "</p>"
Next
End Sub