Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DV visualization wrong data in case snowflake schema

Question
11
Views
0
Comments

Summary

Report output is wrong when i am running a data from snowflack

Content

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.

Can anyone tell me if DV support the snowflake  join or only star join only ?

 

 

 

Version

DV desktop -Version 12.2.5.3.0-20190529084035

Tagged: