Question (cont)
We are currently using a business rule to move operational data between cubes. The two cubes have very different dimensionality, including using different entities.
Answer
- The use case will help determine the best approach (e.g., Is extensibility involved or is there the need to transform data as part of the process?).
- In this situation, consider how to store the necessary information needed to identify the source members when running the business rule (e.g., text properties, naming conventions, etc.)
Source: Office Hours 2021-02-04 - Partner Enablement
