i have been developing a sample universe with few tables.
Joins have been made, cardinalities have been set.
i am also getting table values if i select individual table.
When i am trying to get data from more than one table in dfx &/or blx, i am getting attached error.
When i am using the same join in SQL query browser, i am able to get desired result.
Solutions tried as per SAP note:-
1. Multiple SQL statements for each measure has been checked.
2. Multiple SQL statement for each context has been checked.
Please help me in resolving this issue.