Skip to Content

Multivalue error for detail variable

Hey Guys,

I am getting a MultiValue error in a detail variable column in my report. The name of the variable is "Combined BM/PE Name". Basically, I am creating a combined report from 2 reports/universes. In the "Combined BM/PE Name" (detail variable) column, I am getting values from Universe 1, but the values for Universe 2 are "MULTIVALUE". "BM/PE Name" from Universe 1 was linked to "Resource ID" from Universe 2. Thus, I merged those 2 objects and created a detail variable called "BM/PE Name - RT" (Associated dimension = Resource ID & Formula = Resource Name; both from Universe 2) to get the resulting "BM/PE Name" values for Universe 1.

Now, in the report from Universe 2, "BM/PE Name" is a variable derived from the "BPE Type" object in the same universe. The detail variable formula I created for the "Combined BM/PE Name" includes a IF Then ELSE condition for "BM/PE Name - RT" & "BM/PE Name" (Universe 2 variable). However, I am getting "Multivalue" for values from Universe 2. I've attached the snapshots below. "COSA_RT" is one of the merged dimensions. Hope I can get some help here. Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 06, 2013 at 07:08 AM

    You have more than one value for each line for this object. That's the reason you are getting that. The detail objects have to have 1-to-1 relation with the main dimension object. If you have 1-to-n relationship then you get this message.

    Try creating this variable as a dimension object. The error will be gone and you will have more rows of data.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2013 at 07:07 AM

    First of all....its all confusing. make it sutaible with the example of value in objects.

    #Multivalue error comes when you are trying to put multiple values in one cell.

    Try applying Foreach to whole if then else statement in the formula of "Combined BM/PE Name"object. e.g.

    =(if [object1] then [Object2] else [object3]) foreach ([Object1])

    I guess Foreach is applying to only "BM/PE Name" in else condition. means it is considering each row of [COSA_RT] and putting all values of [BM/PE Name] for that [COSA_RT] in one cell (which might be same values).

    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.