Question Re: Interactive Reporting: BI system cannot be reached in Technology Q&A

Interactive Reporting: BI system cannot be reached

Former Member — Fri, 20 Jul 2012 09:11:57 GMT

Hi Gurus,

I'm trying to configure Interactive Reporting. I followed the documentation given in the Incident Seup (from transaction solman_setup) and the transaction /n/crmbw/config_wizard is showing only green checks so everything should be fine. However, when I logon to SolMan via the CRM Web UI, I can see the standard reports but if I select one, I got the error message "BI Destintation '' cannot be reached".

So first point, why the system does not find the correct RFC ?

Then I selected one report and force in it the RFC destination pointing to my BI client. And then I still have the same message "BI destination 'SSMCLNT100_T' cannot be reached" even if the connection exist and works fine (in SM59, I successfully made a connection test and login test too).

I'm totally disappointed. I'm working on this issue since 3 days and didn't found any successful solution. I tried to check a trace: nothing. I check the different OSS notes talking about ITSM: nothing, I send a message to SAP 2 days ago; no answer yet.

Does someone have a solution ?

Thanks for your help.

Frédéric.

Re: Interactive Reporting: BI system cannot be reached

Former Member — Fri, 20 Jul 2012 11:13:02 GMT

Hi,

As per my understanding the BI setup is also performed as a part of the solman_setup wizard.

The basic setup wizard queries for the BI system (which could be on the same system/client as the SolMan) and then the activation tasks are performed.

Is the solman_setup wizard finished successfully?

http://wiki.sdn.sap.com/wiki/display/SMSETUP/Home

Regards,

Srikishan

Re: Interactive Reporting: BI system cannot be reached

Former Member — Fri, 20 Jul 2012 12:17:01 GMT

Yes I did. I also redo the setup (to be sure) but still not working. What is very strange is that I created my own Interactive Report and it works. So why those coming with SolMan did not ?

Re: Interactive Reporting: BI system cannot be reached

Former Member — Fri, 20 Jul 2012 14:52:21 GMT

hi,

you sure you had all steps executed in solman_setup and all are green. have you checked the authorisation of the user in BI RFC,whether that has enough Auth at your bi client/System.

check the notes i mentioned here with corresponding user

I just thought in another way,found the below, might be you can get some clue from below

http://scn.sap.com/thread/1425672

Please check.

Thanks.

Jansi

Re: Interactive Reporting: BI system cannot be reached

Former Member — Fri, 20 Jul 2012 18:27:31 GMT

Have you checked this note:

1. Note 1576693 - Source code corrs: Interactive reporting/IT Performance Rep

It addressed several problems of Interactive reporting.

Do you have a seperate system for BI for you are using Solution Manager system as default?

Have you tried updating BI- Cont to the latest version?

Please let us know if any of this helps.

Otherwise we will have to proceed with logs.

Best Regards

Saurabh

Re: Interactive Reporting: BI system cannot be reached

Former Member — Sat, 21 Jul 2012 13:11:26 GMT

For the moment, all users in SolMan (both clients) have full authorizations (sap_all/sap_new). I also already read the thread you mentionned but it doesn't provide any solution. Or at least no solution that work for me 😕

Re: Interactive Reporting: BI system cannot be reached

Former Member — Sat, 21 Jul 2012 13:13:45 GMT

Hi Saurabh,

The note 1576693 has already been implemented on our system but it still does not work. We have 2 clients on the same system. One is dedicated to BI. How can I update the BI content ?

Regards,

Frédéric

Re: Interactive Reporting: BI system cannot be reached

Former Member — Sat, 21 Jul 2012 14:23:43 GMT

Hello Frédéric

Here you can find the BI Content.

SAP Technology Components-->SAP SOLUTION MANAGER-->SAP SOLUTION MANAGER 7.1-->Entry by Component-->BI Content

Please update the BI Content to the latest:

1.SAPK-70603INBICONT

2.SAPK-71003INSTBCO

Please check if this helps.

Best Regards

Saurabh

Fujitsu Consulting India-FCI

Re: Interactive Reporting: BI system cannot be reached

Former Member — Sat, 21 Jul 2012 14:32:14 GMT

Following BI Content are installed on the system:

- SAPK-70604INBICONT

- SAPK-71003INSTBCO

So the problem seams not to come from here 😕

Re: Interactive Reporting: BI system cannot be reached

Former Member — Sun, 22 Jul 2012 09:14:10 GMT

Please check this Note:

Note 1558756 - Solution Manager 7.1 - BI Monitoring: Prerequisites

Best Regards

Saurabh

