Reply To: Showing Inventory while filter for a Sales Rep

 Jeff Peterson
  • Topics Started - 1
  • Replies Written - 8


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.


We're not around right now. But you can send us an email and we'll get back to you, asap.


©2022 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials


Forgot your details?