Multivalue error for detail variable

[former_member672670]

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.

[former_member184594 · Accepted solution]

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.

[former_member672670 · Accepted solution]

I just changed the BM/PE name variable to a dimensions object and I got values from both Universe. Thanks for your input.

[Former Member]

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).