Excel Paste Functions

Below are lists the Excel Paste Functions, followed by their purpose and argument.

•    OLAPAlias
- Returns the Alias from the specified Alias group at index.

Argument: (database, dimension, group, index)

•    OLAPAliasGroup
- Returns the name of the nth Alias group for the specified Dimension.

Argument: (database, dimension, n)

•    OLAPAliasGroupCount
- Returns the number of Alias groups for the specified Dimension.

Argument: (database, dimension)

•    OLAPAliasToMember
- Returns the Member of the Dimension for the Alias in the Alias group.

Argument: (database, dimension, group, alias)

•    OLAPCanAddDimensionsAndCubes
- Returns True if the user or group can add Dimensions or Cubes in the current database.

Argument: (database, User/Group)

•    OLAPChild
- Returns the nth child of the specified Member in the specified Dimension.

Argument: (database, dimension, member, n)

•    OLAPChildCount
- Returns the number of children of the specified Member in the specified Dimension.

Argument: (database, dimension, member)

•    OLAPCube
- Returns the name of the nth Cube in the currently open database.

Argument: (database, n)

•    OLAPCubeCount
- Returns the number of Cubes in the currently open database.

Argument: (database)

•    OLAPCubeDimCount
- Returns the number of Dimensions in the specified Cube.

Argument: (database, cube name)

•    OLAPCubeDimension
- Returns the nth Dimension in the Cube.

Argument: (database, cube, n)

•    OLAPCubeSecurity
- Returns the security privileges for the user or group for the Cube in the current database.

Argument: (database, cube, User/Group)

•    OLAPCurrentUser
- Returns the name of the current user in the current database.

Argument: (database)

•    OLAPDatabase
- Opens the specified database.

Argument: (database, dimension, member, n)

•    OLAPDimCount
- Returns the number of Dimensions in the currently open database.

Argument: (database)

•    OLAPDimension
- Returns the name of the nth Dimension in the currently open database.

Argument: (database, n)

•    OLAPDimensionSecurity
- Returns the security privileges for the user or group for the Dimension in the current database.

Argument: (database, dimension, User/Group)

•    OLAPDimMaxLevel
- Returns the highest-level number in the Dimension.

Argument: (database, dimension)

•    OLAPFactSecurityMember
- Returns the indexed Member for the Cube, range and Dimension in the current database.

Argument: (database, cube, RangeIndex, …)

•    OLAPFactSecurityMemberCount
- Returns the number of Members for the Cube, range and Dimension in the current database.

Argument: (database, cube, RangeIndex, …)

•    OLAPFactSecurityPrivileges
- Returns the privileges of the point for the user/group and Cube in the current database.

Argument: (database, cube, User/group, k1, …)

•    OLAPFactSecurityRangeMembers
- Returns the Member list for the user/group, Cube and range in the current database.

Argument: (database, cube, …)

•    OLAPFactSecurityRule
- Returns the text of the security range for the Cube in the current database.

Argument: (database, cube, index)

•    OLAPFactSecurityRuleCount
- Returns the number of security ranges for the Cube in the current database.

Argument: (database, cube)

•    OLAPFactSecurityRuleName
- Returns the name of the security range for the Cube in the current database.

Argument: (database, cube, index)

•    OLAPFactSecurityStatus
- Returns the status of the range in the Cube in the current database.

Argument: (database, cube, index)

•    OLAPGroup
- Returns the specified group in the current database.

Argument: (database, index)

•    OLAPGroupCount
- Returns the number of groups in the current database.

Argument: (database)

•    OLAPIsChildOf
- Returns true if the specified child belongs to the specified parent in the specified Dimension.

Argument: (database, dimension, parent, child)

•    OLAPIsParentOf
- Returns true if the specified child belongs to the specified parent in the specified Dimension.

Argument: (database, dimension, child, parent)

•    OLAPIsSecureDatabase
- Returns True if the current database is secure.

Argument: (database)

•    OLAPMember
- Returns the nth Member in the Dimension.

Argument: (database, dimension, n)

