Calculation views are created on database tables, these tables can be CDS artifact creation ones or directly created in the database. So which means it does not have only CDS artifact tables. if the table is in HDI container, you can access it directly, or if the table is in classic database schema or some other HDI container, you will synonyms to access the table while using them in Calculation views.
@@sreekanthsurampally Do you have the steps? So far what I found is that you have to run xs cups, modify the mta.yaml file, etc, etc. Extremely complicated steps to just link to a classic hana schema so that the XSA apps can read the hana table. Is there a better procedure for this?
@@johnnymars9782 accessing classical schema objects has to be with the help of synonym, a custom service and roles as you described in your note. which is explained in HANA academy, th-cam.com/video/8IEWVGxfmME/w-d-xo.html , I don't think, if there is another way for this.
Hi Sreekanth, How about calculation view with time dimension where standard time-related tables like M_TIME_DIMENSION_YEAR, M_TIME_DIMENSION_MONTH, M_TIME_DIMENSION_WEEK, M_TIME_DIMENSION are required? I am using trial Hana XSA Web IDE on GCP and i dont see any SYS_BI schema. Can i actually create the time-related tables myself in Web IDE? If yes, how can i generate time-related data?
SYS_BI is a system schema, that is available in XS classic. So you can access them using synonyms in Web IDE for HANA. It applies to all the other schemas like _SYS_BIC, SYS and standard ECC/BW user schema etc..you can explore more on Synonyms in other videos, Thanks.
Thank you for your reply! i watched the other video and if i understand correctly, i have to first having XS Classic (which i don't) before i can access to them right? is there any chance for me to generate the tables and its data at my own with only web IDE in Hana XSA?
you can generate the time data tables in Web IDE, you can find the option in DB explorer Web IDE, Select the tables and context menu, you will find Generate Time data option,
Excellent Sreekanth, I remember you were in Satyam. Doing a great service. Way to go
Thanks Ravi.
Well explain
Nice left outer join in CDS
Is there a way to create a calculation view from a Hana schema table instead of the CDS artifact?
Calculation views are created on database tables, these tables can be CDS artifact creation ones or directly created in the database. So which means it does not have only CDS artifact tables. if the table is in HDI container, you can access it directly, or if the table is in classic database schema or some other HDI container, you will synonyms to access the table while using them in Calculation views.
@@sreekanthsurampally Do you have the steps? So far what I found is that you have to run xs cups, modify the mta.yaml file, etc, etc. Extremely complicated steps to just link to a classic hana schema so that the XSA apps can read the hana table. Is there a better procedure for this?
@@johnnymars9782 accessing classical schema objects has to be with the help of synonym, a custom service and roles as you described in your note. which is explained in HANA academy, th-cam.com/video/8IEWVGxfmME/w-d-xo.html , I don't think, if there is another way for this.
Hi Sreekanth,
How about calculation view with time dimension where standard time-related tables like M_TIME_DIMENSION_YEAR, M_TIME_DIMENSION_MONTH, M_TIME_DIMENSION_WEEK, M_TIME_DIMENSION are required? I am using trial Hana XSA Web IDE on GCP and i dont see any SYS_BI schema. Can i actually create the time-related tables myself in Web IDE? If yes, how can i generate time-related data?
SYS_BI is a system schema, that is available in XS classic. So you can access them using synonyms in Web IDE for HANA. It applies to all the other schemas like _SYS_BIC, SYS and standard ECC/BW user schema etc..you can explore more on Synonyms in other videos, Thanks.
Thank you for your reply! i watched the other video and if i understand correctly, i have to first having XS Classic (which i don't) before i can access to them right? is there any chance for me to generate the tables and its data at my own with only web IDE in Hana XSA?
you can generate the time data tables in Web IDE, you can find the option in DB explorer Web IDE, Select the tables and context menu, you will find Generate Time data option,
Thank you