Hi all!
I’ve installed SAP Integration Kit 3.0
My question is: what should I additionally configure in order to start creating universe? I looked through the documentation but didn’t find an exact answer. The only chapter that seems to concern is Transport files.
Thanks in advance.
AlexKey (BOB member since 2006-08-18)
It is all written in the manuals:
Andreas 
(BOB member since 2002-06-20)
I’ve uploaded Transport files on BW server but don’t observe any difference. I am still able to create universe based on InfoCube and MultiCube but fail while performing the same operation with BW Query (based on ODS). I guess Transports are used for creation and distribution of Crystal reports.
As to SAP GUI it was already installed.
Are there any other settings to set up?
AlexKey (BOB member since 2006-08-18)
What error are you getting?
maverick976 
(BOB member since 2004-07-06)
Error message:
“Error getting dimensions for cube BRICK/ZBO_BRICK (catalog BRICK): See RFC trace file or SAP system log for more details”
SAP system log shows nothing related to BOXI calls.
AlexKey (BOB member since 2006-08-18)
I have only done this once and it was this week 
, but I have it working using the provided documentation. Make sure you installed the RFC SDK as described and I would also check the sap configuration. If I remember it had some settings for RFC requests as well. Good luck.
maverick976 
(BOB member since 2004-07-06)
What exact settings did you set up for RFC?
Update:
It seems to be the rights issue as I am able to create universe with SAP administrator account. Do you have any idea what additional rights user has to have in order to perform this operation?
AlexKey (BOB member since 2006-08-18)
Just some info:
You can install the SAP GUi, but it’s not really necessary, if you get the librfc32.dll from another SAP Gui installation and you place this in the system32 dir, you’ll be able to install the SAP Integration kit. It will not install if it’s not there.
If your only goal is creating SAP universes against SAP BW and then using Webi to report of them, the transports are not necessary either. We are creating and using SAP BW universes at a client without one BO Transport to BW.
We however do nu use any SAP security. So we have one BO_SAP user that connects to the cubes. It’s not clear to me if you need the transports if you want more security.
I believe the transports are needed to if you are going to use the SAP Java infoview portal integration or any of the other products from the integration kit. With that your SAP users can get into Infoview using their sap username and pw.
Cheers,
Robert Duindam
Our perspective makes you go forward
www.werkenbijoneline.nl
OneLine Business Intelligence - www.oneline.nl
Andersteinweg 2 - 3953 BA - Maarsbergen, The Netherlands
Duindam (BOB member since 2002-09-16)
Alex did you figure out which rights were required for creating the report on a bw query against an ods? I am seeing the same type of error. Thanks. Cubes are fine.
maverick976 (BOB member since 2004-07-06)
Not yet. We’re now focusing on other issues related to BW and I have to establish a fact that there are quite a lot of them especially if you work with Data Integrator to retrieve data from SAP datasource.
I’ll update this topic as soon as we figure out what’s wrong with the rights.
AlexKey (BOB member since 2006-08-18)
When exactly does this error popup?
Cheers,
Robert
Duindam (BOB member since 2002-09-16)
When I try to refresh a report
maverick976 (BOB member since 2004-07-06)
You’re a bit short on your info:
Did you run this query in XI R2 succesfully or is this your first BO rollout against BW?
If it’s your first? Did you include a measure in your query? BO needs to have a measure to trigger the query to run correctly.
Cheers,
Robert
Duindam (BOB member since 2002-09-16)
This is a new 3.0 only installation. You mention that you need a measure. You need a measure on the bw query? What happens when you don’t? Why is this the case?
Thanks 
maverick976 (BOB member since 2004-07-06)
I believe this a limitation of the Remote Function Call from SAP that BO adresses when querying BW. Without a measure (can be only the row count) BW variables (prompts on BO side) are not invoked and then your query will fale.
I’m not sure this is what happening on your side however. We alse have a 3.0 installation and we do not get this error.
Cheers,
Robert
Duindam (BOB member since 2002-09-16)
I think I have nailed it down. It appears to occur when the bw query has a mandatory filter in it that is not a supported type. Since it is defined as mandatory, but not supported per page 42 in the bw universe guide it just throws the rfc error. BO doesnt know how to handle it. Anyone else see this?
maverick976 (BOB member since 2004-07-06)
Hi! We want to able users to log with SAP users into BO, and give them security access level according to SAP configuration (we don’t plan to use generic SAP users in Designer)
Do we need a transport and RFC ? What else should I need to install if we want full functionality of Webi using BW Universes?
thanks
Javier Kuan
BOXI 30 - Windows
javier.kuan 
(BOB member since 2008-02-29)
We were able to use the row level security without any transports with a universe on top of a bex query. I beleive the transports are tied to connecting directly to the data with Crystal reports.
Also, for my earlier post. we have found that anything that is filtereed should also be in the output of the bex query. This allows alot more functions to come across into the universe. Including resricted key measures, etc.
maverick976 (BOB member since 2004-07-06)
Maverick what version of SAP tools are you using and can you describe the row level security part? We’re looking to do it with ECC 5.0 and BI 3.5.
edurda (BOB member since 2005-09-08)
We are only connecting to SAP BW 7. When you use sso on the universe connection and log in to bo with SAP authentication it seems to restrict as required.
maverick976 (BOB member since 2004-07-06)