Your solution worked perfectly. It is interesting how you approached the problem without using TO's. I would have never taken the angle you did to arrive at the solution. My hat is off to you!
If I may ask, how did you gain such a good knowlege of the functions? I can never seem to get a...
I'm tracking on this very helpful post with the exception of step 2 while creating M2. I don't understand what (Value Desc) under sortby means. I have created the metric without the sortby but wind up getting quarters from 1999 even when I enter quarter ids from 2000 onward. I really appreciate...
Here's the sitch'. User wants to pick a single quarter for a report. Based on the quarter selected the report needs to return the last month of each quarter for the trailing 12 quarters. Simple enough except that the calculations at each quarter end month must be for a trailing 12 months. I have...
I am trying to create an olap metric (template level) that returns a hard-coded value based on the intersecting attribute element of an attribute. i.e. Attribute Gender: if attribute element in row is "M" then metric will display 1, if "F" then display 2. Nothing fancy just...
I am looking for information on the Tuple function in MicroStrategy. I would appreciate it is someone has a reference or experience with this function.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.