Trying to pull SmartList (connected to Dimension) Members into ASO Member Formula
Need member name pulled into a member formula from a dimension built smartlist.
I have a SmartList (SmartList name is "ReportedCurrencyRate") that is created from our currency dimension (member names like "at Actual Rates", "at Budget Rates", etc). I have an account dimension member called "Reported Currency Rate" which is connected to this SmartList. I need to pull the member name from that account (Reported Currency Rate) into a ASO member formula.
The member formula tuple without any functions would look like this: ([Loaded Method],[at Budget Rates],[Years].CurrentMember)
Here is what I've created so far using StrToMbr, Concat and NumToStr: ([Loaded Method],(StrToMbr(concat("HSP_ID_",NumToStr(([Reported Currency Rate],[BegBalance],[No Company],[No CC],[No Currency],[No Project],[No Consolidation],[No Method]))))),[Years].CurrentMember)