Skip to Content
author's profile photo Former Member
Former Member

Embed Object in a Database Column

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2010 at 05:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.