prob in accessing BI system

[Former Member]

Hi

I am using a BI system as backend with VC. Backend is connected to portal properly, but all the services(queries) present in backend are not getting imported to VC( few services are getting displayed, but not all)

Any idea?

With Regards

Abhinav

[Former Member · Accepted solution]

Hi Marcel

I logged in the backend using same user and password(with which user is mapped), there I am able to execute the query. So, i think it is not the problem of access rights.

With Regards

Abhinav

[Former Member · Accepted solution]

Please check the WIKI:

https://wiki.sdn.sap.com/wiki/display/VC/Connectivity

I am 100% sure that you misconfigured or use the wrong authorizations or user.

[Former Member]

hi

Following are the steps i've adopted for connecting the BI system to portal.

Step 1:- System admin -> system conf -> new -> system( from PAR) -> com.sap.portal.systems.bi -> SAP_BI_SAPQuery -> general prop ->

Open the object for editing

Step 2 :- Object -> Connection Properties

Step 3:- Object -> User Management -> Logon Method( UIPW ) && User Mapping Type(admin,user)

Step 4 :- Created System alias

Step 5:- User admi -> identity mgmt -> User Mapping for system access

Step 6: - Connection test( Result:- connection is successful)

Still, all the queries persent in the system are not getting displayed

Any idea where is the error in above steps?

[Former Member]

Hi

Actually, I am using a BI system as the backend. The system is having many queries, but not all the queries are getting imported. Do I need to remote enable the queries, as we do with ABAP system's services?

With Regards

Abhinav

[Former Member]

Hi Abhinav,

you must not remote enable them. Check your user privilleges if you do not get all queries of your system.

Best Regards,

Marceö

[guillaume-hrc]

Hi,

There is no need to "remote-enable" the query because the system runs the query through the function module 'RS_VC_GET_QUERY_VIEW_DATA_FLAT' which is :

o remote-enabled itself

o very interesting when you want to debug the call.

Best regards,

Guillaume

[guillaume-hrc]

Hi,

I had a similar problem.

Queries are available when the remote system is declared as a BI system in the Portal.

Services (RFCs/BAPIs) are available when the remote system is declared as an ABAP system in the Portal.

Thus, for BI systems, I had to declare them twice in the Portal (once as a BI, once as an ABAP).

Best regards,

Guillaume

[Former Member]

Hi Guillaume,

this is a feature not a bug , you have to create always two systems for queries and services.

Best Regards,

Marcel

[guillaume-hrc]

Hi Marcel,

Notice that I am not saying this is a bug!

When I talk about "problem", it is more a lack of information on my side...

But it does imply maintaining some parameters twice.

Best regards,

Guillaume

Message was edited by:

Guillaume Garcia

[Former Member]

Hi Guillaume,

I was joking.

I wrote a blog about VC system for queries and BAPI/RFC/services you will find it here:

<a href="/people/marcel.salein/blog/2007/03/14/how-to-create-a-portal-system-for-using-it-in-visual-composer:///people/marcel.salein/blog/2007/03/14/how-to-create-a-portal-system-for-using-it-in-visual-composer

Best Regards,

Marcel

[guillaume-hrc]

Excellent !

Best regards,

Guillaume

-

---

"Take care, when copying BI systems, to check that you leave only 1 BI Master system" (People copying BI systems)

[Former Member]

Hi Abinav,

do you talk about services or queries or both?

Did you check your rights? Services must remote enabled.

Best Regards,

Marcel