Skip to Content
0
Apr 03, 2017 at 09:15 AM

BPC 10 Drill Through to Cube

263 Views Last edit Apr 10, 2017 at 04:52 PM 4 rev

Hello everyone,

I have a problem with an example case for drill through to cube feature:

When I launch my DrillThrough to Cube from Excel, a loading message shows up for a second and disappears quickly.

I would ask if you could take a look at the configuration XML? I feel like I'm not seeing the obvious, or missing something.
Excel EPM log doesn't show any info about this so I can't find the point of failure.

Extra info:

  • I created a super simple, working MDX query via MDXTEST, and when i launch it using that transaction, I'm able to see the results on a popup window as expected.
  • Drill Through to Url (which is set from BPC) is working normally: opens an IE window and shows me the info.
  • DT uses same connection = same server = no extra connection info needed (in theory). When added a dummy connectionstring, DT tries to connect to the server (but fails obviously. This step tells me at least some of DT functionality is working.)

My DrillThrough.xml:

<DrillThroughToCubeInfo>
  <MDXQuery>
    SELECT
      [/CPMB/NXXXXX1].Members ON COLUMNS,
      [/CPMB/NXXXXX2].Members ON ROWS
    FROM [$/CPMB/NYYYYYY]
  </MDXQuery>
  <DisplayName>(Local) Sample DT</DisplayName>
  <VBAFunctionBeforeDrillThrough></VBAFunctionBeforeDrillThrough>
  <VBAFunctionAfterDrillThrough></VBAFunctionAfterDrillThrough>
</DrillThroughToCubeInfo>

Thanks in advance for any ideas!

Edit: Log dump for one DT launch - all from |TRACE|Performance|

12:36:46,040 | ... |Method [DrillThroughToCube] start# 
12:36:46,045 | ... |Method [Load Reports Sheet1] start# 
12:36:46,045 | ... |Method [Load Reports Sheet1] end, duration = 0.000 s# 
12:36:46,045 | ... |Method [DrillThroughConnect] start# 
12:36:46,110 | ... |Method [DrillThroughConnect] end, duration = 0.065 s# 
12:36:46,115 |...|Method [GetDrillThroughParameters] start# 
12:36:46,115 |...|Method [GetDrillThroughParameters] end, duration =0.000 s#
12:36:46,115 | ... |Method [MapParametersOnSource] start# 
12:36:46,115 | ... |Method [MapParametersOnSource] end, duration = 0.000 s#
12:36:46,115 | ... |Method [ReplaceDrillThroughParameters] start# 
12:36:46,115 |...|Method [ReplaceDrillThroughParameters] end,duration =0.0s 
12:36:46,135 | ... |Method [DrillThroughToCube] end, duration = 0.090 s#