0 Replies Latest reply: Apr 3, 2012 5:00 AM by 928152 RSS

    How to extract comma seperated strings from an indicator in BAM

    928152
      Hi,

      I have created a dimension indicator called "managers" in the BPM process in Jdev (using 11.1.1.6). 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 ?

      Regards,
      Subha