-
MDX ClosingPeriod Function
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
-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|