Here is the Requirement.
I have two sources coming from excel spreadsheet (Dimension) and Oracle database(Fact).
excel spreadsheet has two sheet one has capability information and another sheet has facility group,
oracle has two views OAR_DLVRY_FCLTY_ALCTN_V;OAR_SHPR_ALCTN_V.
i have a Matrix table data coming from both spreadsheet and view( OAR_DLVRY_FCLTY_ALCTN_V) relationship is many to many
but there is this logic based on Facility group.(Grouping Should be done with Delivery facility code and Remote facility)i thought i can merge two spreed sheet into one and create custom column but my numbers doesn’t look correct. and this Facility Group should be used in my Matrix table containing data from both excel and View.
shows double the volume. so i guess it should be done by other means or using dax.
if[Facility Code] =“CHICAPPL” and [Remote facility] = “CHICAPPL” then “CHICAPPL”
if[Facility Code] =“CHICAPPL” or [Remote facility] = “PDVMWLT” then “PDVMWLT”
and this applies to only for this one “Chicap” and other should remain same.
and remote facility use is only for this condition only for chicap and it shouldn’t not impact other. but when i try to merge between two spreadsheets(capability / facility group) in order to get remote facility
my numbers are not right showing double the volume.
if i create dax calculated column numbers are also not right me something wrong with the relationships…
if[Facility Code] =“CHICAPPL” && [Remote facility] = “CHICAPPL” , “CHICAPPL”
if[Facility Code] =“CHICAPPL” || [Remote facility] = “PDVMWLT” , “PDVMWLT” , " [Facility Code] "
how can we deal with such requirement?