The Jiwa BI model won't load and the re-load scripts report an error
One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop(s) will be cut by setting one or more tables as loosely coupled."
The error indicates that there are duplicate references in the data. Usually this is found amongst the categories. For example, check that all inventory category labels are unique. Check that the contents of each inventory category are unique. E.g. 'Default category' for category 1 and 'Default category' for category 2 should be renamed to 'Default category 1' and 'Default category 2' respectively. Repeat for debtors
In addition, make sure the category labels between debtors and inventory are unique. 'Category 1' in debtors and 'Category 1' in inventory will cause a loop. Re-name them to 'Debtors Category 1' and 'Inventory Category 1'. Or, as per the demo data 'Market' and 'Product Type'.
|Content by Label|
|cql||label in ("jiwa_bi_model","loop","re-load","reload","loops","jiwa_bi") and type = "page" and space = "J7UG"|
|labels||jiwa_bi jiwa_bi_model loop loops re-load reload|