9 Replies Latest reply on Feb 6, 2015 7:19 AM by Kris Erickson

    Creating a measure from an OLAP dimension

      I am working with dimensional data in an OLAP cube.  In the cube, several pieces of data have been concatenated into a single text field.  I want to be able to extract a specific part of the field, convert it to an integer data type and use it as a measure.  Is this possible?

       

      The data currently looks like this (in the dimensions area)

      99258 - Washington: Spokane County

       

      I want just the first five characters (actual zip code).  I then want the zip code converted to an integer type and moved to the measures area so I can use it to geocode the data.

       

      Thanks in advance for your help.