on 02-19-2015 9:49 PM
Hi all,
I am trying to replace all calculation done at Webi report bring it in to the universe to make it generic and available for any new reports. There are several calculations referencing different tables, for instance two different tables. Table A, Table B
Table A contains forecast1, Table B contains forecast 2 & forecast 2%. There is a calculation Forecast 1 * forecast 2% created at the web query using variables, I would like to create that formula in the universe. I am getting error as incombatile. It does not error out in the webi report calculated at the webi report variables. Why there is a difference? Please advise if there is anything I am missing.
Thanks,
Di
Isn't there any join between those tables ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arijit,
No, there is no join between two transactional tables but commonly join to the Material plant master table. In the report side, each measures located on indivial query and calculated/multiplied both measures in the report using variable. Both queries contains material plant master and it is a merged dimension. Even without dimension, those measures can be calculated in the webi report but error out if that calculated chosen from the universe. Is there anyway I can throw in that calculation in the back end instead to get the same result? I appreciate your help.
Thanks,
Di
User | Count |
---|---|
85 | |
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.