BPC 10 Drill Through to Cube

[AlpAltinturk]

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#

[former_member186338]

Sorry, but not clear!

1. Have you managed to setup standard DrillThrough?

2. "VBAFunctionBeforeDrillThrough and VBA function after drillthrough do not run." - why do you think it will run??

[AlpAltinturk]

1. If by "standard DT", you mean setting a DT from BPC Web UI> Administration; then yes, i did.

I see the option i set from BPC web admin, and as i copied the DrillThrough.xml i also see my own DT (for this example, "(Local) Sample DT") under the DT menu.

2. Correct my logic if I'm wrong: I assume a function/subroutine named in VBAFunctionBefore (after) DrillThrough would be run before doing a DT operation, similar to BEFORE_REFRESH-AFTER_REFRESH concept.

Do you think it's normal that it does not run? then, why?
Btw, VBA just shows a MsgBox. one-liner.

[former_member186338]

"Correct my logic if I'm wrong: I assume a function/subroutine named in VBAFunctionBefore (after) DrillThrough would be run before doing a DT operation, similar to BEFORE_REFRESH-AFTER_REFRESH concept."

Absolutely wrong! Only documented event functions are working, not other 🙂

[AlpAltinturk]

Hahaha awesome, I didn't know this. I really appreciate you pointing it out! 🙂

I'll try to launch with an event func.

But VBA is the lesser evil in this case, not being able to see something particular in Perf. Trace log frustrates me.

I tried the same config without any VBA function calls, and it was behaving this way anyway. Do you have any ideas, or suggestions?

[former_member186338]

Please read this old but useful document: https://archive.sap.com/documents/docs/DOC-4235

[AlpAltinturk]

Thank you for this document. Google shows this as a reference document therefore I already read it, but it wasn't giving a clear idea of how to do Drill-Through to cube. DT configured via an URL through BPC administration page --used for ECC and BEx-- is working, but DT to cube set by XML file is.. problematic

Among all (already scarce) sources, the most up-to-date info I found is on this help.sap.com page.

[former_member186338]

Ups, I can see you are working with a standard model with /CPMB/ namespase but trying to perform drill through to Large Volume Data Sources... It can't be done using BPC Connection!