2 Replies Latest reply on Dec 18, 2013 2:04 PM by AdityaKar

    Rename externally created dimension (FCM) and keep the same ID




      Urgent, need your help !


      I'm facing an issue regarding renaming externally managed dimensions (from FCM).

      Currently if i rename a dimension using third part tool, then FCM create a new entry into my "data/state/autogen_dimension.xml" file

      with a new ID and the previous one is kept. So i'm having data consistency issue.


      How can i update  dimensions and dimension values (externally managed) keeping previous ID please ?

        • 1. Re: Rename externally created dimension (FCM) and keep the same ID
          Michael Peel-Oracle

          FCM and Externally Managed Dimensions are two separate features. 


          If your dimension is being created by FCM and you want to change the name of the dimension itself while keeping the same ID, I think you'd need to go into ./data/state/fcm.dvals.xml[.gz] and ./data/state/fcm.conflicts.xml[.gz] and rename there, as well as change it in your FCM data feed (where you pass in the dimension schema).  If you are actually talking about EMTs, I'm not sure - possibly the same approach.  Certainly just renaming them in the data feed/schema would assign a new ID as the logic would naturally assume this was a new dimension (usually there is a separate display label attribute to support business users changing the label while the name is used as a system ID).





          • 2. Re: Rename externally created dimension (FCM) and keep the same ID

            Adding to what Michael already said.


            • What is the purpose of keeping the Dimension IDs consistent? Are they being used in Business Rules (for triggering or for boost/bury)?
            • How often are the dimensions renamed in the external system?
            • Is there any other unique identifier that can be used as the dimension spec?


            You can have the dimension name, as set in the external system, to be used as the Dimension's display name. However, you should use an attribute (such as intention ID), or a combination of attributes, from the external system as the Dimension spec. As long as this Dimension spec remains consistent, the ID assigned by FCM (PCI) will not change.


            Hope this helps.