Tableau Connector for Sage Intacct

Build 21.0.7930

GetDimensionRestrictedData

Lists the IDs of related dimensions that are the targets of to-many relationships from a single source dimension.

Stored Procedure Specific Information

Note: This stored procedure will only list OneToMany and ManyToMany relationship types. To get the OneToOne and ManyToOne related record keys, you can directly query the source table, 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), you can call the GetRelationshipColumns with the TableName input parameter set to the object name.

Helpful information on the dimension type objects and their relationships can be found by querying 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.

Input

Name Type Description
Dimension String The source dimension object name for which to list the related dimension records.
Key String The ID of the source dimension record for which to list the related dimension records.

Result Set Columns

Name Type Description
RelatedDimension String Name of the related standard dimension or UDD that is the target of a to-many relationship.
RelatedRecordKey String IDs for the related dimension values that are the targets of to-many relationships

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930