Challenges
- Repoint Spotfire reports for the data source connection update and objects changes
- Handle missing column information
- Handle duplicate reports
- Solution for prompt selection in Business Objects
Solutions
- To repoint Spotfire reports for the new data source connection, instead of creating new DS and objects, existing connection were altered. Dependent objects were manually validated and fixed for issues
- Since DB Migration was also running in parallel, team contributed in identifying the missing objects before getting them in Production DB and communicated to the ETL team
- Identified the reports with similar names /versions/functionalities & source queries. Reported the same to the Business Owner
- SAP BO has a prompt selection when the user runs the report. Instead of providing prompt selection in BO, filters were provided in Spotfire
Tools & Technologies
SAP Business Objectives, Spotfire, Amazon Redshift
Key benefits
- Minimized the rework effort by repointing. Thereby ensuring no deviation in the committed timelines
- Identified missing objects to helped BI team to reduce risk of rework & improved efficiency
- By identifying duplicate reports helped users to standardize the report names and version
- Filter selection in Spotfire enabled the users to get an extensive vision of data and customize better
