How are the drill details determined?

Hello - I am using report builder against models.

Which attributes or properties determine what is shown when you do click/drill into the details? I'm using the adventure works database as my guide and expected the (default,Identifying or Aggregate ) attributes to control it, can you summarize how the drill details are determined? My test from adventure works sample:

Pull Territory Name and #customers into the report Run it and drill into the details on one of the #customers It returns Acct#, CustType, CustName, #SalesOrders, Sum of a bunch of sales order fields and # customer addresses. The first three are the default attributes for a customer and the last sets look to be the default aggregates for the other relations to customer - Sales Order & Address.

Is it safe to say that it pulls in the default attributes of the immediate child and then aggregates of it's children? Does it go recursively?

Thanks in advance,

Toni

You are basically correct. I believe it also pulls in identifying attributes of entities for which there is only 1 related instance. No, it is not recursive. If you want full control over the set of fields displayed, you can build your own Clickthrough template report and use SQL Management Studio to configure it as one of the template reports for the target entity (e.g. Customer).

Hope that helps!