on 09-18-2012 10:21 AM
Hi
There are multiple values for material code for same material description, In Bex it is showing properly with multiple records but in BO Webi It is showing error as #multivalue & i want to display both values in report so, please help regarding this issue.
Hi Tushar,
I this basis an XML universe or are you on a BICS connection?
For a universe you have to make the dimension key value a dimension object instead of an attribute of the name object (it is generated that way, but that will not work, the only save way is to make the key leading for any attributes).
Making one object an attribute of another actually implies there is only one value of the one for each value of the leading one. Which, as you explained is not the case.
WebI doesn't reserve space for any other values in the internal multicube, hence multivalue.
Hope this helps,
Marianne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tushar,
The detail object should be made a dimension object in its own right by your universe designer, that is not something that you can do within WebI. The way the universe is set up now (with the key as detail) is simply not correct, even though it gets generated that way, it has to be changed.
Please ask your universe designer to change the detailobject with the key into a dimension object that holds the same XML.
Meanwhile you can try this
However you do not want to bump into that same problem all the time, so first see if you can get them to change the universe.
Good luck,
Marianne
Hi Tushar,
Create a new dimension variable in report level (copy the same difinition from detail object) and make use of dimension variable in place of detail object. OR
Create new dimension object (use same definition of detail object) in universe lavel and use dimension object in your report
"Attributes must have a one-to-one relationship with their associated dimension. Each value of a dimension object can have only one associated value of any attribute.
If, due to incorrect universe design, a detail object tries to return multiple values for one dimension value, its cell displays the #MULTIVALUE error message."
Hope it helps you,
Thanks,
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.