Undocumented Analysis Functions and Arguments
It’s clear that the Analysis User Guide (1.4 2013-05-30) isn’t up to date with Analysis Add-in (1.4 SP3.1), but I do remember seeing somewhere that SAP plan to revise the document soon. Hopefully my findings below are reflected in the revised user guide. In the interim, here are functions and arguments that I’ve discovered….
These functions and arguments are undocumented, but that doesn’t necessarily mean that they’re unsupported – They’re just not included in the user guide. They become evident when you convert crosstabs to formulas, and they’re visible to the Excel Function Wizard – so the Add-In is using these functions already. I’ve confirmed that they work in 1.4 SP0 and 1.4 SP3.1.
There may be more functionality that I’m not aware of, so please comment if you find any more features that aren’t in the user guide
SAPGetUniformScaling – Returns the unit/scaling information of a dimension member comnbination
This function is available to the worksheet and VBA.
– Data Source – Formula Alias of Data Source.
– Measure – Name or technical name of a measure.
– Member Combination – Eg: ‘DIMENSION1=VALUE1;DIMENSION2=VALUE2’
Functions with undocumented Arguments:
The User Guide states that this function accepts 3 arguments: Data Source, Dimension, and Property Name, and it states that Property Name can be either “NAME” or “ACTIVEHIERARCHY”.
The Excel Function Wizard shows that the function actually accepts up to 4 arguments when you’re handling Dimension Attributes:
– Data Source
– Property Name – Can actually be “NAME”, “ACTIVEHIERARCHY” or “ATTRIBUTE” – Seems to be case insensitive
– Attribute – Optional. When Property Name = “ATTRIBUTE”, this argument accepts the Technical name of the attribute.
The user guide alludes to to the capabilities of this function: “This function returns the dimension member or attribute.”, and while it does document how to retun Member details, it doesn’t document how to return Attribute details.
There isn’t an extra argument, but instead, the 3rd argument, “Member Display” will accept an Attribute Technical Name that is suffixed with “_Text” or “_Key”. There doesn’t seem to be a way of specifying Short, Medium or Long Text.
For example: SAPGetMember(“DS_1”, “CURRENCY1=GBP”, “CURRSYMBOL_Text”) would return the CURRSYMBOL attribute text for CURRENCY1 member GBP.