What is the exact recommendation for set up a BI client in solman system?

[Unicorn_LM]

Hello expert,

I want to use Interactive Reporting function in a solman7.1 system.

For the titled topic, I found the following 2 notes which give me a different suggestion.

1) NOTE 1487626 - Where is best to set up BW for the Solution Manager

    -> In this note, it recommends to set up BI client as same as the solman client.

2) NOTE 1146395 - Configuring CRM Interactive Reporting

    -> In this note, it says "SAP does not recommend to use CRM and OLTP Reporting in the same client".

BTW, I'm following the Interactive Reporting config guide and try to set up the BI client in the same client as the Solution Manager.

But when I run the check configuration wizard via T-cd: /crmbw/config_wizard, it give me a warning message which says "Using CRM and BW reporting in same client not recommended". (attached file is the check result screen shot.)

So, does anyone can give me a precise answer for what is the exact recommendation in solman case?

Kind regards,

Li

[roland_hennessy · Accepted solution]

Hi Li,

"You can run Interactive reporting using a
a) BW in the Productive Solution manager client.
b) BW in a separate client in the SAP Solution Manager system.

BW can run in the same productive solution manager client or in a
separate client in the solman system.
As you are running the BI reporting in the same client please pay
attention to this recommendations, where XXX is the solman-BI client:
3.1.3 Create RFC destination called SMVCLNTXXX_SMV_T  trusted
3.1.8 In SMOFPAPSFA enter this RFC destination
3.1.9 Create user ALEREMOTESMV as indicated
3.1.10 Create RFC called SMVCLNTXXX_SMV_ALE using user ALEREMOTESMV
3.1.11 Create user ALEREMOTEBI and enter it in rscusta
3.1.12 Create RFC SMVCLNTXXX_BI with user ALEREMOTEBI
3.1.18 Create RFC SMVCLNTXXX_BI_T enter this RFC in 3.1.19 user
ALEREMOTEBI
I mean as this is a solman client and BI client in client XXX you
need to give different names to the RFC and ALEREMOTE user in both
faces, Solman client and BI client.

Please follow this in order to see if this can be configured correctly.

Kind regards,

Roland

[Unicorn_LM · Accepted solution]

Hi Roland,

It's a good answer for me.

I checked the Interactive reporting config guide and there are some unclearly points which related for the RFC creation.

I'll try your suggested steps to set up the BI and Solman in the same client.

Thanks a lot.

Li

[Former Member · Accepted solution]

Roland,

I am having the same issue as Li.  In RSA1, Basis created the BW system as part of SOLMAN_SETUP.  The Interactive Report guide has a step to create a source system in RSA1.  When I try to do this, pointing to a RFC that I created (not the same RFC as Basis used for BW setup--though they both connect to the Solman system and the same client--the error message says the connection is already configured.  It appears to not allow the source system and the BW system to live in the same system/same client.  Do I actually need to create a source system in RSA1 for interactive reporting?

Thank you,

Linda

[Former Member]

Hi Miao,

I feel this is a conflicting scenario. We can always map the BI client of solman to the external client / external BI systems.

So if you are using your Solman/CRM in the client ( lets say 100) .. try to configure BI client in 001 and map the configuration to 001 ...

Then I think it wont give this conflict.

Hope this helps.

Thanks,

Jagadish.

[Unicorn_LM]

Hi Jagadish,

I have the same opinion with you. If I separate the BI client and Solman client, the check result warning problem can be avoid.

But note1487626 give a recommendation to use same client for BI and Solman, that's why I raised this topic.

Anyway, thanks a lot for you.

Li