How to convert a measure to dimension object?

building reports webintelligence
1

Hi All,

I am in need of your assistance.

I have various measure variables and need to change the measure to a dimension in order to drill it as a filter within the report.

I have tried to simply change the qualification from measure to dimension, but that does work.

Multipe - =If([# Applications]<4;“No”;“Yes”)

I need to be able to change the above variable into a dimension in order for me to filter it in XI

Thanks in advance

Akan

Akande547 (BOB member since 2011-03-10)

2

Hi,

You dont have to make it into a Dimension in order to use in ReportFilters. Just change the formula as

Multipe =If([# Applications]<4;0;1)

Hope that helps or atleast gives you an idea of what to do.

M H Mohammed :us: (BOB member since 2010-06-16)

3

Hi MH,

That doesnt work for me. I need to be able to change the variable to a dimension.

If I am able to change the variable into a dimension, then I could then filter the report to show candidates that have submitted more than 4 applications and exclude the rest.

So if I am able to filter to only show “Yes” or “1” then that would be ideal

Akande547 (BOB member since 2011-03-10)

4

Hi, you can filter on a measure, you have to type the constant rather than select it from a list in the filter editor. i.e. type a Yes or 1

Bread_Board :uk: (BOB member since 2011-07-26)

5

Hi

Did this ever get resolved? I have the same issue where I have created a variable as a Measure;

=If = Previous() Then 1 Else 0

The options to filter and rank are both unselectable so I changed the variable to;

=If = Previous() Then “yes” Else “no”

but once again filtering and ranking are unselectable.

Note: I’m using Deski but the principle is the same

If I change the Qualification from a Measure to a Dimension all the data in the variable column changes to #MULTIVALUE

VChambers (BOB member since 2011-06-20)

6

Since measures are context sensitive you can’t filter on a measure, nor can you turn a measure into a dimension in a report for the very same reason. You have to create your dimensions in the universe

Mick

mikca :australia: (BOB member since 2005-12-16)

7

I was able to filter on my variable (measure) by typing in the constant directly.
It works thanks a bunch :smiley: :smiley: :+1: :+1:

calleT74 :australia: (BOB member since 2007-03-30)