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... :-)