Skip to Content
author's profile photo Former Member
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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.