Can anyone please tell me if I can create a chart in Bex WAD using 2 DAtaproviders.
I have 2 queries each with 1 keyfigure and one characteristic IO built on the same infocube.
The issue is that I cant show both the keyfigures in the same query as they are calculated key figures with respect to two different calmonth(Logged and Resolved).
So in one query I have logged calmonth and the CKF corresponds to no of logged documents in that month and in the other query i have resolved calmonth and the CKF corresponding to the no of resolved documents that month.
Now i need to show a chart where I can actually compare the logged and resolved documents for a given month.
Any suggestion would be greatly appreciated.
Thanks in advance