we are running two BO systems - development and productive. Both systems were BO4.0 SP2 and everything was ok. We imported SP5 to our development system and the "fun" started. Reports which work on producitve with SP2, arent working on development with SP5. We made few modifications and 90% of the reports are working execpt one (but i still hate to modificate almost every report after we apply a new SP). This report is based on BEx query and contains simple formula which goes like this: =[Revenue] where ([Calendar day]=[Last day])
Revenue and calendar day are standard measures and dimensions. "Last day" is a variable =ToDate("31.12.2010";"dd.MM.yyyy")
It gives me #unavailable. On productive system is everything ok.
What is wrong with this formula? Any changes in SP5 ??
regards Martin Zluky