MDX ClosingPeriod Function

[pabcig]

Hi everybody, i need to do a question!

I have a mesure call "Total", but in the cube i need to show the total at the end of each period.

Ex:
2005.01.01 $30
2005.01.20 $20
2005.01.30 $10

If i see this information by month i should show:
Jan 10
and not
Jan 60

I know i can do this with de ClosingPeriod.. can anyone give me some example?

Thank´s

[Island1]

Hi, pabcig:

Thanks for posting this to the Database Journal forums, where many can benefit from a central location.


I have published in-depth procedures to accomplish most of what you seem to be seeking to do. Here are some links to review that I think will be helpful:

http://www.databasejournal.com/featu...le.php/2245791

This article deals with the ClosingPeriod() function, and provides hands-on instruction in its use to render data from the closing period perspective. The “partner” article, also dealing with time – based MDX, can be seen at:

http://www.databasejournal.com/featu...le.php/2232111

I recommend doing Parts I & II as a quick, practical overview of the functions before fixing on a direction to take with your business need. Finally,

http://www.databasejournal.com/featu...le.php/2238011

This might be useful in helping you to “pull the concepts together,” when addressing time-related concepts in Analysis Services / MDX, both to meet the present need and to plan prospective solutions.

I hope this helps. Let us know, if not, by posting back to this thread. In addition, consider posting back news of your successes, as well: the result will be a contained, problem-solution set posting here on Database Journal that many others can access and use!

Best,

Bill

[pabcig]

Finally i could resolve the problem in this way:
I created a calculated member like this:
([Measures].[Inicial], ClosingPeriod ( [feccomp].[day], [feccomp].CurrentMember))

Thanks!!!
Paul