on 07-24-2013 8:59 PM
Hi,
I see two folders called 'View' and 'Column View' under the Catalog in a schema.
1) I tried creating a column view using SQl and I see the column view under the 'Column View' folder. But I am not able to use this column view anywhere.
2) i tried creating a view by right-clicking on the 'View' folder, but I could only save it as a local .vsql file. What purpose do this serve?
Can someone shed some light here?
Thanks,
Benedict
Hi Benedict,
I would try to answer it as per my understanding:
1) I tried creating a column view using SQl and I see the column view under the 'Column View' folder. But I am not able to use this column view anywhere.
When we create any Analytic View, Calculation View or Attribute View then a column view is created for them in _SYS_BIC schema.
So if you have created a column View then you can use it in reporting - try to open this view using MS Excel.
2) i tried creating a view by right-clicking on the 'View' folder, but I could only save it as a local .vsql file. What purpose do this serve?
This View is your SQL View - a virtual table in which you combine tables and can filter data that you want and then you can perform operations on it.
You can create SQL Script based Calculation Views using SQL Views
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Benedict,
I tried and it doesn't work. I thought like we could use them using CE_JOIN_VIEW statement but it turns out we can use only Column Views in here.
So you can also use your Column Views in SQL Script.
So i would say that SQL VIews are SQL functionality so they still exist here.
As we can create HANA Views for Reporting, similarly we can create these SQL Views and perform analysis using Data Preview - it has no limitations of Attribute or Analytic View like Fact Table, Master Table.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.