BusinessObjects Board

Database Error for BIWS connection

other Xcelsius - Crystal Dashboard Design
#1

Hi All,

I am trying to pass the calendar month/year(i.e 08.2013) value to webi from xcelsius using BIWS Connection.

I tested the BIWS Connection in WEBI it’s working fine. I put the Calender month/ Year as filter.

But when i am passing this value through BIWS connection i am getting below error.
Cannot Access External Data.
Query script generation failed. See your BusinessObjects administrator. {0} (WIS 00013) No member found for Caption ‘41517’ in Characteristic ‘Calendar Year/Month’.

Please help me :hb: :hb: :hb:

Thanks in advance
Ramesh

venkatarameshc (BOB member since 2011-06-09)

#2

It looks like the Excel layer may be translating the 08.2013 into a number prior to passing it to BIWS. 41517 is the number for 08/31/2013.

What I would try is forcing the value to remain as text. Maybe try appending a “” value to the end so the formula would be something like =“08.2013” & “”. Simply replace the “08.2013” with whatever cell contains that value.

mtbiknole (BOB member since 2009-01-21)