Cannot view/browse HANA views/models

[Former Member]

Hi ALL.

I am trying to create SAP Visual Intelligence (VISI) applications, using SAP HANA as my datasource.

I have already created some Attribute, Analytic & Calculation views within SAP HANA & works fine.

The issue I have is that when I connect to HANA using HANA Online method, I connect successfully, BUT I cannot view or see ANY of my information models that I have created in HANA.

Currently I am using the SYSTEM user to connect & create the VISI application... However I also created a user in HANA and gave it the same roles/priviledges as the SYSTEM user, but I get connection errors (see attached screen-shots).

Has anybody experienced this?

Your help will be appreciated.

Thanks,

Regards,

Thatoyame Lolwane

Email: thatoyame@gmail.com

[Former Member · Accepted solution]

Hello Lolwane,

Have to tried to login in to HANA Studio with this user?

I got the same error message and I was convinced that all my permission settings were okay. 

It turned out that I first had to login to HANA Studio in order to change the users initial password - afterwards everything worked fine for me.

Good luck,

Stiefen

[Former Member · Accepted solution]

Hi Stiefen.

For that I applied SAPNOTE: 1702224 and mentioned I should do the below.

But the problem with the newly created user is that, it wont even connect to the HANA instance.

Solution:

Proceed as follows:

• Use SAP HANA studio and open an SQL editor using a user with the USER ADMIN system privilege (e.g. SYSTEM) to connect to your instance
• Execute the following SQL statement: ALTER USER <technical-user-name> DISABLE PASSWORD LIFETIME

Then I also tried using the SYSTEM user, (ADMIN user), which connects fine, BUT still NO view of my SAP HANA models. See my screen shots.

Regards,

Thatoyame

thatoyame@gmail.com

[Henry_Banks · Accepted solution]

Hi Thato,

Thanks for your efforts with this test. This situation is most unusual - with the correct rights administration we've never had this issue before..

As suggested above, please could you also change the initial HANA password on the first login? (no via VI)  

Secondly, I think we need to do some 'trial and error' with the rights assignments. In the HANA studio’s priviliges tabs, could you try granting multiple rights (a maximum?) under "Analytic privileges", and then remove them individually to see if this has any impact.

You could also try the same for  the other tabs (try granting a many rights as possible, then work backwards) until this situation is resolved.

Thanks & regards,

H

[Henry_Banks · Accepted solution]

Hi,

do you have an update for us?   Your OSS 17969 is pending also.

Has this issue been solved in the last week?

regards,

H

[Henry_Banks · Accepted solution]

Hi,

This article was created:   Note 1823771 - SAP Visual Intelligence - Unable to connect to HANA
due to insufficient rights

Please can you check it and get back to us?

Regards,

H

[Former Member · Accepted solution]

Hi Henry.

The one part of the issue is resolved, in that I no longer get an "Unable to connect to HANA Server Instance", so that part is sorted, using my newly created user (VI_USER).

However, after connecting to HANA from VISI successfully, (see screen-shot) I still don't see any of my HANA views/models.

I have followed all the steps you mentioned and in the VISI User guide too.

Thanks.

Regards,

Thatoyame

[Former Member · Accepted solution]

Hi Henry.

One more thing.... Under the "Analytic Privileges", it is empty... The only privilege I can search is "_SYS_BI_CP_ALL"...

[Henry_Banks · Accepted solution]

As a test,  if you import an Excel into VI, then Export (share) to HANA and publish a view,   can you see this artifact when published from VI ?

Regards,

H

[Henry_Banks · Accepted solution]

As a side note - You mention in your VI support ticket that you have another problem, with Design Studio, which has exactly the same symptom as this issue. This cannot be a coincidence!

[Former Member · Accepted solution]

Hi Henry.

I was able to import an Excel document into VI, then Export (Share) to HANA then publish it to HANA... I was also able to view published Excel in HANA... I see that it actually creates a new Package in HANA, and in my case created an Analytic view...

However once again I cannot see any of my published HANA Views!

As you can see, I still cannot view any of HANA views... I am still baffled by this.

Thanks,

Regards

Thatoyame

[Henry_Banks · Accepted solution]

Hi,

