You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

DV visualization wrong data in case snowflake schema

edited Sep 11, 2019 5:22AM in Oracle Analytics


Report 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.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!