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?