Skip to Content

how to explicitly create a column view

How do I explicitly create a column view ( something like CE1xxxx and CE4xxxx ) .

Please note : I am NOT asking about how to create a view (CREATE VIEW <view_name> [(<column_name>,...) ] AS <subquery>)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on May 01, 2012 at 04:24 PM

    Hi Rajarshi,

    I did not quite understand your requirement. To my knowledge, the column views for the tables are automatically created by HANA.

    What exactly do you need to do. Can you please elaborate the requirement.

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Rajarshi Muhuri

      Like Ravi, I am a little unclear as to your requirement, can you please elaborate and we can assist further?

      You don't import COLUMN VIEWS from ECC, you import TABLES (assuming you are using SLT). After creating some content, ie analytic views, HANA automatically creates the COLUMN VIEW for you.

      I am thinking that you are trying to import HANA models via KEHA and are hitting some errors? If that is the case, then you simply need to ensure the underlying tables (CE1... etc) are replicated, then build your modeling content on top of that.

      Regards,

      Justin

  • Posted on Jan 17, 2014 at 03:21 PM

    Hi Rajarshi,

    you create Column Views with the statement CREATE COLUMN VIEW. You can see the syntax when you display Column Views generated by SAP in the SAP HANA Studio. But it seems, like SAP did not provide the documentation for this, so I personally would hesitate to use undocumentated Statements.

    Regards

    Rainer

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.