on 12-18-2012 3:22 AM
Hi,
I am trying to load CSV file into SAP HANA.
I created 3 dimension files, Customer, Product and Location and loaded it successfully and can view the data.. but when I try to load a file for fact table with all the numeric figure, it loads successfully and I can see all the fields but dont see any data when try to click on open data preview, the message I am getting is that "No rows retrieved"..
I have already assigned primary keys in all the dimension table (one each) and assigned the 3 keys in the fact table based on my 3 dimension tables.
Can anyone please advise me what could be the reason I am not able to view the data in HANA studio but can see the fields.
Will appreciate your reply, thanks
Regards
Hi Imran,
Execute the below query and check the data:
GRANT SELECT ON SCHEMA SCHEMA-NAME TO "_SYS_REPO" WITH GRANT OPTION;
Regards
Mary
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Imran,
sounds as if you are doing inner joins and that the referencing columns don't match up with the data in the dimension tables, doesn't it?
I propose you check whether this is the cause of your problem by joining the fact table against the dimension tables one after the other in SQL.
If this is not what's causing your empty result set, then my second bet would be that you filter data out.
Either by a explicitly set filter or an analytic privilege.
cheers,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Lars,
Thanks for your reply,
No, I haven't started to build the views as yet, I am just loading data from CSV files and creating tables in my schema such as Customer Product and Location...
I can preview the data in these tables but cant see the data in the fact table when I load the CSV file..
Thanks
Hi Santosh,
There are no error messages at the last step... and the fact table file is not that huge and non of the column has NULL values, I have checked that, i don't see any error message in the HANA studio.. I think it has something to do with some kind of setting in the studio as the other tables for Customer Product and Location is perfectly alright... may be some kind of settings for loading numeric data (not sure as I am not a database person)
Regards
Hi Imran
Until you design the views all the tables are same when you start designing HANA Artifacts there the discrimination starts whether it is a fact table or etc... but as you are in loading stage only, if you are able to load other tables and you should be able to load this table data as well unless there are problems with data types.Can you try INSERT of 5-10 rows from Excel file using SQL Editor and check whether it is able to perform INSERT operation successfully.
Thanks
Santosh Varada
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.