GetDimensionRestrictedData
Lists target dimension IDs that have many-to-one or one-to-many relationships from a given source dimension.
Stored Procedure-Specific Information
Note: This stored procedure only lists OneToMany and ManyToMany relationship types. To get the OneToOne and ManyToOne related record keys, query the source table directly, and the relationship column should contain the keys of the related records.
To figure out the relationship fields for a certain table (Sage Intacct object), call the GetRelationshipColumns with the TableName input parameter set to the object name.
For helpful information on the dimension type objects and their relationships, query the tables below.
- Dimensions: Useful to list all the available dimension type objects.
- DimensionRelationships: Useful to get information on the available relationships between dimension type objects.
To execute this procedure, enter:
EXEC GetDimensionRestrictedData Dimension='Glaccount', Key='1005'
Input
| Name | Type | Description |
| Dimension | String | The name of the source dimension object for which related dimension records are to be listed. |
| Key | String | The ID of the source dimension record for which related dimension records are to be listed. Leave this blank to query all available related IDs for the specified dimension. |
Result Set Columns
| Name | Type | Description |
| RelatedDimension | String | The name of the related standard dimension or user-defined dimension (UDD) that is the target of a to-many relationship. |
| RelatedRecordKey | String | The IDs of the related dimension records that are targets of to-many relationships. |