Skip to Content

Unable to reuse a calculation view

I successfully created a calculation view with dimension named PRODUCTS and I am trying to reuse it in another calculation of type cube with star join. But when I add the data source as the PRODUCTS calculation view, I am getting an error saying, "view having data category as cube not allowed". Also notice that the columns of the PRODUCTS isn't listed in the Join definition.

cv.png (99.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 21 at 11:27 AM

    In Star Join only DIMENSION type views are allowed (views without measures)

    Your PRODUCT data source is of CUBE type so you need to add it before Star Join node and then in Star Join add multiple views of DIMENSION type.
    Detailed information about Star Join you can find here: https://blogs.sap.com/2014/02/13/hana-sp07-star-join/

    Add comment
    10|10000 characters needed characters exceeded