Sharperlight

Sharperlight allows you access to data across multiple enterprise systems helping to make truly intelligent and timely business decision ahead of your competition. It’s a secure “Out of the Box” solution, featuring personalised dashboards, report packs and a powerful engine and integration framework delivering simplified intelligence. Live, dynamic & refreshable reports.Through Sharperlight’s Bidirectional Writeback system, your data is securely shared between all your enterprise locations, updated and validated in real-time via the intuitive data entry and reporting interface. Excel Addin with secure and direct access to data sources – refresh with current data. Web channel displays tabular html and rendered charts using Kendo UI for beautiful graphical presentation with drilldown. Refresh chart data in real time. Enterprise wide access to sources. Rapid report creation, publication and delivery. Low maintenance. No embedded SQL encourages central Datamodel.Each core feature of Sharperlight is made up of a suite of individual components. They can be used independently to help you shape and refine your information to exactly how you want.Sharperlight can present dynamic tables, charts, pivot tables and presentation reports using its own web service. It has an application called Publisher, for managing and configuring these published queries. Each query can be filtered and refreshed in the web, and it will return the latest data.The web content delivered through Publisher can be graduated with basic HTML4 tables, more complex HTML4 with Javascript automation, all the way to sophisticated HTML5 visualisations.The core charting engine renders the graphics in HTML5.Every published query has a unique web address referencing the query and the output style. This means each query can be uniquely referenced in a webpage, or in an email, or bookmarked in a web browser.For pixel perfect report layouts, Publisher has a WYSIWYG report designer that can output reports to PDF, HTML and Microsoft WordPhilight Pty Ltd is a Western Australian based software development company, delivering products internationally for an extensive range of range of industries and verticals including ERP, EAM, HR, CRM, Sales, Hospitality, Aviation, Professional Services and Mining, through its Sharperlight® suite of products using a localised distribution network.We are squarely focused on empowering your end-users, giving your teams the tools to easily create and maintain their own reporting and analysis content. We’ve made it modular and secure… an “off the shelf” solution that covers multiple industries, verticals and applications. It provides dashboards, reporting, integration and custom solution development that will enhance productivity in any organisation. It is the only suite in its class that delivers comprehensive BI but also offers users the ability to write back to source within the same secure environment over the Web and within Excel®.To accommodate varying needs between enterprises and even internal departments we have developed a broad range of features, simply pick and choose what you need from a common pool of functionality.Sharperlight provides live, out of the box access to a wide variety of popular business systems, including SAP Business One, Microsoft Dynamics ERP and Infor SunSystems. With the development of a Custom Datamodel, an intelligent connector to the application database, it can also extend access to any solution and its data sources, delivering a comprehensive, enterprise wide BI solution.Benefits at a glance:Short timeframe implementation – implementation is quick and effortless, despite the potential complexities of integration with existing business systems.Increased accuracy – more accurate information due to the ability to quickly and easily report from multiple databases.Enhanced decision making – better business decisions are made due to the increased accuracy that is achieved through greater visibility. Users are able to view information that was previously inaccessible by drilling down directly into source data.Time and money savings – the solution runs on top of a moderate sized SQL Server and it is able to return complex data queries searching many files often faster than large scale production servers, such as Oracle.More proactive staff – data is seamlessly uploaded into an organisation’s finance system automatically, so days saved in report writing can be put into more value-add activities, such as quality checking.As the only Sharperlight Gold Partner and Technical Enterprise Solutions Provider we provide a range of Sharperlight services to help organisations leverage the Sharperlight reporting and business intelligence application.Sharperlight dashboards are created and maintained using an HTML5 interface in a web browser. A dashboard consists of a page and each page can contain multiple rectangular tiles. The tiles can be resized and re-positioned, the tile can display published content from Publisher or display any valid web address.Tiles have a default content view and an expanded view that can be displayed by double clicking on the tile title bar.A single dashboard can mashup content from multiple data sources.Every dashboard has a unique URL address and thus, they can be embedded into any browser interface that supports a URL.Tiles can auto align to each other or overlap, each can have different colour scheme and tooltips can be added to the tile title bar.The Sharperlight Excel® Add-in gives end-users easy access to the Query Builder and a drilldown data explorer. The Sharperlight queries are anchored in the worksheets, using formulas and the construction of these formulas is wizard driven through the Query Builder. These formulas fully support cell referencing and automatic recalculation, so results will refresh as filters are changed or when a recalculation is forced.The Microsoft Excel Add-in is compatible with Excel 2007, 2010, 2013 and 2016Cell, Table and Sheet formulas.Filter with cell referencing and automatic lookup windows appear when double clicking referenced cells.Query Manager for managing and re-using seed queries in the same workbook.The Sharperlight formulas are drilldown points which can loaded into Explorer for slice and dice analysis.The Query Builder is a user interface with separate panes for filters, field selection and output. Simple enough for the infrequent user and with deep functionality with menus on each pane title and fields have right hand click menus. In the filter pane the user can select between different query styles using the mode filter and when the user selects the table, it becomes the focus for the query structure and it populates the fields and relationships in the selection pane.The datamodel acts as a presentation layer between the complexity of the data source and presents to the users a unified view of query tables, with available fields and relationships.The Query Builder uses drag and drop to select filters and outputs, most fields can be a filter and/or an output. The query engine will construct the query on the fly and optimise the syntax.The filters can inherit and display lookup lists from the datamodel and there are standard lookup wizards for dates and periods.Query results can be previewed in the Query Builder to assist in query design and Preview grid supports drill for further analysis.The Scheduler is an automation interface for the execution of tasks on a recurring and ad-hoc basis. Each task can have many actions and a task can be executed manually or a schedule. To allow concurrent activity, the Scheduler is only available on installations that have five or more full licenses.Enterprise reporting at a fraction of the cost**. Get detailed and accurate, real-time reports, sent automatically on individually configured schedules for each stakeholder. Works out of the box, with full customisation options and on-demand delivery.Configure reports to run automatically with built in process flow optionsSend emails and notifications, RSS feeds and ExceptionsCreate dynamic schedules and multi burst reports that optionally deliver reports based current calculated valuesSave PDF and Excel® reports to disk**Requires at least 5 User LicencesReport DesignerThe report designer provides more control on the positioning and layout of report pages, and it addresses many of the printing limitations inherit in web browser rendering. It uses a third party component library to provide the reporting engine and a graphical What You See Is What You Get (WYSIWG) designer interface.Uses the Query Builder to construct the data sets and it automatically integrates the query as a report data source.Allows pixel perfect control of field and object placement for reports and business documents.Reports can be accessed through the Sharperlight Web Service and run locally on computers that have the Sharperlight rich client.In the web the reports use the common filter bar to feed parameters back to the underlying reporting engine.The reports can be rendered into PDF and native HTML, it also supports output to Microsoft Excel and Word.Data Capture and Write BackSharperlight has multiple methods of data capture. From within Microsoft Excel, the Sharperlight Add-in can validate and bulk load records using its template driven Writeback interface. There are also Writeback formulas where the Sharperlight formula can be over-written, the input value is interpreted and updated in the data source whilst the cell is reverted back to the formula. In the web Sharperlight can generate web entry forms and entry grids. Typical uses of this feature include creating budgeting templates with built in business rules and validation.All data updates are managed through the secure data model layer where rules and constraints are enforced.Extensive control on lookup and validation lists to ensure that incomplete or erroneous information is caught in the data entry and not during the data load.Data capture uses the Sharperlight Web Service to interface with the target data store and therefore, the data entry does not need a direct connection to the target system.XML output can be created to present to any open API for updating a target business system, for example Infor SunSystems, Microsoft Dynamics, SAGE, etc.Sharperlight ScreenshotContact UsIf you have any questions, information requests or would like to discuss your business requirements in person, please feel free to get in touch or request a callSharperlight allows access to data across multiple enterprise systems helping you to make truly intelligent and timely business decisions ahead of your competition. It’s a secure “Out of the Box” solution, featuring personalised dashboards, report packs and a powerful engine and integration framework delivering simplified business intelligence.A Suite of Components: Dynamic, Interactive Reports and Dashboards
Sharperlight Screenshot
Web ReportingSharperlight can present dynamic tables, charts, pivot tables and presentation reports using its own web service. It has an application called Publisher, for managing and configuring these published queries. Each query can be filtered and refreshed in the web, and it will return the latest data.The web content delivered through Publisher can be graduated with basic HTML4 tables, more complex HTML4 with Javascript automation, all the way to sophisticated HTML5 visualisations.Every published query has a unique web address referencing the query and the output style. This means each query can be uniquely referenced in a webpage, or in an email, orbookmarked in a web browser.For pixel perfect report layouts, Publisher has a WYSIWYG report designer that can outputreports to PDF, HTML and Microsoft Word.
DashboardsSharperlight dashboards are created and maintained using an HTML5 interface in a web browser. A dashboard consists of a page and each page can contain multiple rectangular tiles. The tiles can be resized and re-positioned, the tile can display published content from Publisher or display any valid web address.Tiles have a default content view and an expanded view that can be displayed by double clicking on the tile title bar.
A single dashboard can mashup content from multiple data sources.
Every dashboard has a unique URL address and thus, they can be embedded into any browser interface that supports a URL.Tiles can auto align to each other or overlap, each can have different colour scheme and tooltips can be added to the tile title bar.
Excel ReportingThe Sharperlight Excel® Add-in gives end-users easy access to the Query Builder and a drilldown data explorer. The Sharperlight queries are anchored in the worksheets, using formulas and the construction of these formulas is wizard driven through the Query Builder. These formulas fully support cell referencing and automatic recalculation, so results will refresh as filters are changed or when a recalculation is forced.The Microsoft Excel Add-in is compatible with Excel 2007, 2010, 2013 and 2016
Cell, Table and Sheet formulas.Filter with cell referencing and automatic lookup windows appear when double clicking referenced cells.Query Manager for managing and re-using seed queries in the same workbook.The Sharperlight formulas are drilldown points which can loaded into Explorer for slice and dice analysis.Sharperlight ScreenshotQuery BuilderThe Query Builder is a user interface with separate panes for filters, field selection and output. Simple enough for the infrequent user and with deep functionality with menus on each pane title and fields have right hand click menus. In the filter pane the user can select between different query styles using the mode filter and when the user selects the table, it becomes the focus for the query structure and it populates the fields and relationships in the selection pane.The datamodel acts as a presentation layer between the complexity of the data source and presents to the users a unified view of query tables, with available fields and relationships.The Query Builder uses drag and drop to select filters and outputs, most fields can be a filter and/or an output. The query engine will construct the query on the fly and optimise the syntax.The filters can inherit and display lookup lists from the datamodel and there are standard lookup wizards for dates and periods.
Query results can be previewed in the Query Builder to assist in query design and Preview grid supports drill for further analysis.