If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Adding common text items to FM

Started by stobbs11, 27 Apr 2011 01:13:50 PM

Previous topic - Next topic

stobbs11

Hi,

I am trying to figure out the best way to add common text / phrases / sentences into my FM model so that they can be used in Report Studio.  Such common text would be things like prompting instructions (ex. please choose the geographical location, please enter the date range, etc).

Ideally, I would like the user to be able to simply drag these text items into Report Studio from the model rather then having to either manually write out each one per report or having to go through the hassle of using a layout component reference.

I have tried to create a calculation within FM but when I dragged it into Report Studios, it created a Singleton.  Is there another way to avoid all that Query Creation for a simple text?

Just to add more mud to the water, these text fields would have to be multi-lingual so that a French user would see the frenchy version of it.  In other words, the potential solution would have to incorporate the Language Variable funtionality in Cognos (I have set up the lanuage component in FM as well).

Anything anyone could provide would be VERY helpful.
Thanks

blom0344

Generating these In the model implies that they are added to the SQL generated. I would expect that you are more interested in report expressions which only exist as report 'objects'.
The solution may be to create a report template with a reference page that stores these expressions.  The template itself can be added to the GUI (involves 4-5 steps; doable in 30 minutes).
Report writer can then start a new report by choosing the template and copying report expressions while building his/her report.

A report expression CAN be defined as a multilingual expression, though it involves coding upfront..