Hi BI Gurus,
I have three fields /BIC/IO_REV /BIC/IO_IO_QUAN /BIC/IO_PRC, and the data is properly displayed in the cube, and in the query.
In Transformation for IO_REV, I want to implement calculation IO_REV = IO_PRC * IO_QUAN using
Result = /BIC/IO_IO_QUAN * /BIC/IO_PRC.
When checking in Routine Transformation for IO_REV, It gives me error /BIC/IO_IO_QUAN is not defined??? That is it is not recognizing BIC/IO_IO_QUAN and /BIC/IO_PRC
Can u kindly provide the fix so that it is workable. In BW3.5 same example used to work without problem.
Thanks