Flaherty: Can data be collected and deposited into the repository through the mobile BI interface?
Igoe: That’s an interesting question, and I am not sure the intent, but it actually turns out that part of our roadmap for the next release is to include data entry and collection forms as part of the viewsheet dashboard development cycle. So essentially you can create not only an analytic application like a dashboard to slice and dice but also a data collection application where you can enter some information via a form.
It’s not just parameter filtering but actually be written back to the database. Obviously this is really our first foray into being more than just read-only, and so I envision that we probably will include support for mobile devices since we can go continue to develop the HTML side, as we develop the Flash side.
Flaherty: And then how does the software work in conjunction with a data warehouse?
Igoe: We connect to a data warehouse again through JDBC or if you already have some cubes built then we connect through XMLA using MDX as the core language.
|#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index
So you can use the data that’s in your data warehouse alongside and even mix and match it with other data sources whether they would be databases, Web services, flat files, or manually entered data. That’s the beauty of the data mashup.
Flaherty: Can you connect to SAP?
Igoe: Yes, so actually we a have a special connector for SAP. SAP does use a database in the back end but it's rather cryptic and so we have created a special connector that actually uses the BAPI, Business API, so it uses the business objects names for creating queries against the SAP database backend.
Flaherty: What are the alert options?
Flaherty: All right. Does the software do geographic mapping?
Igoe: Yes, we do. So within the charting component you can switch to the map chart type and then specify your columns in the data to either be geographic fields which are going to be mapped to names like states, or countries or cities, or even zip codes. Or you can also use latitude and longitude directly on the x and y axis. We provide a handful of maps out of the box, but it's also extensible via a very easily extensible interface. So you can take your own ArcView GIS Shape Files, SHP files, you can upload them to our free service that we provide on the community website and convert those including simplification of the shapes into a CSV for use within our product and that includes mapping the correct names of features for may be a custom region or custom country what have you and then easily those within our product.
Flaherty: Can I prevent a user from changing a dashboard?
Igoe: So essentially the chart modification feature is enabled or disabled by the developer. There is a checkbox for ad-hoc enabled from the chart so you can prevent them from modifying the chart. There is also a “write” permission on every asset and so if they do make a change, you can prevent them from overwriting the existing dashboard. They would be able to save their own copy as long as they have permission to write to another folder as if, for example, they could modify the standard dashboard for their own use and save it into the My Reports or User Viewsheet Repository.
Flaherty: Okay, and it looks like we have run out of time. So I want to thank everyone for joining today, and we will be sending out an email next week with a link to the recording of the file so you can share it with your colleagues or watch it later. So thanks everyone and have a nice day.