I have a requirement where i need to get complaint rate with respect to notification week and equipment week.
I have notification infocube and calday is assigned to notification created on and therefore month,
and in equipment cube calday is assigned to equipment create don and so week.
If i have to build a query to get notification week equipment week and complaint rate how can i acheive this.
I have a multiprovider by combining these 2 and it's taking calweek from notifications, how can i get equipment week.
If i have equipment created on or equipment month available can i able to translate into week in the query, If not what are the options?
Thanks in advance.