Skip to Content
Former Member
Aug 03, 2016 at 08:22 AM

Data modeling with star join encountered issues


Hi experts,

Currently I'm working on data modeling with hana studio under sp11 rev112 environment. I've created several calculation views with sql script (to achieve some convenience compared to graphical based views); Then I try to mix them into a graphical based calculation view with star join, however it seems not allowed with message "View having Star Join not allowed".

From SAP Help modeling guide it points out for views added in star join: "You can only add calculation views with data category types as dimensions or blanks as a data source in star join mode"; for sql script based views it only allows cube or blank, so I set them to blank, still this issue happens. Is it necessary to refactor my sql script based views to graphical based dimension ones or something else wrong? Any suggestions appreciated.