Platform: Xcelsius 2008 with SP1
Business Objects XIR2
MS Access 2003
MS Excel 2003
I have table with Date, Group, Total Invoice, %Calculations in Access 2003
I need to calcualte
1.Total Invoice for each date for each group ( users select Date from Calendar and need to select Group)
2.Total invoice for last 7 days for each group
3.Total Invoice for the current whole month for each group
4.Total Invoice for the current year for all months for each group
I build a universe in Designer with this single table and made Total Invoice as sum(Total Invoice). I developed 4 Qaaws queries in Business Objects for Daily, Weekly, Monthly, Anually
Date field in database is in ‘m/d/yyyy 12:00:00 AM’ format.
But when showing in Xcelsius dashboard it is showing in a wierd format. I tested the query with Deski which is working fine and date format is fine too.
How to work with dates in Xcelsius model ??
Also I need to have prompt on both Date and Group for each query.
As per the requirement For queries 3 & 4, I created objects in universe with @prompt object in Select box of the object properties
For queries 1 & 2 I created prompts in Qaaws, filters panel
How to incorporate prompt in Qaaws and how to make it work in Xcelsius dashboard ??
I don’t see any topic in this forum regarding prompts. I cannot show all lovs in Excel sheet as my date field has more than 1000 dates
I have tons of issues working with dates in my prompts (my oracle DB and the Excel even have different “0” dates), so now I convert all of my dates to a string when interacting with the universe, i.e. all dates passed into the Universe via prompts are actually strings and all dates returned as part of a query are strings. It takes a few extra minutes, but it works.
I am implementing to select a range of date in Xcelsius
DB:SQL server 2005
Business Objects 3.1
Xcelsius 2008 SP2
When I am passing date from calender it is taking as a character(Example:
39875 instead of 3/3/2009)
My universe object is defined as MM/dd/YYYY format and my xcel destination is in MM/dd/YYYY format…But when I captured using fidler it is passing char…
If using SAP BEx as base and added date as variables in BEx, which will be converted into Prompts in BO Universe, should contain the [Kay].[value] pair stuff. Somthing like this
[OCALMONTH].[20090723]
Make sure you are passing this value.
This solution is also related to format. So if you have any other backend system make sure you are following the respective system’s format.
To cross check the format make a testing Xcelsius file. In which place QaaWS, (You must have prompts) and change the method from “Method” drop down box. In section you will get something Value and index variables. Map them to range in excel and display them o screen using some control (say Label, Spread Sheet, Grid, List Box etc) and see if you are passing the same value as displayed in “Index”
(BOB member since 2007-11-12)
(BOB member since 2009-10-23)
(BOB member since 2009-07-09)