Skip to Content

Mutivalue error dimension object

Hi Guys,

I have 2 data sources in my Webi Report (BO 4.1) that are merged on Project ID. I have created detail variables for all the columns in the report besides the Project ID which is the merged object.

The report columns contain the merged Project ID, 2 dimension object from Data Source A, 1 dimension and 1 measure object from Data Source B. The dimension object (Char) from Data Source B can have multiple values, which I why I am getting a "Multivalue Error" for some rows in that column.

Now, when I insert the actual dimension object from Data Source B and not the detail variable, the Mutivalue Error goes away and I get the result in multiple rows for multiple dimensional values . However, doing this only displays rows that have a measure value and not the ones that do not have a measure value (blank).

Could anyone please help me resolve this issue so that I can get multiple dimension values in multiple rows for all measure values?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2014 at 05:13 AM

    hi

    There are few things that you need to consider while displaying the data.

    1 - Can an Account Number be associated to more than one Order Number? If yes, then your solution will not work and that's the reason you are seeing #MULTIVALUE (i.e. Multiple Order Numbers for the same account number)

    2 - Why would you want to create two data providers? Would it not be possible for you to bring in all the 3 objects in the same data provider? The only reason I could think of is that they are not related

    3 - Always make the lower granularity objects common across the data providers. I do not know about the relation between different entities of your database, but I would suggest something like

    Query 1 - Order Number, Account Number

    Query 2 - Order Number, Cost Center

    and merge Order Number...and create detailed object for either Account Number / Cost Center. It all depends on the relation between the tables.

    Hope the above points help you.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 25, 2014 at 10:25 AM

    Hi Jeewan,

    Can you please try to check below property of your block and see if it works.

    Avoid duplicate row aggregation : Yes

    Cheers

    Sahil

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 25, 2014 at 05:40 AM

    Create detail object of Datasource B dimension,with respect merged dimension(Project ID)

    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.