Unable to Apply Filter

building reports desktopintelligence
1

I created a new variable to find out the max value for a particular field X In Y.

The formula used is
= If (=Max() In ) Then “1” Else “0”

and the variable type is measure by default which does not change to Dimension.

The problem is that I am unable to apply filter on this new variable I have created and it does not appear in the list of fields available for filter. It would be great if someone could help me out.[/b]

huzaifah (BOB member since 2009-09-15)

2

Use below formula.

= If (=Max() In ) Then

I think this will help you.

Rakesh_K :india: (BOB member since 2007-12-11)

3

I am still getting the same problem, when i go in options>filter and press the add button, the variable I made does not show in the list so I cannot apply filter on it.

huzaifah (BOB member since 2009-09-15)

4

I had a similar problem and between my co-worker and I we discovered a solution. Maybe it will work for you…

See the post: [Deski (XI)] “Filtering on custom variable” and review my problem statement.

Here is a summary of the solution from the string:

"I wish I could take sole credit for this, but I found this solution after Googling the error message “Cannot use aggregates in complex filters”.

You’ve accomplished the first step: 1. Create a variable that returns 0 for all values = 0, or a 1 for all values > 0. Step 2. Apply a ranking on your dimension “Client Name” that picks the Top 1 values based on the variable you created in Step 1. This will work as long as you don’t have any other existing filters in the report (which the ranking would wipe out)."

REB01 :us: (BOB member since 2004-11-29)

5

Thanks, but i don’t know why my Ranking option is disabled. When I first tried it I was able to use it but now for some reason it is disabled. I even tried restarting BO but still doesn’t work, I am sure I made some changes due to which it got disabled but am unable to figure it out.

huzaifah (BOB member since 2009-09-15)

6

And as per the Ranking requirements I want to Rank a Dimension using a Measure but the option is disabled. Maybe I am doing the wrong steps.

huzaifah (BOB member since 2009-09-15)

7

I got it now, I was selecting the whole column including the field name !! My problem isn’t solved yet but at least the ranking option isn’t greyed.

huzaifah (BOB member since 2009-09-15)

8

Moderator Note: Please do not bump your post until at least one business day has passed. You can add more information by editing your previous post. Thanks.

P.S: Welcome to B:bob:B!

Jansi :india: (BOB member since 2008-05-12)