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... :-)
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... :-)
The link doesn't work. can you please provide\update the link?
ReplyDeleteThanks,
Hi, This link doesnt work. Can you please share? Thanks in advance. Grasshoper.
ReplyDeleteHello,
DeleteThanks for letting me know. As ASO has evolved a lot since I published this post, there has been lot of approaches to do currency conversion on ASO cubes. Below is a link which I found most interest although I am yet to test and prove it. Once I do that I will update the above post. I would suggest you to try to this approach and let me know if you face any issue
http://camerons-blog-for-essbase-hackers.blogspot.com/2014/11/simplified-currency-conversion-doing.html
OraHyperion
Cool and that i have a tremendous offer: How Many Home Renovation Shows Are There house renovation in london
ReplyDelete