In this latest test, can you confirm that the system 'hana'  is definitely the same as the previous instances 168.89.182.27 / P14 ?   (actually, i'd recommend using the fully qualified domain name, and/or ensure that you have maintained the 'host' file on your client with the various permutations)

Also, previously we were modifying a user called VI_USER . Not the 'SYSTEM' user, nor the 'HANA' user previously referenced. Could you revert back to VI_USER please?

This is bizzare, I've never seen such issues before. This steps is usually really simple! Almost like a cross-domain trust or subnet I/O problem.  You can write, but you can't read..

Again, given that you have the same problem via Design Studio (exact same symptom) - This cannot be a coincidence!  

Regards,

H

[Former Member · Accepted solution]

I using a HANA One instance and am seeing a similar issue. I have created a Calculation View but I am unable to see it in VI. Does VI support HANA calculation views?

I was able to publish a data set from VI to HANA and was able to view the resultant analytic view in VI. So I guess my connectivity and access is ok. Any thoughts?

Gaurav

[Henry_Banks · Accepted solution]

Hi,

Yes, According to the Help Guide, section: "6.5 Working with SAP HANA views" ... With this version of SAP Visual Intelligence you can create charts on data available as:

• Analytic views

• Calculation views

• Attribute views.

Regards,

H

p.s. pls can you open a seperate thread for your discussion

[Former Member · Accepted solution]

HI ALL!!!!!

I have some VERY GOOOOD NEWS!!!!

I have managed to find the solution to the issue at hand!

Seems like we were on a wild goose chase!!!

I came across SAPNote:1775385... And the solution basically had this to say:

Resolution

Execute the following SQL statement as SYSTEM user and restart the indexserver process of SAP HANA Database: update "_SYS_REPO"."SCHEMAVERSION" set db_schema_version = 16 where schema_type = 'bi'

After running the SQL some Cubes may be still missing due to having two tables and overlapping Cube IDs that cannot be migrated from BIMC_CUBES to BIMC_ALL_CUBES table.

Important: It is therefore highly recommended to reactivate again all Models after the workaround.

The above solved my problem and I am now able to view all my SAP HANA models/views!

Worked like a charm!!!!

Thanks for ALL your help guys, much appreciated!!!

Regards,

Thatoyame

[Henry_Banks · Accepted solution]

thanks a million for getting back to us, i'll publish this information (cross reference it) to catch the solution in another VI related note.

Cheers!

H

[Henry_Banks]

Hi,

If you think the problem is related to HANA permissions, then start here: Note 1772714 - SAP Visual Intelligence: How-to setup an APPLICATIONUSER Session Variable for tracing VI errors when working with Online HANA Exploration Views

You might also be interestd in Note 1782007 - SAP Visual Intelligence: How to trace the VI
application using native BO_Trace.ini logs

but for what it's worth, those 2 errors look like a simple login problem (blocking firewall, wrong IP info/ host identifier/port)

Regards,

H

[Former Member]

Hi Henry.

As shown in attached document, I can log onto Online HANA within SAP Visual Intelligence perfectly fine, however I just cannot see the HANA models under the section "Browse HANA views" within SAP Visual Intelligence.

Firewalls have been disabled.

Thanks,

Regards,

Thatoyame

[Henry_Banks]

Hi,

I understand you have opened an OSS ticket, and have recieved feedback from the HANA team about the missing authorizations (SQL Permission Select for Roles _SYS_BI; _SYS_BIC; _SYS_REPO,  and EXECUTE to REPOSITORY_REST) and also about the HANA errors when granting permissions to yourself.

I believe the information you require is section '4.5 Important considerations for using SAP HANA' in the online user guide: http://help.sap.com/businessobject/product_guides/vi01/en/vi1_0_7_user_en.pdf

Please let us know how you proceed.

Regards,

H

[Former Member]

Hi Henry.

I did follow the mentioned guide you recommended, however still no resolution.

See my attached screen-shots, showing you my issue. Also attached, the authorization done.

The funny thing is that when when I use the SYSTEM user is connects fine, however showing no Information Models from SAP HANA.... And when I use the newly created user called HANA, it won't even connect, as shown in the screen-shot. As mentioned, I have matched the roles & privileges of SYSTEM user to HANA user.

Thanks,

Regards,

Thatoyame