on 08-24-2018 7:10 PM
Hi Techies!
Greetings !!!
scenario:
Recently i was working on with the WEBI reports in 4.1 environment and i came to struck with the #Multi value error. In the report, i have got few rows and columns and and i have created few of the variables to meet the client's requirement.
Issue:
the issue which i a facing is that, in a particular column, i have got the data along with that in few of the cells i am getting the #Multi value error. I have used the variable and tried with context operators to get the resolution like For All, For Each and In respectively. But then also the error remaining.
Apart from that, i have checked with the option of format table , where i enabled the option "avoid duplicate row aggregation" which was previously not been enabled and then the error was resolved. But again after saving the report and refreshing it, it popped out the same error in the same cell.
variables that i tried with :
=sum([ord_amt]) ForAll ([order no])
=sum([ord_amt]) ForEach ([order no])
=sum([ord_amt])
requirement:
any syntax or code to resolve the issue or any changes in the above variables which i have mentioned.
Environment: BO 4.1 Sp 6, Database: My SQL Server
Thank You!
Hi Mark,
Please uncheck on avoid duplicate rows aggregation option and see the data where you see multiple value error earlier and fallow that both rows and you can see where we have 2 same values(in multiple rows) and then Apply this object on your context logic. It will work.
Thanks,
Sai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sai,
Thanks for giving guidance to my posted query. Just would like to let you know that, the solution which you have given to resolve the query was been tried by me initially but it did not worked. i need to resolve it from the dB level level and it further got resolved in the report level as i refreshed the report.
Regards.
Hi Mahboob,
Thank You for showing your concern for my query. Would like to inform you that, the issue got resolved finally.
Regards...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi V Kumar,
You can't just use any context operator just to remove the #Multivalue error, its important to know what you're trying to achieve. Please post snap or sample/dummy data and explain what you're trying to do.
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mahboob,
Greetings !!!
Order value and order amount are measure objects and further they are been wrapped around with sum(). Even their projection is set to Sum in the Universe Level.
Yesterday, i tried with all the possible ways and finally resolved up to 75% of the issue and rest is pending.
would like to put some more light on the issue and that is, i have 4 regions data in a document like UK, USA, France and Germany. Now when in the document properties i enabled the option for extended merge, then 3 region error got resoled automatically but the fourth region still got the error and didn't got resolved. Now i am confused that, why only one region data is still showing error as rest got resolved.
I even tried in the universe level and that was setting the projection to delegated measure or smart measure as previously it was sum. But still no effect it shown on the report level.
Also tried with the IF then ELSE and WHERE clauses but still no effect.
further i would like to add one more thing and that is we have prompt applied in the report in date range. now the thing is that, when while refresh the report for short date range like (2015-2017) (2017-2018) then there is. no multi value error but when i refresh the report with prompt date from (2015-2018) then error exist in all the regions i.e in short for long date range it flashing error and for short date range no error.
even checked with the variables and everything is working fine.
any suggestion from your end apart from the ways i tried as of now or any variable which i can use to resolve the issue.
Regards,
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.