Hi Guys,
iv'e this trouble..
I've a member name stored like number into specific accoun (my product dimension elements are numebr, for example 852149415310) and i need to use this value like a dimensional cross to get a value.
I've written this formula:
"VVQTY"= "VVQTY"->@member(@name(@HspNumtostring ("[None] Country"->"[None] Brand"->"Pred"->"BegBalance")));
where
"VVQTY" -> is an account
"[None] Country"->"[None] Brand"->"Pred"->"BegBalance" is the cross in which is stored my member name as a numeric value (if i look into this cross with smart view I see 852149415310)
At this point, if I undestand correctly, essbase should tranform my formula in something like this:
"VVQTY"= "VVQTY"->"852149415310";
And sholud be able to retreive the value stored into this cross.
Little problem: the result is always#MISSING (BUT in the cross there is a value
I try to explain you with this sample:
The full script is.
FIX ( &Plan_Year
,@RELATIVE("YearTotal",0)
,"PLAN" ,"SBOX" ,"Local_Curr"
,"[None] Channel"
,@REMOVE(@RELATIVE("Country",0),"[None] Country")
,@RELATIVE("Brands",0)
,"857545715100" )
"VVQTY"= "VVQTY"->@member(@name(@HspNumtostring ("[None] Country"->"[None] Brand"->"Pred"->"BegBalance")));
ENDFIX
Anybody can help me?