CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Showing a previous value and a new value in a report

edited Nov 8, 2011 7:26AM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered
Hello,

I am trying to create a report that compares Account Addresses in Analytics database to the Real-Time reporting database.  The report needs to show whose addresses changed in the last 24 hrs and includes a before and after listing of the Account's address change. 

In CRM I have created a new field checkbox field that is updated by a workflow whenever an address changes.  I have created a combined report for Account History in the Analytics Database and in Accounts for the Real-Time reporting. 

My method is flawed b/c by the time the Analytics DB notices the checkbox it also notices the address change, so the only info I'm getting is the new address.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center