Fujitsu Consulting India-FCI

Re: Interactive Reporting: BI system cannot be reached

Former Member — Tue, 24 Jul 2012 06:01:40 GMT

Hi,

I followed pre-requisites of the note but the problem is still there 😕

Re: Interactive Reporting: BI system cannot be reached

Former Member — Tue, 31 Jul 2012 01:00:21 GMT

Hi Frédéric, have you found a solution to your problem? We are facing the same issue.

Thanks in advance.

Re: Interactive Reporting: BI system cannot be reached

Former Member — Tue, 31 Jul 2012 06:01:33 GMT

Hi Angel,

unfortunately not for the moment: But I raised a call to SAP. So when I get some news, I will post them here as well.

On the other hand, I'm installing a new SolMan 7.1 SP5 for a customer where I will have also to configure ITSM. It will be a good comparison point.

Regards,

Frederic

Re: Interactive Reporting: BI system cannot be reached

Former Member — Mon, 06 Aug 2012 08:30:36 GMT

Hi Angel,

I found that I had to apply oss note 1069281 and create a "dumy" logica system CRMBWDEST pointing to my BI client to make the error message BI Destination '' not reachable.

But now, I still have the same issue but with a my rfc namely set: BI Destination 'ITSM100ALE' not reachable.

So the feedback is only half good ^_^

Re: Interactive Reporting: BI system cannot be reached

Former Member — Wed, 08 Aug 2012 09:22:07 GMT

So final answer:

If you have the message BI destination '' can not be reach, ensure that you have declared in BD54 a logical system CRMBWDEST and in BD97, assigned a bapi call rfc from solman system to CRMBWDEST.

If you get the message BI destination '<your CRMBWDEST rfc>' can not be reach, check table RSPOR_T_PORTAL. If the table is empty, it means that you are trying to call a report 7.x that requires a BI 7.x and a SAP Portal.

As I don't have any portal installed, it means that I can not use standard reports given by SAP o_O"

The mandatory Portal system to use standard ITSM reports given by SAP is unfortunately not mentionned in the configuration guide otherwise, I wouldn't have spent so much time to find the solution.

Information taken from SAP when looking for help (F1) on field BI Report type in SPRO -> CRM -> CRM Analytics -> Display SAP NetWeaver BW Reports then double click on any of the available reports starting with 0SRQ_

Report types with extension 7.x need a BI 7.0 system that is connected to a properly set-up SAP NetWeaver Portal. For more information, see the BI 7.0 documentation in the SAP Library.

Re: Interactive Reporting: BI system cannot be reached

Former Member — Wed, 08 Aug 2012 17:35:30 GMT

Hi Frédéric, thanks for your help.

Regards!

Re: Interactive Reporting: BI system cannot be reached

Former Member — Thu, 23 Aug 2012 05:02:21 GMT

Hi Frédéric

So for now u cannot use ITSM - interactive reporting with standard reports?

OR did you solved this?

Regards Dan

Re: Interactive Reporting: BI system cannot be reached

Former Member — Thu, 23 Aug 2012 06:33:52 GMT

Hi Daniyar,

If you don't implement a SAP Portal, you cannot use the standard ITSM reports for Incident and Change Management (the ones from pur CRM are working).

We solved the issue by recreating the reports we needed o_O"

Regards,

Frederic.

Re: Interactive Reporting: BI system cannot be reached

Former Member — Thu, 23 Aug 2012 09:04:42 GMT

Hi Frederic,

Yes i don't have it

But i can't create own reports... can you help me.

Tcode /n/crmbw/config_wizard is showing all green with only 3 yellow messages. Zero red.

But when im putting direct link into Bus. Role i can't see it in web ui...but i can see Dashboards and Reports - work center.

Created thread for that http://scn.sap.com/thread/3221614

Kinda confused O_o...

Regards Dan

Re: Interactive Reporting: BI system cannot be reached

Former Member — Thu, 23 Aug 2012 19:26:19 GMT

Actually, once you made the complete configuration (meaning tcode /crmbw/config_wizard show all green), you just have to assign the workcenter REPORT_SCH to the navigation profile specified in your business role.

To add the work center to your navigation bar profile:

SPRO -> Customer Relationship Management -> UI Framework -> Technical Role Definition -> Define Navigation Bar Profile

Select the correct navigation bar profile then in the menu tree, choose Assign Wor centers to navigation bar profile and add a new entry "REPORT_SCH"

A new enty in the menu in the crm web ui should appears named "Manage Reports" on the screen you have a search box to find all reports and manage them (create, edit or delete).

Regards,

Frederic.