Report Portal

Calculating universal percentage in OWC

Recently, I was asked to write a calculation that calculates the ratio to parent on rows that doesn't depend on cube structure and that also works in OWC. The first part I managed to dig somewhere from the past, the second proved to be much more demanding task. Having bypassed several obstacles and spent significant portion of time on this subject, I decided to pass the knowledge in form of a blog article. Here's the calculation:

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.