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

DV Total Count always calculated in the highest level

Received Response
4
Views
1
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 1 comment

Summary

DV Total Count always calculated in the highest level

Content

Hello,

I am using visual analyzer Version 12.2.1.1.0.

Module Description:

FactA - ColA, ColC

FactB - ColB, ColA

DimA - ColC, ColC_Desc

 

FactA joins FactB on FactA.ColA = FactB.ColA

FactA joins DimA  on FactA.ColC = DimA.ColC

MeasureFactB = count(distinct ColB)

 

I'm using the visual analyzer with the following combination:

ColC_Desc, MeasureFactB

 

The measure (MeasureFactB) presents the total count of ColB in the fact table and not group by ColBDesc.

For Example:

The presented results:

ColC_Desc    MeasureFactB

ABC                    10

DEF                    10

XYZ                    10

 

The expected results:

ColC_Desc    MeasureFactB

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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