query designing issue

[Former Member]

Hi experts,

I have one issue,

i have MP in which two cubes are combined

i have the material,existing in two cubes.

i have keyfig like qty,amnt etc

the user input is as of date.

say for ex:if user executing current date all the qty and amnt belongs to the material (validity period )has to show in report.(which mean as of date whatever the valid material amt and qty has to show in output. if material validity period closed daya before yesterday it could not be display in output)

could u anyone explain how we can achieve this by designing query?

plz share ur suggestion as its urgency.....

[JasonLax · Accepted solution]

Closing thread.  Query reposted here:

[JasonLax]

This thread is currently in SCN Support, which is the support space for SAP Community Network and not SAP products.  Please move it to an appropriate space where topic experts will see and reply to it: SCN Site Index