•    OLAPMemberCount
- Returns a count of the number of Members in the Dimension.

Argument: (database, dimension)

•    OLAPMemberFirst
- Returns the first Member in the specified Dimension.

Argument: (database, dimension)

•    OLAPMemberIndex
- Returns the index number of the Member in the Dimension.

Argument: (database, dimension, member)

•    OLAPMemberLevel
- Returns the level number of the Member in the Dimension.

Argument: (database, dimension, member)

•    OLAPMemberNext
- Returns the next Member in the Dimension after the specified Member

Argument: (database, dimension, member)

•    OLAPMemberProperty
- Returns the property value for this Member in this group.

Argument: (database, dimension, member, group)

•    OLAPMemberToAlias
- Returns the Alias from the specified alias group for the Member in the Dimension.

Argument: (database, dimension, group, member)

•    OLAPMemberType
- Returns the type of the Member in the specified Dimension.

Argument: (database, dimension, member)

•    OLAPParent
- Returns the nth parent of the specified Member in the specified Dimension.

Argument: (database, dimension, member, n)

•    OLAPParentCount
- Returns the number of parents of the specified Member in the specified Dimension.

Argument: (database, dimension, member)

•    OLAPPivot
- Builds a Slice over the specified range for this Cube.

Argument: (database, cube, range, zeroRows, zeroColumns)

•    OLAPPropertyGroup
- Returns the name of the nth property group for this Dimension.

Argument: (database, dimension, index)

•    OLAPPropertyGroupCount
- Returns the number of property groups in the specified Dimension.

Argument: (database, dimension)

•    OLAPRead
- Returns the value of the Cube based upon the parameters k1 to kn.

Argument: (database, cube, k1, k2, …, kn)

•    OLAPReadWrite
- Returns the value of the Cube based upon the parameters k1 to kn; and enables data entered in worksheet to be set back to database.

Argument: (database, cube, k1, k2, …, kn)

•    OLAPRoot
- Returns the nth root of the specified Dimension.

Argument: (database, dimension, n)

•    OLAPRootCount
- Returns the number of roots in the specified Dimension.

Argument: (database, dimension)

•    OLAPSave
- Saves the specified database.

Argument: (server, database, file)

•    OLAPSliceSecurity
- Returns the security privileges for the user or group for the Slice in the current database.

Argument: (database, slice, User/Group)

•    OLAPSubset
- Returns the nth subset of the specified Dimension in the currently open database.

Argument: (database, dimension, n)

•    OLAPSubsetCount
- Returns the number of subsets in the specified Dimension.

Argument: (database, dimension)

•    OLAPSubsetMember
- Returns the nth Member in the specified subset of the currently open database.

Argument: (database, dimension, subset, n)

•    OLAPSubsetMemberCount
- Returns the number of Members in the specified subset of the currently open database.

Argument: (database, dimension, subset)

•    OLAPTable
- Creates a table of values from the Cube based upon the parameters k1 to kn; also enables writing data from the worksheet to the database.

Argument: (database, cube, k1, k2, …, kn)

•    OLAPUser
- Returns the specified user the current database.

Argument: (database, index)

•    OLAPUserCount
- Returns the number of users in the current database.

Argument: (database)

•    OLAPUserGroup
- Returns the current user in the group in the current database.

Argument: (database, Group, index)

•    OLAPUserGroupCount
- Returns the number of users in the group in the current database.

Argument: (database, Group)

•    OLAPUserInGroup
- Returns the current user in the group in the current database.

Argument: (database, Group, User)

•    OLAPWeight
- Returns the weight of the child relative to the parent in the Dimension.

Argument: (database, dimension, parent, child)

•    OLAPWrite
- Writes a value to a point in the specified Cube.

Argument: (database, cube, value/member1, value/member2, …)

•    OLAPWriteAliasToCube
- Returns the Alias name if successfully written to the Cube.

Argument: (database, dimension, aliasgrpName, …)

•    OLAPWriteMemberToCube
- Returns the Member name if successfully written to the Cube.

Argument: (database, dimension, …)