How to create Drill through's from BPC to ECC and BEX

[Former Member]

Hi Experts,

@Greetings@

Am new to BPC can any one help me on Drill trough's. I want to create a drill through to ECC system and BEX Query.

Thanks for support in advance.

Regards,

Harini.

[former_member193143]

Hi Harini,

Your Drill through functionality is linked to an on line search website, giving you all necessary information.
During reporting, you need to have more information about selected region.

Before performing or using the Drill-Through feature, ensure that the following prerequisites have been met
        1. You are logged on to any BPC Environment with administration authorizations
        2. From home screen, Switch to the administration area by clicking planning and consolidation                          Administration link
Inside admin area you find Drill through  maintainace in the content tree under the features node.

After opening the Drill through click on New button,

    There we need to enter Id, Decription, URL and model name.

If you want do Drill- through from BEx query first you need to publish the query to portal. see below I mention the procedure for publishing a query in the portal.

BEx Query Designer: In the menu bar, choose Query → Publish → To the Portal. See Functions in the Menu Query.

BEx Web Application Designer: In the menu bar, choose Web Template  → Publish → To the Portal. See Functions in the Menu Query.

BEx Report Designer: In the menu bar, choose Report  → Publish → To the Portal. See Functions in the Menu Query.

After posting to portal copy that link paste in the URL address in the drill through.

In the parameter mapping add infoobjects technical names under parameters and Dimensions names under Dimension or user defined values and maintain the which property you want map mention under the property values.

And the save the query and go to the excel and you have an option in the excel ribbon Drill Through and click on that, you will get the query which you are posted in the portal.

This may help,

Saida Reddy G

[Former Member]

Hi Sasireddy,

Thanks for the reply the above links are not working kindly help me on this.

Regards,

Harini.

[former_member193143]

Hi Harini

Functions in the Query Menu

Functions in the Query Menu - Business Intelligence - SAP Library

Functions of the BEx Query Designer

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a569ae09411d2acb90000e829fbfe/content.htm

Functions of the Web Application Designer Menu Bar

https://help.sap.com/saphelp_nw04/helpdata/en/47/d4fed1c60a9743ade3b4cf306d5d48/content.htm

Functions of the BEx  Toolbar

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a55d2e09411d2acb90000e829fbfe/content.htm

Those are purely related to BI, I little bit know BI work, I think the above links may be helpful for you

Regards,

Saida Reddy G

[Former Member]

HI Saida Reddy,

I executed all the functions am not facing any problem in BI side. Am facing the problem at BPC side.

Kindly guide me if am wrong.

Regards,

Harini.

[former_member193143]

Hi Harini,

In which version you are doing Drill through, Can you please share the screen shots and error messages?

If you have BPC 430 material, please referer that. It would be very helpful for you...

Regards,

Saida Reddy G

[Former Member]

Hi Saida Reddy,

Am working on BPC 10.0 NW. I attached the screenshot in the above discussion.

Kindly guide me on this.

Thanks & Regards,

Harini.

[former_member193143]

Hey Harini,

You are working in local server, is it right.

Did you build a query in BW, As far as I know you should have some inter link between between BW query and BPC report. How did you publish a query in BW.

I see the query what you have build, is their any data in that query. So How did you get web link address which is related to Bw query.

Regards,

Saida Reddy G

[Former Member]

Hi Saida Reddy,

Sorry for the late reply . The data is available in the Query. Now kindly guide further.

Regards,

Harini.

[former_member193143]

Hi Harini,

Please read the above post and clear answer those question.

Reagrds,

Saida Reddy G

[Former Member]

Hi Saida Reddy,

Thanks for the support and i executed the same report in RSRT and i copy pasted the URL  https://xxxxx.xxxxxx.com:8021/SAP/BW/BEX?&QUERY=BPCQUERY123 in BPC Drill through's but am facing the following error. Kidnly guide me how to resolve the issue.

Regards,

Harini.

[former_member193143]

Hey Harini,

your screen shot is not visible, please sahre a clear image. Try to take snaps by using snagit.

regards,

Saida Reddy G

[Former Member]

Please check. thanks for the support Saida reddy.

[former_member193143]

Hi Harini ,

Please answer the following questions

1. Are you working on real time system or local sever( I mean VM ware)

2. Do you have internet connection or not.

3. what is this link

https://xxxxx.xxxxxx.com:8021/SAP/BW/BEX?&QUERY=BPCQUERY123

that link is not opening in my system.

4.I am asking about this image and your providing a different one.If possible share a clear image of below one.

Regards,

Saida Reddy G

[Former Member]

Hi Saida Reddy,

Please accept my apologies.

A) Yes am working on Remote Desktop demo system

B) Am having Internet connection

C) I generated report in RSRT transaction code and executed in WEB the belongs to RSRT Web Query result.

Regards,

Harini.

[nandkishor_bhosale]

Hi Harini,

You can refer to below link for more details on Drill Through functionality.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10a56b21-04b9-2d10-a6b7-e0f8732b4...

Regards,

Nandkishor

[Former Member]

Hi Kishor,

I gone through the above document but am facing the following error.  Please find the below screenshots and kindly guide me.

.

Regards,

Harini