[IDT 4.x] Plain Text in an object

mubassir1840 · Posted: Thu May 30, 2019 11:14 am Post subject: Plain Text in an object

Hello All,
I am trying to create an object with just plain text in the Business layer. Is there a way to do that? For Ex: Displaying Terms and Conditions in Invoice reports sent out to customers.
I know its more straightforward to do that in Webi but, the reason I wanted to create in IDT is that I have multiple reports(more than 40) which will be using this object and it will be easier to maintain the object in future by editing in one place rather than changing in multiple reports.

Thank you all for your time and effort.

charlie · Posted: Thu May 30, 2019 12:48 pm Post subject: Re: Plain Text in an object

Welcome to B

B!

You just create a new dimension, enclose your text in single quotes (for SQL Server), and associate a Table (which one doesn't matter, it's just to prevent the Invalid expression error).

mubassir1840 · Posted: Thu May 30, 2019 1:35 pm Post subject: Re: Plain Text in an object

Thank You, Charlie. For the warm welcome and your reply.

I included the expression as you said in single quotes and associated a table with the expression, but it is still throwing me an error as "Invalid Expression."
The text is rather large, about 2487 words. So, I tried another expression with only 5 words, and, the expression was validated fine.
Do you think its because of the 2478 words?

Thanks again for your time.

charlie · Posted: Thu May 30, 2019 1:41 pm Post subject: Re: Plain Text in an object

Could be. You can always split the text into a few dimensions in the universe, bring them into the report and manipulate them there.