Skip to Content

Simple formula not working in BO4.0 SP5 but works with SP2!?

Hi all,

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 ??

Any ideas?

Thank you,

regards Martin Zluky

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 11, 2013 at 02:01 PM

    Hi all,

    looks like i found the solution. It was a smart measure issue.

    It is explained here:

    Funny thing is that it is a thread started by me 😊

    I created a new measure variable Revenue2=[Revenue] In ([Calendar Day]) and replaced the standard measure "Revenue" in my formula. And it works pretty good.


    Martin Zluky

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2013 at 02:30 PM

    Hi Martin,

    often the SP levels introduce changes in behavior in the calculation engine, that's why before doing an upgrade it is better to do throrough testing, and adjust where necessary, as you are doing,

    As far as this formula is concerned, I suggest to test in Patch 5.2 and if the case open a CSS message providing reproducing steps and database version/middleware



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 11, 2013 at 08:50 AM

    Can you try inserting a single blank cell and try the same formula (=ToDate("31.12.2010";"dd.MM.yyyy")).

    As I know this should work fine.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.