You need to resolve the double counting of transactions issue in the existing reports. What should you do?()
- AApply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.
- BApply a Conditional Split transformation in the Transaction data in the SSIS package.
- CDelete the AccountHolder table in the WoodgroveDW database.
- DApply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.