0 Replies Latest reply on Apr 3, 2012 10:00 AM by Subha-Oracle

    How to extract comma seperated strings from an indicator in BAM


      I have created a dimension indicator called "managers" in the BPM process in Jdev (using This indicator contains the list of managers comma seperated like "jstein,wfaulk".
      I want to use this indicator in BAM by seperating the values like "jstein" and "wfaulk". I am using a 3D Bar chart and in the calculation tab under Insert Expr i find substring function but the syntax of this is as follows:

      Substring("source_string", start_position, substring_length)

      But i want to seperate the indicator based on the comma and not on the position or length.

      Can some one help me out on how to acheive this ?