Skip to Content
avatar image
Former Member

SQL screen on eclipse sap bw

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Mar 23, 2017 at 03:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 10:23 AM

    Hi Rubane,

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

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2017 at 02:24 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 22, 2017 at 11:55 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 27, 2017 at 05:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded