Skip to Content
0
Former Member
Dec 03, 2009 at 10:57 AM

Calendar Day format (Xcelsius dash with LO prompts connected to SAP-BW)

50 Views

Hi guys.

I built a dashboard using Xcelsius 2008 with a few LiveOffice prompts. Some are optional and these don't cause any issues, the only one causing problems is one of the two compulsory ones (the other is related to Calendar Month).

The BW query connected to the universe on which the WebI query have been built has two variable selections: the first on Calendar Month, the second on Calendar Day. I haven't been able to find a way to pass Calendar Day data to the query.

When I launch it from WebIntelligence, I select the value from a "calendar". This is the way it is displayed: "dd/mm/yyyy hh:mm:ss AM". When I select a value from this calendar and I launch the query, results are displayed in the proper way.

I added the query to an Excel file that I've subsequently imported into Xcelsius. As I said before every other prompt works perfectly, the only one not working is the Calendar Day prompt. I tried passing this date in several ways, but I receive the message "Invalid format (LO 26000)".

These ways include:

- dd/mm/yyyy [0CALDAY].[AAAAMMDD]

- dd.mm.yyyy

- dd/mm/yyyy

- yyyymmdd

- ddmmyyyy

Did anyone have ideas on how to pass these data in a proper way to the LO prompt from Xcelsius?

Thanks a lot.