CRM segmentation on virtual provider created on calculation view
Hi to all,
We want to create segmentation attributes on BW models. In our company we have BW on Hana and a billions records of sales data.
We need to get bpartner's filtered by middle order and order date. Fields to use are order number, revenue, order date and bpartner. Mid ord = rev / ord.count
I'm using virtual provider on calculation view to get result. If i put order date to output fields i'm getting wrong result, because at first mid.order is calculated and at second is agregated.
partner ord.date ord.count revenue mid order
12312312 01.02.2015 2 3000 1500
12312312 02.02.2015 4 2000 500
if i will filter order by ord.date = [01.02.2015 to 02.02.2015] i'll get wrong result = 2000.
I think that i need to filter data by order date and not to use it in output fields. The only way i found to do it is to use 2 parameters. Date from and date to. I assigned parameters to different fields in virtual provider. For users is not comfortable to input order data filter values to different fields. Is there any way to filter data with one field?