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

R20 Direct Database Query decommision

Received Response
35
Views
2
Comments
edited Mar 2, 2020 10:05AM in Reporting & Analytics for Sales 2 comments

Summary

Create Data model

Content

We have a Deal Registration analytics done via Data model due to the Submitted Date field SUBMITTED_DATE is formatted as DATE only. While we need the timestamp SUBMITTED_DATE_TIME (TIMESTAMP) as this is a metric that is being monitored for our sales team. 

Table: MKL_DM_DEALS

When using the OTB Deal registration analytics, Submitted date can be formatted to include time but always display the 00:00 time. With the banner notice, does it mean we can no longer continue to do a data model and do a query?

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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