We are using FDM to load a flatfile containing our general ledger to Planning/Essbase.
This file contain level 0 of our general ledger (account, thirdparty and cost centre) and we are also loading at the level 0 on Essbase / Planning
=> All our users are complaining about the drill through feature that is not useable in Financial Reporting since it's nearly impossible to drill down on all level 0 of all the cube dimension using FR.
=> Similar issue on Smart View where it takes a long time in order to see detailed bookings if you have several crossings to check...
=> For example, what they want is to be able is to drill through at the "total turnover" (parent of several accounts) and at the "total thirdparty" and be able to see all bookings per accounts and per partner (level 0)
- Do you know if there is a way to handle this request with FDM ?
- Do you know if FDM EE 184.108.40.206 brings updated drill through feature (since it's also using ERPi features ?)
- How are you dealing with these requests ? Workaround ? Essbase studio ?
You could crate drill regions for parent members. But the issue is that when you drill-through from any intersection, if that includes a parent member...it will try to find that intersection in FDM/ERPI/FDMEE and not the the intersection for children.
Essbase Studio may do it as you can configure the SQL queries.