Why I can't connect to my BW on HANA system in HANA Studio?

[Martin_Xie]

Hello,

    I am using BWMT to do exercise, I have 8 connections in SAP Logon, when I want to connect to the system "BW on HANA", I found I even can't see it in HANA studio connection selection list, please refer to the attachments for details.

    Is there any one who can help me?

B.R

Martin Xie

[Martin_Xie · Accepted solution]

Hi, folks:

    After one day research, I found the HANA Studio seems to read connection information from NWBC, not from the SAP Logon, so after I delete NWBC from my computer, every thing seems back to the right situation, thank you all.

B.R

Martin Xie

[former_member195433]

Hi

I get the following message

Do we need any specific roles on BW application to be able to login via BW modeling tools in eclipse.

user  is not authorized to access system BWD via ABAP in Eclipse (No authorization to access the resource  /sap/bc/adt/compatibility/graph.)

[Bruhn]

Hi Martin,

It seems as if you are trying to create a BW project which would use the sapgui connection strings. But you are asking about the HANA system for that you will need to make sure that you have the host of the hanadb server and the instance number (if you have access to the DBAcockpit transaction on the BW you can find the hana host by navigating to the configurations folder and select the services) this will reveal both the hana hostname and the SQL port on the indexserver 3xx15 where xx is the instance number you will need)

From hanastudio start by opening the SAP HANA Administration Console perspective (window-open perspective). From this perspective you can add a system (small server like icon with a green plus marker). If you are connecting to a hana system(as opposed to the hana cloud system) you choose the Add System and the screens will guide you thru (as said you will need hostname, instance and user credentials). Check out this one also

Hope this helps.

/MiB

[Martin_Xie]

Hello, Mib:

    Thanks for your quick reply.

    I'm not logon to HANA system,but using BWMT to logon BW system which based on HANA. At the very first step I have to add a BW system using BWMT and I can't find my existing system in SAP logon file, it seems the HANA studio store the information several months ago and didn't update that anymore.

B.R

Martin Xie

[Bruhn]

Sorry about that - so under the BW modelling perspective in Eclipse/hana studio when you create a new BW project you should get a popup which will display either the sapgui entries(use the browse button) or you can select "define manually". Have you tried to define manually and enter the connection properties ?

/MiB

[Martin_Xie]

Hello,Mib:

    Yes I try to input connection parameter manually, but unfortunately no where to input as BW project, while creating ABAP project, I can input manually.

B.R

Martin Xie

[Bruhn]

Strange - have you updated the hana studio - my update is not more that 1 week old it could be that yours is not entirely up to date?

You can update from the help-check for updates menu path.

/MiB

[Prabhith]

Hello ,

We don't have the 'Define manually' option for a new BW project.

We will have to connect it to the one available in the SAP Logon.

Your issue seems to be very strange.

Could you please let me which Eclipse(Kepler/Juno) version you have used.

Or which version of HANA studio you are using.

BR

Prabhith

[Prabhith]

Hello ,

Little crazy to ask you this question:

Can you press CTRL Space in the connection area and see if the BW on HANA system is seen:

BR

Prabhith

[Martin_Xie]

Hello:

    I'm using HANA Studio version 1.00.85.0 , I think it's really strange, my colleagues install the same version, but they can see the connection change according to the SAP Logon.

B.R

Martin Xie

[Martin_Xie]

When you choose CTRL+SPACE, your input tool will be changed, hehe.

[Former Member]

Hi Martin,

To Logon to the BW on HANA, you need to logon to SAP HANA studio and there you can see the SAP logon where the HANA is installed. You can logon to the respective system.

Thanks and Regards,

Mahesh

[Martin_Xie]

Hello, Mahesh:

    Thanks for your quick reply.

    Actually in the very first step I have to add a BW system using BWMT and I can't find my existing system in SAP logon file, it seems the HANA studio store the information several months ago and didn't update that anymore.

B.R

Martin Xie