BiLog: BI Acronyms and more
PamDenny 270000BXV7 Visits (4162)
Within the Version 7 product lines, there are numerous ways you can analyze your data using the Business Intelligence tools. Each analysis mechanism has its own set of unique attributes, and can be used in a variety of situations.
As an IBMer immersed daily in a sea of acronyms, I've listed these data options for you here with their identifying acronym - - in order of increasing data analysis capability.
QBE – Query By Example. Often referred to as Data Download, this functionality uses your application’s filter and/or query, you can immediately download your results for additional analysis in Microsoft Excel.
RS – Result Sets. Using an application’s query, enable a set of fields or graphic for display on the Start Center.
AE – Application Exporting. Extends the QBE functionality, by enabling fields from multiple database objects to be exported to a various file formats thru the use of Object Structures.
KPI - Key Performance Indicators. Visual indicators displaying status against predefined targets.
QBR – Query Based Reporting. This is V7's terminology for Ad hoc reporting where users create their own reports on the fly from within the various applications.
ROS – Report Object Structures. Collection of joined database tables, forming the backbone of QBR and metadata packages.
OR – Operational Report. Often referred to as transactional reporting, these are the day to day detail reports users require to complete their business tasks.
SR – Strategic Report. Enable viewing of data in varying perspectives thru the use of complex graphs, in depth calculations or scenarios.
Which option or options are best for your unique business needs? And once you’ve selected that option, how do you maximize its use and enable its interaction with the other tools?
Each of these options is discussed in detail in the Report Upgrade planning guides available at this site
Additionally, stay tuned to these BiLOG (Business intelligence Blogs) entries as we focus on these questions and more.