I have a question about the drill through functionality in FDM vs ERPi. Can custom dimensions be part of the drillable region in ERPI? In other words can I drill through to this intersection:

Account->entity->custom1->custom2->year->scenario->etc.

In my Planning application setup, accounts exist for entities comprising company, division and sub-division. For various reasons, company, division and sub-division are organized as separate dimensions. Company is actually the name of the default entity dimension in Planning, while division, sub-division are custom dimensions. So when a user wants to drill through for a particular account, they are drilling through to the intersection of account->company(entity)->division(custom)->sub-division(custom).

I know that FDM lets us drill through to whatever intersection we want. Does ERPi let us achieve that too? I'm asking because the documentation says drill through is enable for entity/account/scenario/year/period and it makes no mention of drilling through to custom dimensions.

Please be more specific on what target application you are loading data too.

If you are loading to Essbase, then the drill region only encompasses the Scenario/Category, Year and Period of the load. It does not go granular to include the additional dimensions. So that means everything that is common to that Scenario/Category, Year and Period will show a drill-through option... although it technically won't be drillable.

The only product that allows exact intersection drillback is HFM and Enterprise.

To understand what I said; you need to have a conceptual basis for Essbase. All data that is contained under that Scenario/Category, Period and Year (as they are part of an intersection) will have the ability for drill through.

You are asking at a VERY granular level ... ie: Exact intersection, no variation.

What I am stating is that EVERY intersection that contains that Scenario/Category, Period and Year will have the option for drill through ... even though it may not be valid.