What is the exact version of Hyperion(including patch level) are you on?
Does the issue occur in all your environments?
Was the drill region created by Data Management after the data load?
Have you tested with a simple explicit map file with one record and see if you can replicate the issue?
Can you post some screen shot?
Like which intersection you want to drill through and what result it returns to you, so that we can see the difference?
Hyperion version is 184.108.40.206.700.005.
I have tested it only in one environment, as don't have access to others
The drill region was successfully created
Will test it now for a simple explicit map file, but the weird thing is that I have one location with 4 load rules, and the drill through is working for only one of them.
Could you please explain/ or give me a reference for materials, how the mappings can impact the drill through?
can you get the SQL generated for the drill through from the server log?
Not sure how I can get the Drill Through SQL, can you give me a hint please?
Thanks in advance
DId you look at the server logs?
Yes create a simple explicit mapping for a single record file and load and then test .
The recommendation would be make sure you are at the proper base level location and then attempt the drill.
As others have mentioned screenshot the workbench and where you drill from in the data grid to ensure you looking the identical intersection.
Are you talking about ErpIntegrator ones?
The locations which are shown unexpectedly... did they load data to that intersection at some time?
So, I can't find anything related to drill through in the ERPIntegrator.log. Maybe it should be in the HFM logs.
The other locations, have been loading data in the same intersections, but different periods. This is explainable as I have redirected the same FDMEE periods to point to different HFM periods.
I think I found the issue: the drill through is case sensitive, and I was using all capitals for a None member, in my FDMEE mappings. Now it works fine!
Which version FDMEE version are you?
PLease mark this question as answered then so others can see it
Using 220.127.116.11.700.005 v FDMEE.
Thank you for including the resolution.