Skip to Content
0
Apr 29, 2014 at 10:07 AM

Drill down in same dimension

21 Views

Hi

I have a case where I have a table with orders that contains fields for order numbers and parent id numbers. Now I want to be able to drill down from main order to child order in a report. The problem is the only difference between a main and a child order is the parent id is empty for main order and filled in with order of main order number on child order.

So what I want to achieve is a list of main orders and when clicking one order I want to see child orders.

I'm quite new at BO so please excuse my stupid question...


Server version is 3.1 and DW is SQL.

Thanks for your help!

Regards,

Magnus