Add column STARTDATE with a data type of DATE to the BBDW.DIM_PROSPECTPLAN table

Our organization would like to request that a STARTDATE field with a data type of DATE to the BBDW.DIM_PROSPECTPLAN table in the CRM data warehouse. This will facilitate more accurate reporting and would be a valuable addition to out of box functionality. We made the change, which worked as we wanted, and suggest that the following be added to update the field in the standard BBDW job:

UPDATE BBDW.DIM_PROSPECTPLAN

SET STARTDATE = ( SELECT C.STARTDATE

FROM CRM.DBO.PROSPECTPLAN C

WHERE C.ID = PROSPECTPLANSYSTEMID)

  • Guest
  • Feb 28 2017
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) Florida State University Foundation, Inc.
Reported Version 4.0
  • Attach files
  • Guest commented
    February 28, 2017 18:29

    yes

  • Ahmad Muhammad commented
    February 28, 2017 18:11

    My vote is yes