breakdown relation on dot walked fields

[aaronelder]

I am trying to create a breakdown relation on a formula indicator.

The individual breakdowns are dot walked from the location field on the original records and work correctly on the top level indicator.

However, the breakdown relations do not work correctly. I.e. if I have one breakdown on location.floor.building.campus and another on location.floor.building and I create a breakdown relation to drill down from campus -> building , it does not filter buildings by campus properly, it shows all buildings.

Any ideas? 

[Adam Stout]

Can you add some screenshots?  Breakdown relations are defined to connect breakdowns to breakdowns and will work on formula or automated indicators as long as they have both breakdowns.  Most likely, your breakdown relations is defined incorrectly, but I can't tell unless I see the breakdown.

[aaronelder]

[aaronelder]

I should add, the facts table for the indicators and breakdowns is a database view, not a conventional table. Not sure if that makes any difference.

[Adam Stout]

For the breakdown relation, I'm not expecting the base view (although it should work I guess), do you have another table that just has the parent-child relationship?  For example, a relationship between sys_user and sys_use_group, we use sys_grmember.  I also recommend that breakdown sources should always be based on sys_id, not dot walked field (this can be a performance issue depending on scale).  You can always use a related list condition to keep the list relevant (as you have with the 30 day filter).