on 05-10-2017 7:53 AM
Hi,
I have created a calculation view with data category as "Cube" and Star Join Enabled.
The fact table(Table A) has been projected to Star Join node and then in the star join node it has been joined with CV dimensional view which is created using Table B. Now the table A and Table B has been Left outer Joined using the columns, i.e. ( AA, AB, AC).
Issue:
When i query all the join columns between Table A and TableB
then the data in the output is coming as
When Matching records are there between both tables,then all the column values are fine.
When Matching records are not there, i.e record is there in Table A and not there in Table B and if i query all the join columns between A and B, the B table join column values are also coming same as Table A.
TableA.AA TableA.AB TableA.AC
1 1 1
Table B.AA,TableB.AB,TableB.AC
Null Null Null
Final Output in CV view query is coming as
Select TableA.AA, TableA.AB,TableA.AC,Table B.AA,TableB.AB,TableB.AC
from CV view
TableA.AA TableA.AB TableA.AC Table B.AA TableB.AB TableB.AC
1 1 1 1 1 1
Could some one please let me know why it is coming like this.
And similar left outer join in CV view is not producing the same result.
Thank you,
RP
Hi,
I found two blogs that might help you reproduce the correct steps:
https://blogs.sap.com/2014/02/13/hana-sp07-star-join/
https://blogs.sap.com/2016/11/04/hana-modelling-consolidated-best-practices-for-better-performance/
See if you can apply what is described, or if it is helpful in any way. Regards, Mynyna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.