I have a cube that tracks requests, including open and closing times (along with other info) and am building a dashboard for all metrics.
I need to include a measure for the # of requests Received, Completed and WIP. I have based WIP calculated measure around Completed dimension and can use the same dimension for # Completed, but am unsure how i can represent the # Received in the same
I have tried using linkmember to convert the current member of Completed into Received dimension but this will only return items that are created and received in the same period.
I am experimenting with SCOPE, but think it is a dead end.
Does anyone know if what i am doing is possible with a separate dimension for received and completed? Is this only possible to do if I have another date (ReportDate) that would allow me to tie it together?
Many thanks if you can show me the way....!
View Complete Post