BusinessObjects Board

Mis. Variable Creation

I have the following table build

Parent -> Subsidiaries

The way my universe was made is a little funky. For example, we associate events to Subsidiaries. I would like to know which individual “Parent” was met during the year. Right now I have created a variable with Subsidiarity IDs met during the year. If I make a table and attach this variable to the generic parent object I get duplicate parents which is correct because we may have met with different subsidiaries of the same parent group… Is there any way to create a variable that singles out the parents of subsidiaries met this year?


sum57 (BOB member since 2018-01-02)