Drill Through in BPC 10

[Former Member]

Hi,

For setting up the drill through to Bex query in BPC 10, I can see 2 tabs , one for "Query String" and other for "Fragment". What is the use  of "Fragment" tab. I could not find any information in the help document.

regards

Kiran

[JohnL]

Hi Kiran,

I don't think BEx queries use a fragment but its possible other drill through sources may use a fragment.

What is the URL you are using and are you using a NW Java portal?

Thanks,

John

[Former Member]

Hi

I am using the url

http://<host>:<port>/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=ZDT_PLANNING&VARIABLE_SCREEN=X&DUMMY=2

However when I test the query in BPC web it shows me the vailable screen on the portal even though I am entering the parameter values after clicking  the test query button.

what could be the reason?

regards

Kiran

[bishwajit_das]

Hi Kiran,

You are probably using the wrong url. The url is of the following format:-

..."http://xxxxxxx:xxxxx/sap/bw/bex?&query=XXXXXXX".......

where, "xxxxxxx:xxxxx" - should be taken from the bpc portal you are accessing.(if you still cannot find please provide me the portal link I will help you)

and the next "XXXXXXX" - should be the BEX Query Technical name.(which I see in your post as ZDT_PLANNING)

Regards,

Bishwajit

[daniel_cepok2]

Hi Kiran,

i have also the same problem to go from BPC Report to BEX query. When I use the url and test it, my BEx Report opens but without using any parameters.

For example, I have a BPC report with some values for different periods in the balance sheet.

When I go to the cell in the BPC report  of the item 11200 in period 2017.01 and then go to drill through, the right report opens but it does not show me the values for the value and also not this item. It show me the balance sheet with all items and for some period which I do not know.

I have the settings which are in the screens:

Can you support me how to enter the parameters to get the right drill through to the bex report with the right filter.

Thanks ane best regards

Daniel