EFashion Example Queries

[Former Member]

I am trying the EFashion tutorial at

https://www.experiencesaphana.com/docs/DOC-1138

I am getting an error trying to see the results of the final infocube in Ms-Excel. but seems that I might be having problems in the more basic steps .

I have verified that the data has been succesfully loaded in the tables.

I created the 4 attribute views and the one analytical view .

Attribute view (AT_ARTICLE_LOOKUP) of Table "ARTICLE_LOOKUP" HAS ARTICLE_ID as key attribute , category and family name as attributes.

when I right click on the the context menu of the atttibute view (AT_ARTICLE_LOOKUP) and choose the Data preview, I get this error.

com.sap.db.jdbc.exceptions.JDBCDriverException:SAP DBTech JDBC:[391] (at 69) : invalidated view : efashion/AT_ARTICLE_LOOKUP:line 1

However I have already validated and activated it with no errors . I am using the database user "SYSTEM"

how can I resolve this . I feel if I get this part right , I can get the rest of the stuff higher in the food chain right .

[Former Member · Accepted solution]

Similary , I dont get a "Data Preview" on the analytical view either .

when I try to open the infocube in MS-EXCEL , i get this error

Excel was unable to get the necessary information about this cube. The cube might have been reorganized or changed on the server.
Contact the OLAP cube administrator , and if necessary set up a new data source to connect to the cube.

[Former Member · Accepted solution]

Hi Anna,

A common problem, easily overlooked in the [HANA Security Guide|http://help.sap.com/hana/hana1_imdb_sec_en.pdf] - even for those who read it at all

You have to grant read access to your schema to the technical user SYSREPO. Assuming you loaded the eFashion tables into the SYSTEM user's home schema, execute:

GRANT SELECT ON SCHEMA SYSTEM TO _SYS_REPO WITH GRANT OPTION;

if you're using schema EFASHION_TUTORIAL, it's obviously:

GRANT SELECT ON SCHEMA EFASHION_TUTORIAL TO _SYS_REPO WITH GRANT OPTION;

cheers

--Juergen

[tomas-krojzl · Accepted solution]

Hello Juergen,

A common problem, easily overlooked in the HANA Security Guide
...
GRANT SELECT ON SCHEMA SYSTEM TO SYSREPO WITH GRANT OPTION;

I fail to understand why this "security" feature exists. I never seen case when you created tables and then did not want to use them in reports. Also there are many other privileges that will protect the data.

I believe that it would make everyone's life more easier if this could be granted internally as part of schema creation.

Tomas

[tomas-krojzl · Accepted solution]

Hello Anna,

just to have the picture complete - the error is also described in this SAP note:

Note 1612696 - "Invalidated view" error when using analytical views

Tomas

[Former Member · Accepted solution]

Thanks a lot, I had spend the entire day re doing the attribute and analytical views thinking that I was messing up in some steps .

[Former Member · Accepted solution]

I agree and I have asked on many occasions to either grant the necessary authorizations internally, of at least replace the "invalidated view" message with something that tells a user clearly what to do. No luck so far. I'll follow up on it (again)...

--juergen

[tomas-krojzl · Accepted solution]

Hello Juergen,

I agree and I have asked on many occasions to either grant the necessary authorizations internally, of at least replace the "invalidated view" message with something that tells a user clearly what to do. No luck so far. I'll follow up on it (again)...

Thanks a lot. From my perspective - I consider it rather "known bug" then a useful feature. Worst thing about all this is that this action cannot be done by system admin but must be done by end user (modeller) that is usually so confused from first HANA encounter that it usually ends up taking his user and doing it yourself.

Tomas

[Former Member · Accepted solution]

Very Good.

I have the same issue, and fixed after grant the privileges to SYSREPO .