Peroid-To-Date ( or DTS functionality) in ASO

Again I am going to give you all a link with provides you ways to implement one of the functionality which is not an Out of Box functionality of ASO cubes:

Period-To-Date functionality: This is a common requirement for Financial data to have YTD, QTD, MTD values displayed in their financial reports. BSO cubes provide an in-built DTS funtionality which caters to this requirement. However, ASO cube , being the most efficient for Financial Reporting, does not provide this functionality. However the same can be achieved in ASO cube using MDX function - PeriodsToDate.

Here is a link which shows ways to implement the same in ASO cube:
http://garycris.blogspot.com/2008/07/time-functionality.html


Enjoy ASO cube

Currency Conversion in ASO cube

Hi All...

Long time no post :-)... was busy with personal commitments

So I am back and this time am going to give you a link which is a work around to what is considered to be a limitation with ASO cube

Currency Conversion is not supported in ASO cube as we cannot write Calculation rules / scripts in ASO cube. However we can write MDX formulas and with some tweaks in calculation order, we can achieve what is considered to be a limitation.

I found an interesting link on Oracle Forum with Step by Step ways to implement currency conversion in ASO cube and thought of sharing the same with you all


https://community.oracle.com/message/3334237#3334237

Copy Paste upper link in any browser and you could find the process of using ASO cube for currency conversion.

So enjoy sharing... :-)

Essbase BSO Performace guidelines

I am sure we all would have faced optimizing ESSBASE BSO cube a tough task. As you all know there is not technical / rule to optimize BSO cube. I say optimizing Essbase is an art not a science.

However here are some general guideline for optimizing BSO cube.

http://www.intellientblog.co.za/index.php/products/the-dark-art-of-essbase-optimization/#

CLEARDATA ambiguity

This is a very strange observation which I discovered in one of the blogs on CLEARDATA command which challanged my knowledge on BSO CLEARDATA Command. I personally tested it and found that the blogger is correct and so thought of sharing it with you if you all have not visited that blog

CLEARDATA when dealing with purely sparse dimensions…removes blocks

For more details explanation... please refer the blog
http://camerons-blog-for-essbase-hackers.blogspot.com/2011/01/stupid-programming-tricks-6_03.html

Happy posting

Email Alerts Using Essbase Triggers

While working for a client there was a requirement for altering the users/administrators during data load failures in Essbase.

This requirement was met using Essbase Triggers which has a capability of sending emails during data load, calculation and Lock and Send using Spreadsheet add-in. We used this feature of Essbase which came very handy during monitoring of data loads in Batch mode (during nightly refresh)

So, keep exploring Essbase :-)