This is an example of poor --- very poor framework management. I was actually working on creating some metadata for a custom report and I had only half day time to test it, The report needed an humongous amount of details from various tables and performance was a major issue.
I tried creating metadata from existing metadata in the import layer. When I create new relationship for the 2 new tables which I added for this report, there was a loop issue. Of course when you check the query subject on Framework Manager -- Launch Content Explorer; it does not show any loop. So now, I had to create redundant data in the import layer just for this report in order to accommodate the new query subject and avoid loops. Given more time we could have avoided this by re mapping some of old query subject relationships.
Lesson learn :) ---- Avoid joins to the same query subjects in the import layer. Always look at the base query subject and not the derived once in development layer or the second layer of the Framework Manager.
Anyways, I could find the issue fast and it was an easy solution. Way to go !!!!!
No comments:
Post a Comment