I am trying federate two datasets from two different datasources into a federated dataset. The individual datasets work fine as seen from the dataset preview. After the federation condition is defined while creating a new federation - Knowage allows saving the federated dataset . However when I try to open the federation in QBE - it gives me an error saying it could not load the datasets - specifically:
"An unpredicted error occurred while executing SpagoBIQbeEngine service. The root cause of the error is: Error loading the dataset. Please check that all the dataset linked to this federation are still working"
. Please note that the individual datasets are SQL Query based with parameters. However , federation for two datasets from a single datasource works fine.
