Converting Measure to Dimension at report level

[former_member672670]

Hie Guys,

Is there a way to convert a Measure (number) to Dimension (string) at report level in Webi 4.0? Also, would it be the same as converting at the Universe level? Thanks.

[Former Member · Accepted solution]

The more important question is why would you want to?

What are you trying to achieve?

[former_member672670 · Accepted solution]

Because my current report has conditions where I need to insert some "Char" values in the measure column. Also, I do not have access to the Universe.

[Former Member · Accepted solution]

OK, that's fine - use the FormatNumber() function to present your measure as text.

=FormatNumber([Sales Revenue];"#,##0.00")

[Former Member]

HI Jeevan,

What is the Number format which, you want to convert and also what is the format which you would like to see?

as prashant mentioned you can use format number as:

Syntax

string FormatNumber(number;format_string)

Examples

FormatNumber([Revenue];"#,##.00") returns 835,420.00 if [Revenue] is 835,420.

[Former Member]

Hi,

Try

=FormatNumber([MeasureObject];"#.##")

You can also use different Format String ("#,##.00", "#,##.##".... ) whichever fits your requirement

[Former Member]

If you try to change a Number to dimension .

First Of all you will Loose the aggregation capabilities.

So if your requirement is to show summed up values then this can end up into single values.

[former_member221192]

Create variable to change measure as dimension,,but it will give single value,sum it can't calculate