Using MDM Web UI for Tracking Changes in MDM with SQL

[former_member207367]

Hi

Does any one have Step to step document on How to Generate MDM Web UI for Tracking Changes with SQL Server.

we are using SAP Netweaver Composition Environemnt 7.1,SAP MDM 7.1and Micorsoft Sql Server 2008.

I found few blogs and documents in SDN, but all of them were not with Composition Environment Version 7.1.

Already i activated Change Tracking in SAP MDM Console and i am able to see the changes to Field values in SQL with Select Queries.

If any one have please forward me.

Thanks in Advance.

Thanks

Sowseel

[Former Member]

Hi

you can Write SQL query to check below is Example to check

SELECT [Id]

,[EntryType]

,[EventTime]

,[EventId]

,[UserPermId]

,[TableId]

,[FieldPermId]

,[RecPermId]

,[AttrPermId]

,[QFieldPermId]

,[LinkId]

,[Rating]

,[UserName]

,[TableName]

,[FieldName]

,[RecordName]

,[Locale]

,[OldValue]

,[NewValue]

,[SizeRest]

,[Rest]

,[ParentTableId]

,[ParentRecId]

FROM [PRRepositoryNAME_Z000].[dbo].[A2i_CM_History]

this query will used in web application where you are implementing change Tracking

Thanks

[former_member207367]

Hi

Thanks for the help.

Deployed MDM Change Tracking Application, and it looks Pretty Good.

Thanks

Sowseel

Edited by: sowseel pasumarthi on Aug 31, 2010 8:27 AM

[Former Member]

Hi,

We are having this doubt about MDM Change Tracker.. Is any possibility to change a value? I mean, I have this price x for today. Tomorrow I change the price for y.

Is the Change Tracker keeping these values x or y?

Or only that there was a price change?

Thanks in advance,

Lígia

[former_member207367]

Change Tracker will hold the change's to the values of a field

Report will be some thing like this

Field New Value Old Value

Price Y X

Regards

Sowseel

[Former Member]

Thanks! It is exactly I was looking for.

Lígia Moreira

[former_member182007]

In addition to above post please follow below URL to get steps to CT configuration web UI

http://help.sap.com/saphelp_nw70/helpdata/en/ea/6213584a3f49119eccd7d739e55d5d/frameset.htm

you will get more idea on change tracker by

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/d0dd1ae0-36e5-2b10-f8b4-e6365e643c0b

Hope this helps.

Deep

[former_member205403]

Hi,

Just in case you missed, please check the Change Tracker Application guide using below link.

This contains step by step guide to set up change tracking....

http://help.sap.com/saphelp_nwmdm71/helpdata/en/49/a42bc834de1b93e10000000a42189b/frameset.htm

Hope this helps.

Best Regards,

Shiv