Report Portal

Can your sum be a subtraction? Or can you avoid it altogether

Quite often you'll find yourself writing calculations that need to sum up large sets; in fact, they might be summing up all of the members on a level apart from one or two. In that situation it's worth using the structure of your dimension to your advantage. Take the following query, which sums up the Internet Sales of all customers apart from one and then does a TopCount based on this

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.