Skip to Content

Multivalue issue in webi after conversion from deski

Hi,

I have migrated the deski reports from 3.1 to 4.1 environment and converted it into webi report. While testing I found multivalue error in the report.

The object on which break is applied has 2 values in the adjacent column, hence it is showing multivalue in the break footer.

But, when I checked the deski report, eventhough it is showing 2 values when unfolded, it displays only a single value in the break footer. There is no aggregate functions or any other function applied still it does not show multivalue error in deski.

I dont know much about deski and hence want to understand this behaviour.

Thanks

Deepti Prabhu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 14, 2016 at 10:18 AM

    You need to use LAST([Object]) in the Break footer.I have tested in deski and it's showing the last value of the table in Break footer.

    If you sort your data by Descending in Deski then you will get Australia in the break footer.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 11, 2016 at 01:36 PM

    can you share the deski & webi screenshot..

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Amit,

      below is the screenshot of sample data to describe the issue. In deski, break is applied on the interface object, but there are 3 countries for the same interface.The issue is in the break footer(highlighted in bold) it shows Sweden in deski but after conversion to webi, it shows multivalue error.

      sample.jpg (24.4 kB)
  • Nov 11, 2016 at 02:26 PM

    You need to understand report works a little different in Webi and Deski. In Webi, the object needs to be aggregated. Try aggregating the object in Webi.

    Add comment
    10|10000 characters needed characters exceeded

    • That's how it should be. This is by design behaviour. In this case you need to apply break on the dimension.

  • Nov 14, 2016 at 12:23 PM

    Yes, I have already used last(object) to obtain the required output.

    I just wanted to confirm that in deski does it show the last value of the object by default in such cases instead of multivalue error?

    Is this the default behaviour in deski?

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Amit for the confirmation. As I have not worked much on deski, I wanted to be sure of this behaviour in deski.

      Regards,

      Deepti