SAP BO 4.1 Publication - dynamic Recipient

[former_member192995]

Hello,

we build a Report based on an Bex-Query in Crystal ReportsEnterprise and now we want to schedule this report based on an Web-Intelligence (Excel-List) with the parameter Fiscyear and Fiscper. My Problem is, that the system do not accept the values.

I tried to pass it via User Parameter or WebIntelligence!

How can i pass it correctly ?

---User-Parameter-----------------------------------------------------------------------------------------------------------------------------------------------

2014-09-19 13:14:14,120 ERROR [PublishingService:HandlerPool-18] BusinessObjects_PublicationAdminErrorLog_Instance_79043 - [Veröffentlichungs-ID 79043] - Fehler bei Verarbeitung von Dokument "Deckblatt  Group" (ID 79,050): Cannot map BOE profile value to non-string parameter field: {?VAR_FISCPER_SINGLE} (CRS 300010) (FBE60512)

2014-09-19 13:14:14,354 ERROR [PublishingService:HandlerPool-18] BusinessObjects_PublicationAdminErrorLog_Instance_79043 - [Veröffentlichungs-ID 79043] - Auftrag für Zeitsteuerung von Dokument "Deckblatt  Group" (ID: 79,050) ist fehlgeschlagen: Scope batch job processing failed. (CRS 300006)

Dokument 'Deckblatt Group' (ID: 79,050) konnte für folgende Benutzer nicht zeitgesteuert verarbeitet werden:

BWT~800/SHANSEN (ID: 9694)

Diese Benutzer hatten folgende Profilwerte:

{?VAR_FISCPER_SINGLE} Werte:

5

(FBE60502)

[1 Empfänger verarbeitet.]

-----Webi----------------------------------------------------------------------------------------------------------------------------------------------------------------

2014-09-19 08:36:39,904 ERROR [PublishingService:HandlerPool-12] BusinessObjects_PublicationAdminErrorLog_Instance_78635 - [Veröffentlichungs-ID 78635] - Fehler bei Verarbeitung von Dokument "Deckblatt  Group" (ID 78,642): Cannot map BOE profile value to non-string parameter field: {?VAR_FISCYEAR} (CRS 300010) (FBE60512)

2014-09-19 08:36:40,122 ERROR [PublishingService:HandlerPool-12] BusinessObjects_PublicationAdminErrorLog_Instance_78635 - [Veröffentlichungs-ID 78635] - Auftrag für Zeitsteuerung von Dokument "Deckblatt  Group" (ID: 78,642) ist fehlgeschlagen: Scope batch job processing failed. (CRS 300006)

Dokument 'Deckblatt Group' (ID: 78,642) konnte für folgende Benutzer nicht zeitgesteuert verarbeitet werden:

BWT~800/SHANSEN (ID: 9694)

Diese Benutzer hatten folgende Profilwerte:

{?VAR_FISCYEAR} Werte:

2013

(FBE60502)

Thanks a lot ...

Simon

[former_member182521]

Hello Simon,

The Profile Values which you are using should be Strings rather than numeric. Kindly validate.

Thanks

Mani

[former_member192995]

Hi, How can i change or influence to pass the Year "2014" correct? Simon

[former_member182521]

Make sure you are changing it either in Database level or Universe level from numeric to String.

[former_member192995]

Hi. we use a variable in the bex query, so we cannot switch to Text, this is the standard variable for fiscyear infoobject. Is there no standard solution at SAP side?

[Former Member]

Good day,

I have the same problem an unfortunately no solution.

Can somebody please advise.

best regards

Arthur

[former_member192995]

Hi Athur,

we build a new publication an a new publicationlist / parameter.

After that it works.

please try it