Use relational view or synonym in data foundation?

[Former Member]

Based on my experience with HANA Studio, it appears that it is not possible to use a synonym or a relational view in the data foundation of an attribute or analytic view.  (Attempts to drop either object into the data foundation doesn't do anything.)  Is this correct?  Any workarounds?   For example, I want to create a view such as:

create view product_dim_v as select distinct product_id, department_id from sales_fact_table

and use it in the data foundation of an attribute view.

The view I want to use is actually more complex than this, but the example illustrates what I'm trying to do.

Thanks.

[lbreddemann]

HI William,

yep - spot on.

Modeled views consume column store tables, procedures and other modeled views.

No synonyms, no views, to row store tables.

If you want to create more complex views, you might use calculation views.

- Lars