I have a standard cube which is in Periods. The users want it in weeks, which is fine, but the pricing for a valuation routine is stored in a period cube maintained by the user.
I've put the weeks into the same dimension but have added an attribute to them that indicates which period they belong too, for Pricing purposes.
In my valuation routine I have Cases as my source view, and my new value as
nvalue=value*CellGetN(
'NFF Pricing',customer,product,yyear,ATTRS('NFF Period', week, 'Period'))
;
where customer/product/yyear/week are defined as elements on the variables tab.
It comes up with the error
Line 1: Invalid key: ""
which vanishes when I change week to 'w_1'
Can I not use ATTRS this way?
Hope someone can point out what stupid mistake I am making this time
