AnsweredAssumed Answered

Displaying path from dynamic static lookup

Question asked by Tony.George88 on Nov 28, 2017

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?

Outcomes