Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
DV visualization wrong data in case snowflake schema
Nirbhay singh
Rank 1 - Community Starter
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:
0