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 =/
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 =/