Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show amount at current prices

Status
Not open for further replies.

kdemulder

IS-IT--Management
Mar 10, 2004
33
BE
Hey all,

I am making a cube representing the stock historically. We managed to get the amounts in the cubes, only now we have a problem with cost- and salesprices. The thing is the lines in the database have the amount of a certain item in a certain store on stock, AND the line also has the recent prices (cost and sales). The thing that has to happen now is that, if you query a certain month, it has to mutliply the quantity of items on stock with the latest price that was found for that month. If we go deeper, to date level, it has to show the price of that date OR the latest price found for that thing. I have NO idea as to even start at writing the measure in MDX. I was hoping for some help in here =/
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top