I have an attribute that uses a static dependent lookup. The lookup has two levels. I need to create Jasper report that has two columns. One column to show the parent (level 1) and the other to show the child (level 2). Is the path known in the data warehouse so that both columns can be created? If not is there a way to create a second read only attribute that extracts the parent (level 1) using NSQL or some other method?