I don’t see many posts about Analyzer on here and the documentation is fairly basic IMO, but I ran into a problem today and thought I would pass the solution along.
I use alternate hierarchies, and I could not get any Prophix formula to work with the members. For example, if you have a regular “Product” dimension with a custom property for color and an alternative hierarchy called “ColorFamily”, you can’t just put “Green” for the Product position in GETVALUE. You must enter the member as [Alt Hierarchy][Member], so in this case “[ColorFamily][Green].” Brackets are not me formatting for this post, they are entered into the formula. There is no period between the two items, which as a SQL guy gives me anxiety LOL.
I troubleshot this by creating a data grid on the web, opening in Anylzer, and converting to formulas. I wished I had stumbled upon this earlier. Hope this helps if anyone is having Analyzer issues.