#Error getting last refresh variable for few users

[Ramesh19]

Hi 

in Webi report we are faccing #error greeting last refreshing variable for Few user's (UK). same report working my side and few users (US). i have checked in  universe side no any level of data security. if remove the ToDate is working (UK user's).  so help on this .

Last refresh date  logic below :

* [TRC Plan] is data provider name only

=ToDate((If LastExecutionDate([TRC Plan])=RelativeDate(LastDayOfMonth(CurrentDate());-1;MonthPeriod )
Or LastExecutionDate([TRC Plan])=RelativeDate(LastDayOfMonth(CurrentDate());0;MonthPeriod )
Then RelativeDate(LastExecutionDate([TRC Plan]);1;DayPeriod )
Else LastExecutionDate([TRC Plan]));"M/d/yy")

inside logic i extract individual 

[MichaelGrackin]

What version of BusinessObjects are you using?

We are testing 4.3, SP4, Patch 13 and are finding the #ERROR message is appearing in places that work fine in 4.3, SP4, Patch 7.  Our fix is to correct the formula.  In our situation, the formula that is working in Patch 7 (it is surprising that it works in Patch 7) because it includes an "In()" context crossing two queries, one object from one query and one object from another query.  The two queries are MERGED but it is odd the developer did this in the formula.  Not sure why Patch 7 worked with this but fixing the formula to use objects from the same query in the "In()" context fixed our issue.

[MichaelGrackin]

Also note, with 4.3, SP4, Patch 13 we have also encountered the #ERROR message in schedule results as Excel but the results appear fine when the document is viewed in BI Launchpad. Very odd.

[bekart]

Hi Ramesh, we have been facing with same issue almost 2 years ago, had a call with SAP and they tried to convict me thats logical and working as expected...

Create the variable similar to mine:

=If GetPreferredViewingLocale() = "pl_PL" 
Then Replace([cost];" ";"")
ElseIf GetPreferredViewingLocale() = "en_US" 
Then Replace(Replace(Replace([cost];" ";"");",";"");".";",")

But in your case you have to force SAP BO to read correct Date Format. Diffrent for en_US and diffrent for en_UK.

Hope that will help! 

[ayman_salem]

Why are you using ToDate() ?
The result is already a date, so there's no need to convert it again.

Instead, use FormatDate to display the output in the desired format (M/d/yy).

...

hope it helps