SQL screen on eclipse sap bw

[former_member196080]

Hi,

I connecte BW on Hana system with eclispe but below things I dont know how to navigate:-

I want to see sql editor so that I can run some sql on BW cubes.

I want to see analytical privledges but not seeing any.

any help?

Thanks

[FCI · Accepted solution]

You can use the modeler or the developper perspective.

Either way you will need a Hana user (which is different than the BW user you use in the BW perspective).

Regards,

Frederic

[former_member196080]

looks like moment I open Hana development perspective..its the repository and systems folder is all red...may be I need Hana user rather then BW user for that view? I'm using BW system to connect my eclipse...any ideas?

I also dont see catalogues

[FCI]

Yes you will need a Hana user.

[Jan_van_Ansem]

Use HANA Development perspective.

You can open a SQL window by selecting a schema in the catalogue (right click, open SQL console).

Privileges can be seen on users and in roles in the security folder.

[former_member196080]

thanks Frederic , I'm using BW perspective. which one shall I use?

[FCI]

Hi Rubane,

SQL editor and Hana objects (like analytical privileges) are not visible with the BW perspective. Which perspective are you using ?

Regards,

Frederic