Author |
Message |
mubassir1840 Forum Member


Joined: 02 Jun 2013
      Posts: 2 Location: New Jersey

|
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. |
|
Back to top |
|
 |
charlie Forum Associate


Joined: 20 Aug 2002
                 Posts: 903 Location: Woodinville, WA USA

|
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). _________________ Regards,
Chaz |
|
Back to top |
|
 |
mubassir1840 Forum Member


Joined: 02 Jun 2013
      Posts: 2 Location: New Jersey

|
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.  |
|
Back to top |
|
 |
charlie Forum Associate


Joined: 20 Aug 2002
                 Posts: 903 Location: Woodinville, WA USA

|
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. _________________ Regards,
Chaz |
|
Back to top |
|
 |
|