Dataflow Sets amount (Business Rule)

This business rule checks the number of dataflow sets in each dataflow of a model object. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10001.

Message

The client shows an error with this text on the model object. <model object name> and <type> stand for its name and type, <amount> for the allowed number, for example exactly 1 or above or equal to 1.

Model object '<model object name>' of type '<type>' has the wrong amount
of dataflow sets defined. The amount of dataflow sets per dataflow
should be <amount>.

On the model object card, point to the error icon to see this message with the rule ID: Error ID-10001. The Generate Artifacts page lists the message without the ID.

Cause

A dataflow of the model object has fewer or more dataflow sets than its type allows:

• Exactly one: Mart Hierarchy Flatten, Hierarchy Flatten, Current View, History View, Business Current View and Business History View. On the Microsoft SQL Server generator configurations for Stage Files and Stage OpenQuery, also Stage.
• At least one: all other model object types that have dataflows.

Fix

1. Open Manage Term Mappings of the model object.
2. Delete the extra dataflow sets of the dataflow, or add one to an empty dataflow, see Delete a Dataflow Set and Create a Dataflow Set. The error disappears.

Check the result

The error icon is gone from the model object, and generation is no longer blocked by it.

Example

In a Data Mart project on Microsoft SQL Server, the Mart Hierarchy Flatten load_mart_hierarchy_flatten gets a second dataflow set. The client shows:

Model object 'load_mart_hierarchy_flatten' of type 'Mart Hierarchy
Flatten' has the wrong amount of dataflow sets defined. The amount of
dataflow sets per dataflow should be exactly 1.

Related articles

• See also: Create a Dataflow Set, Delete a Dataflow Set, Understand Dataflow, Dataflow Set and Dataflow Set Model Object, Dataflows amount (Business Rule), Understand warnings and errors