on 06-23-2014 12:54 PM
Hello everyone,
i have created BO Explorer upon .UNV which is upon BI Query. Now i need to calculate percentage in Explorer i.e (A/B)*100 where i have A and B measure in explorer. I tried to use calculated measure but that dint work. So can anyone tell me how this is possible in explorer.
Regards,
Thank You
Hi Alva,
For calculated formula, due to SBO Explorer's feature, I think the best way is to calculate this in the Front-End
For example A%B = A*100 / B, then you need to have two basic measure: A*100 and B
Create global calculated measure = A*100/B and no need to put two basic measure in to InfoSpace
I am not sure about how the final data format for UNV connection
But for BWA connection or HNA connection for BEx data, its in flattern mode I think which means even you could create this kind of measure like A%B, the result is still wrong
Best regards
Alex yang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nitesh,
Many of us here have mentioned similar concerns with the limited calculations within Explorer. I resolved to build the measure wherein (a/b)*100 as a measure within the data set in the business objects report. In my experience explorer produces best results using summary data from existing reports. This is not optimal but I hope it profides insight.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.