Xcelsius Dashboard issue

[Former Member]

Hi All,

I am working on Xcelsius dashboard development (BO 4.1 SP2 - Dashboard designer). Data is coming from ECC and data dump will flow to SQL Server>Universe>QAAWS>Xcelsius. Data structure consists of few dimensions for filter, date period (dd/mm/yyyy) and revenue related key figures. However, the major challange I am facing right now is as follows:

1) User wants calendar component or an alternate way to select from and to dates for data selection and if required, QTR selection. However, calendar component is not compatible in mobile preview / mode, so is there any additional component / alternate solution to it? How do I implement the logic tofilter out data based on period / from and to range?

2) The amount of data is approx. 45000 records for a year and user might select two years of data for selection (I will try to restrict this though). Since, I need to show transactional data in addition to other analytical views / charts, so is there a way to optimize this dashboard from performance perspective?

Best Regards,

Sameer

[former_member207052]

Just a thought. Why not use range slider to achieve the same ?

May not be aesthetic, but it is supported on Mobile and the data footprint will be less - so will not burden your dashboard.

Sample available here Dropbox - Date Selection in Dashboards

[Former Member]

Hi, Thanks for the sample demo. Can I do a comparison using these two slider with date field and then filter out data?

[former_member182541]

1. Calender component space consuming, not supported for mobile. So you can use text box/combo box to get the value and then you can pass them into the filter.

2. 45000 records for per year ufffffffffffffff. If that is mandatory there is no other way to save you. Dashboard is meant for higher level of analysis or in aggregated information. Its not meant for detailed reporting. If the customers are not aware of it please educate them otherwise you are the one going to suffer. More over it will not accommodate more than 500 rows of data.

[Former Member]

Hi Suman,

Thanks for your inputs. I will go for combo option for dates and I hope date range logic can be implemented in xcelsius. I have same concerns around the amount of data since they are looking for date range, i.e. each and every transaction will have different dates so cannot avoid this.