This reply has been hidden. This can happen if the message has been hidden by a moderator, or has been reported as abusive.
What i understand as of now is that the values are being extracted using the pseudo mdx query and the output of this query itself returns a number which does not have a decimal part. I could have used the num function over the script to enforce a format but since this is a mdx query , i am not sure how to give a typecast or a formatting function over it.
I am just running the pseudo mdx query. It looks something like this.
[x] (I [y].[$(var1)]:[y].[$(var2)])),
The source has decimals(ie float).
But the output of this query is giving integers.
Can i use some typecast on the mdx query?
will you get the same result in Transaction MDXTEST for your keyfigure, too?
Have you tried to do num format via Load-Piping like
Num(Your_Field,'##.##') as Your_Field_Format;
Maybe there are some more suitable connections to use, too?
Accessing BEx-Query via (new) BEx-Query Connector
Loading Cubes via Extractor connector
Loading DSOs via SQL-Connector
What kind of source do load?