ShihMin Huang Posted January 14, 2020 Share Posted January 14, 2020 Hi, I have a on-demand table need to load automatically. But when I tick the load automatically, and refresh the data again, met an error I have no idea why this simple relationship between both tables cause cycle dependencies. How could I solve this issue Here is the error description. Automatic on-demand loading cannot be performed due to cyclic dependencies. Cycle found: Data Column: [CustomerHISTORY].[CustomerDescription] Data Column: [CustomerHISTORY].[CustomerID] Data Column: [AllCustomer].[CustomerNumber] The following is its source information 1. Imported data table from data connection. Connection name: Connection View name: CustomerHISTORY Connection type: Oracle MySQL Server: Authentication method: Database authentication Database: On-demand settings Column to filter by: CustomerID Expression: [AllCustomer].[CustomerNumber] Limited by active filtering scheme: No Limited by: (None) Update behavior: Manual Caching allowed: Yes Last reload: 1/13/2020 6:36 PM 2. Edit > Data Table Properties > Relations Added relation: [AllCustomer].[CustomerNumber] [CustomerHISTORY].[CustomerID] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now