Dear, Sansa! 

Thank you for your great activity!

Would you please consider posting meaningful names for the questions? I mean this one and another your question.

That would be helpful not only for you but for all other Developer Community members too.

For this one, I think "Caché class compilation error" would be much better than "Caché Error"

For another,  "Error while opening the Caché class instance" instead of "Erroe".

I would appreciate that!

And would you please mark the John's answer as accepted?

Thank you in advance!

Evgeny Shvarov, InterSystems Community Manager.

Hi, Alessandro!

Let me simplify the question reducing the results as possible:

For this month MDX query:

SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].&[201101] ON 1 FROM [HOLEFOODS]

I have:

 

 

But I want to see not 11,568.43, but the revenue got in the last day sale of January, like what I have for a day query:

SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[DaySold].&[62122] ON 1 FROM [HOLEFOODS]

 

So I need the last available values for days but in a scope of months. Is it clearer now?

If you ask me why do I need that, it's much more evident with the example of stocks trading.

Consider you have a database of transactions of stocks trading for every day and you want to show in DeepSee the history of the price for some share the months' scale.

You would definitely want to use for the value of the price of the month the price of the last trading day of the month. Makes sense?

How to manage this in DeepSee? So I tried to put it in the scope of HoleFoods.