Insight OBIEE - Extract Query String Parameter Values into New Column
Summary:
Hi friends,
I am trying to build a report using Eloqua Insight's "Email Clickthrough Link with Query String Breakdown" and want to
- extract text in the "Clickthrough Query String Value" column - specifically the values in "utm_content="
- and display this value in a new column
I was thinking this would be feasible using the "New Calculated Measure" function & advanced SQL. Has anyone accomplished this before or something similar? Extracting values & displaying in a new column.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):