Retrieves attribute specifications for the outline.
Syntax
EsbOtlGetAttributeSpecifications (hOutline, AttrSpecs) ByVal hOutline As Long AttrSpecs As ESB_ATTRSPECS_T
Parameter | Description |
---|---|
hOutline | Handle to the outline |
AttrSpecs | Attribute specifications |
Notes
This function is similar to EsbGetAttributeSpecifications(), except that it returns information from the opened outline.
Set attribute specifications for the outline using EsbOtlSetAttributeSpecifications().
Attribute specifications are used to do the following:
Generate a long name
Indicate the format of a datetime attribute
Indicate a numeric attribute's bucketing type
Provide the name of the attribute calculations dimension and the names for the values used with it
Return Value
Returns STS = 0 when successful. Otherwise, returns an error code.
Access
This function requires no special privileges.
Example
Sub ESB_OtlGetAttributeSpecifications() Dim OutAttrSpecs As ESB_ATTRSPECS_T Dim test As String Dim sts as long hOutline = ESB_OtlOpenOutline If hOutline = vbNull Then Out "ESB_OtlOpenOutline() failed: " & sts: Exit Sub sts = EsbOtlGetAttributeSpecifications(hOutline, OutAttrSpecs) If sts <> 0 Then Out "ESB_OtlGetAttributeSpecifications failed" & sts: Exit Sub Out "ESB_OtlGetAttributeSpecifications passed: " & sts Out "DefaultTrueString : " & OutAttrSpecs.DefaultTrueString Out "DefaultFalseString : " & OutAttrSpecs.DefaultFalseString Out "DefaultAttrCalcDimName : " & OutAttrSpecs.DefaultAttrCalcDimName Out "DefaultSumMbrName : " & OutAttrSpecs.DefaultSumMbrName Out "DefaultCountMbrName : " & OutAttrSpecs.DefaultCountMbrName Out "DefaultAverageMbrName : " & OutAttrSpecs.DefaultAverageMbrName Out "DefaultMinMbrName : " & OutAttrSpecs.DefaultMinMbrName Out "DefaultMaxMbrName : " & OutAttrSpecs.DefaultMaxMbrName test = OutAttrSpecs.GenNameBy Select Case test Case ESB_GENNAMEBY_PREFIX Out "GenNameBy : ESB_GENNAMEBY_PREFIX" Case ESB_GENNAMEBY_SUFFIX Out "GenNameBy : ESB_GENNAMEBY_SUFFIX" Case Else Out "GenNameBy : invalid" End Select test = OutAttrSpecs.UseNameOf Select Case test Case ESB_USENAMEOF_NONE Out "UseNameOf : ESB_USENAMEOF_NONE" Case ESB_USENAMEOF_PARENT Out "UseNameOf : ESB_USENAMEOF_PARENT" Case ESB_USENAMEOF_GRANDPARENTANDPARENT Out "UseNameOf : ESB_USENAMEOF_GRANDPARENTANDPARENT" Case ESB_USENAMEOF_ALLANCESTORS Out "UseNameOf : ESB_USENAMEOF_ALLANCESTORS" Case ESB_USENAMEOF_DIMENSION Out "UseNameOf : ESB_USENAMEOF_DIMENSION" Case Else Out "UseNameOf : invalid" End Select test = OutAttrSpecs.Delimiter Select Case test Case ESB_DELIMITER_UNDERSCORE Out "Delimiter : ESB_DELIMITER_UNDERSCORE" Case ESB_DELIMITER_PIPE Out "Delimiter : ESB_DELIMITER_PIPE" Case ESB_DELIMITER_CARET Out "Delimiter : ESB_DELIMITER_CARET" Case Else Out "Delimiter : invalid" End Select test = OutAttrSpecs.DateFormat Select Case test Case ESB_DATEFORMAT_MMDDYYYY Out "DateFormat : ESB_DATEFORMAT_MMDDYYYY" Case ESB_DATEFORMAT_DDMMYYYY Out "DateFormat : ESB_DATEFORMAT_DDMMYYYY" Case Else Out "Delimiter : invalid" End Select test = OutAttrSpecs.BucketingType Select Case test Case ESB_UPPERBOUNDINCLUSIVE Out "BucketingType : ESB_UPPERBOUNDINCLUSIVE" Case ESB_LOWERBOUNDINCLUSIVE Out "BucketingType : ESB_ESB_LOWERBOUNDINCLUSIVE" Case ESB_UPPERBOUNDNONINCLUSIVE Out "BucketingType : ESB_UPPERBOUNDNONINCLUSIVE" Case ESB_LOWERBOUNDNONINCLUSIVE Out "BucketingType : ESB_LOWERBOUNDNONINCLUSIVE" Case Else Out "BucketingType : invalid" End Select End Sub
See Also