PCM Model Retrieval Methods

Home/PCM Model Retrieval Methods

PCM Model Retrieval Methods

GetAlias #

This function retrieves the Alias when given a dimension name.

Item Value
SAP PCM Cube GetAlias
PlaidXL Method GetAlias
Arguments Dimension
Member Name
EPO Alias

For example, this is the customer dimension for the member 1’s default alias.

customer default

GetPCMModelName #

Retrieves the current PCM model.

Item Value
SAP PCM Cube GetPCMModelName
PlaidXL Method GetPCMModelName

GetRetrieveTime #

This retrieves the time elapsed since the Retrieve button was last pushed and since the PlaidXL function in the current tab last ran.

Item Value
SAP PCM Cube GetRetrieveTime
PlaidXL Method GetRetrieveTime

For example, this shows a retrieve time of 6 seconds.

retrieve time

GetParent #

This function works for the Main dimension only.

Item Value
SAP PCM Cube GetParent
PlaidXL Method GetParent

GetParentBelowParent #

This function also works on Main dimension only and has the same functionality as GetParentBelowGroup.

Item Value
SAP PCM Cube GetParentBelowParent
PlaidXL Method GetParentBelowParent
Arguments Dimension Name
Parent Name
Child Name

GetMemo #

This function retrieves the memo. While there is no equivalent operation in PCM, each member can have a memo associated with them.

Item Value
SAP PCM Cube GetMemo
PlaidXL Method GetMemo
Arguments Dimension
Member Name

GetProperty #

This returns the value of a Workflow property (defined by the Workflow Manager). It can be used to determine what state the current workflow process has reached.

Item Value
SAP PCM Cube GetProperty
PlaidXL Method GetProperty
Arguments Dimension
Member Name
Property

GetParentBelowGroup #

This returns the first Parent when given a group name. However, it works on attribute dimensions only.

Item Value
SAP PCM Cube GetParentBelowGroup
PlaidXL Method GetParentBelowGroup
Arguments Dimension Name
Group Name
Child Name

For example,

GetParentBelowGroup(“Customers”,”Customers Type”,”Existing Customers that use Vision Leasing”) returns “1”

GetParentBelowGroup(“Customers”,”Total Customers”,”Existing Customers that use Vision Leasing”) returns “Existing Customers”

Go to Top