I was helping another consultant with a calc script as they were getting incorrect results. They wanted to do a @sumrange for a particular intersection of data.. They had coded the statement like :
@sumrange(actual,"no product","Final",....
I asked why they didn't use a cross dimensional operator. They referred me to the tech reference:
For those of you who can’t read it, the note says
“Member name cannot be a cross-dimensional member combination.”
Having heard that, I looked for another solution and offered a couple of ideas but I kept thinking about cross dimensional operators. I could swear I had done that before. I asked the consultant to humor me and set the @sumrange to use a cross dim instead of how they had coded it. Amazingly the code validated and ran and actually gave the correct set of numbers.
The moral of the story, the tech reference is not always right. Even when things are in print, question them and experiment. This typo cost the consultant hours trying to figure out why the calc didn't work. Think outside the box and experiment
Posts
