Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Drill through feature does not work

When upload the data via flat file everything going well with green check, and all drill through configuration done properly , but it dose not work on the data form .
find attached screenshot
Please advise
Best Answer
-
you can turn off the the drill-through creation from Data Management and update the region in Calc Manager to fit your purpose, alternatively log it with Oracle.
Answers
-
Check the drill through region that has been created in Calc Manager - https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/ecalc/drill_through.html
It might be the drill through region does not match the pov in the form.
Cheers
John
-
Thank you john,
I want to create drill through from data management to data forms , i tried to follow your instruction ,
please check the below screenshot, as you see level 0 flag is false is it related?
however when i change the flag to true and load the data again it turn to false automatically!adviseis there any
-
In your application options, if you have drill through from summary set to Yes then the Level 0 Flag will be set to false as you want to drill at parent levels.
If you don't see the drill through option in a form then it is more than likely your drill definition doesn't match the form.
-
Thank you john,
the drill through definition matched, and all configurations are right.However the problem with the shared hierarchy in entity dimension the FDM don't accept drill through region when you have alternative hierarchy ,
2020-02-06 09:06:03,552 ERROR [AIF]: Cannot Update Drill Through URL. Essbase Error(1200618): Unable to resolve duplicate member name ["Reload Logistics_MAURITIUS"] on line [1]
this was the problem and when i delete the alternative hierarchy it works properly , is there any advise for this problem?
-
Have a read of the support doc - "FCCS-CAN NOT DRILL THROUGH FROM FCCS FOR BASE SHARED ENTITY MEMBERS. ERROR: Cannot Create Drill Through URL. Essbase Error(1200618): Unable to resolve duplicate member name ["XXXXX"] on line [1] (Doc ID 2569951.1)"
-
I read it already, but this made the drill through function does not work, i need to check the entity to drill through region.
-
you can turn off the the drill-through creation from Data Management and update the region in Calc Manager to fit your purpose, alternatively log it with Oracle.