Reply To: Showing Inventory while filter for a Sales Rep

#190
 Jeff Peterson
Participant
  • Topics Started - 1
  • Replies Written - 8

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.

CONTACT US

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

Sending

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

Log in with your credentials

or    

Forgot your details?