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
  • Joel Webb commented
    28 Feb, 2017 06:29pm

    yes

  • Ahmad Muhammad commented
    28 Feb, 2017 06:11pm

    My vote is yes