Embed Object in a Database Column

[Former Member]

Hi there

I have a column in my database that contains freeform text where users can enter a report commentary.

I want to give them a syntax that would allow them to embed a measure universe object

Example of text in field:

The sales for August 2010 are XXXXX. These sales exceed expectations etc etc

The user will change the text from time to time.

I want the user to be able to enter a syntax in place of XXXXX that would use the universe object called 'Monthly Sales Revenue'

Any thoughts?

James

[Former Member · Accepted solution]

I'm not totally sure I understand your requirements, but if what you are trying to do is select a measure based on the contents of 'XXXXX', you could create an object like:

CASE WHEN right(table.freeform_column,3) = 'MSR' THEN fact_table.Monthly_Sales_Rev END