 Former Member

# EBI #Multivalue problem

Hi all,

I know that the scenario below is a bit long but not so complicated.I am open to your ideas and questions for elaboration.

I am using BI 4.0 SP04 (including FP3) and have a WEBI report based on a BEx query.In the report, I want to show the number of students whose GPA >2 class by class(like sophomores,seniors,junors etc) i.e I will have a variable like succesfull sophomore students,succesful senior students etc.

To determine the class, I did the following:

I have a BW characteristics called record classification and its format is string.It shows the semester of a student but it is cumulative i.e if you are in 7th semester, it has values 1,2,3,...,7.

I created a WEBI variable called semester_to_class whose formula is:

if record classification=1 or record classification=2 then 1 elseif record classification=3 or 4 then 2....... to determine the class of a student( for example 3rd and 4th semester means 2nd year)

Another WEBI variable called class: max(semester_to_class) so that I will know only the max of semester_to_class since if the student is a senior, I will have values like 1 2 3 4 for semester_to_class so I must take its max since it is his 4th year.

To test whether it works properly, I wrote count(student) where class=4 and it shows the number of senior students i.e there is no problem up to here.

I have another BW char called grade.Its format is string.It shows the grade of a student in a semester like 2.54 2.38 etc.When I wrote count(student) where grade>2 it shows the number of successful student, too.

HOWEVER, when I combine those two( grade and class) it shows #MULTIVALUE.

The variable is this : Count(student) where grade>2 and class=4

It shows multivalue although (I think) there is only 1 record per student whose grade is greater than 2 and class is 4.

By the way in the prompt, the user inputs only 1 year and 1 semester so there is only 1 grade per student.

I know that the scneario is a bit long but not too complicated.I am open to your ideas and questions.

Thank you all.

10|10000 characters needed characters exceeded

### Related questions Former Member
Posted on Jul 27, 2012 at 08:41 AM

Hi

Can you provide the screenshot on how you are grouping the objects?

try this,

first filter the students where grade>2 and class=4 and then apply count function

Regards

Sunil

10|10000 characters needed characters exceeded
• Former Member Former Member

Hi,

The problem is solved.I added foreach(student) near where keyword and now it counts correctly.

i.e Count(student) where (grade>2 and class="4" foreach(student))

Thanks