Created a universe as per user requirement where 4 master tables and 16 dimension tables with multiple joins. In this again between master tables as well joins are applied. Contexts are also used to avoid loop issue. However, while adding the dimensions from the 2 master tables (which has joins based on Account ID) and 1 dimension table (which has joins based on Identify ID and Account ID) into the query or BI Launch Pad or view values in business layer I am getting other dimension tables which I didn't selected from the classes into the query which is the reason the data is showing as null. When I comment the other tables in SQL code which is not required I am getting the data. Can someone suggest on this scenario?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.