DV visualization wrong data in case snowflake schema
SummaryReport output is wrong when i am running a data from snowflack
Hi all ,
My Db connection is from SQL server database and imported 3 tables .A Factinventry table which is connected to Product dimension table and product dimension is further connected with Product _Subctegory.
Created a DV project in DV and bring all 3 tables and joined in Data Diagram, now i am selecting a measure column from FactInventry.TotalQty and product category from product_subcategory table and it is suppose to show the data sum by product category but it is showing a column black with total sum TotalQty.