January 20, 2015 at 12:15 pm
#190
NICE!
Oooh wow.. That’s a sneaky way of utilizing MDX in Viewer. 🙂
That question has commonly come up. I want to see how much inventory is on hand next to the customer’s open order quantity measure, but On hand inventory has *NOTHING* to do with customer.
I hope this comes up again!
I know that Planner is old school, but people have often asked, “Can I embed SQL in a calculation?”
ie: SELECT qtyOnHand FROM mySchema.myInventoryFile WHERE partNo = <dim1value>..
Intesresting concept, except users could really beat up the system.