on 06-09-2016 1:43 AM
Hi Guys
I am having a weird issue with my Webi report where the totals for a column are different in Webi but when the same report gets exported to excel, and when I manually try to add up the nos , I get a different figure in excel...
Cant understand whats happening!
any ideas?
I have fixed it.
Just fiddled around with my detailed dimension and added the person_id to the 'associated dimension'.
It all works fine now as expected.
Thanks for all the inputs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guys
I found out what the issue is but do not know how to resolve...
There is a column for email address which is skewing the results...
What happened was I found out there was a particular group which does not show up in the excel export ... The totals from this group reflects in BO but it is not visible in webi report either.
To make it visible, I have to remove a column called email address and when I remove this, that group becomes visible.
The totals in the report comes from universe B but that email column comes from Universe A ..
I tried to make this column as a detail but it still does not make that missing group visible...
Any ideas around this??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How big is the difference? Must be something to do with the display of decimal precision on WebI report if difference is not big.
If difference is huge, pls check if the Sum in WebI report is being performed on the same object which is being displayed in the column.
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.