#MULTIVALUE Error when formula is applied

[sachin_v_joshi]

We have Business Objects 4.0 version 14.0.4.

I'm using WebI  rich client to create our Sales reports.

In the formula for one of aggreagated measures, I created a key figure formula that is the "Status of ticket priorities".

This key figure is a If/Then/Else, where in some 40-50 measures have been interlinked by applying dependancy.

The problem is that if in BO4, if this report is refreshed, then I'm getting in the report "#MULTIVALUE" error.

While the parallel report in BO6.5 does not give error, it refreshes by giving right data in the main tab.It worked fine.

If I compare the remaining tabs of the report, data is appearing and correct too except for this main tab which happens to be SUMMARIZED tab.

All measures of BO6.5 been compared with their BO4 counterparts.

Appreciate any help in fixing this issue.

Regards~S

[sachin_v_joshi · Accepted solution]

Trick is to Check "Aviod Duplicate row aggregation" . by this you can resolve #MULTIVALUE error

[Former Member]

We had similar issue.

There are formula changes (syntax)  are there between BO versions. I would request you to edit the report in BI4.0. Once it works, you can publish it back to the repository. it will work..

[Former Member]

Seems like you are in BI4.0 SP4.

please check the below SAP note also.

1710837 - BI 4.0: #MULTIVALUE displayed in Web Intelligence documents based on BEx universe, when mi...

[sachin_v_joshi]

Thanks for your quick reply JRK Prasad.

But trust me if I have to check all the formulae in this, it would be double work just for correcting minor issue as there are approx 50 measures variables created which have high level of dependancy as already mentioned.

Is there any better approach as for rest of KPI's this error is not coming ?

[Former Member]

During that time. SAP has given some hot fixes. but they didn't solve the issue for all the reports.

No other way.. Only modifying the report will help you.