Input and output scale for Measures within transformer

[CognosChas15]

Hi

I am finding the documentation regarding this topic very confusing.  Currently I have a Transformer Model (7.3) that I generated IQDS from Framework Manager 8.2 against Oracle 9.2XXX  and I am getting incorrect results on my measures that have decimal positions.  The one I am working on now has 6 decimal postions, they only want to see two within the studios.  Knowing the measure in question has 6 decimal positions , is that enough information to know what the input and output scale should be, and if so what?   ???

Thanks

Charlie

[almeids]

Charlie,
   I've been using Transformer for over 10 years and still struggle with scale issues.  Our environment is similar though we're running ReportNet, not C8.  The interaction of FM-generated IQDs with Transformer seems almost random sometimes with regard to scaling (in FM's defense, we had these issues with Impromptu as well, though in hindsight it seemed more consistent).
    All I can tell you, based on our current working models, is input scale on the data source columns is always zero and precision is always the same as the database column precision.  We use Format to round everything to whole numbers in PowerPlay - I don't know if it's that or output scale that controls what is seen in C8 studios.  What drives me nuts is that in some cases we have output scale the same as the precision and in some it's zero, even across measures from the same data source in the same model!
   Looking back at what I've just typed I realize this isn't really going to help you...so I'll just leave off with "I feel your pain"...
Steve

[almeids]

   If I look at the query subject in FM for the model I mentioned which has varying output scales for the same source, output scale in Transformer matches the Scale attribute for the fact data item in FM.  In this case the query subject is a homemade SQL union of several sources, I'm not sure how FM came up with its Scale attributes, but equating these attributes across the 2 environments may be what I've been missing when it comes to getting the magnitudes right.

[Cannondale23]

you can try the following in transformer on the datasource side, set all input scale for measures to 6 then in the measure list set output scale to 6 then format measure to two decimal places, if that doesnt do it set input to 0 output to 6 format to 2