IQub Browser is a software application that allows you to
browse data cubes. IQub Browser is a reporting and analysis system. With IQub
Browser you can perform online analysis and create reports.
What is a data cube?
A data cube is a multidimensional data storage unit containing
related items as specified by the cube designer. Data cubes store data as measures
and dimensions to provide an enterprise wide view of your organization. Data
cubes have been likened to relational databases on steroids. Data cubes are
very efficient for corporate reporting, decision support, and OLAP (on-line
analytical process).
Why is IQub Browser considered a Microsoft SQL Server add-on?
Microsoft SQL Server is a world class Database Management
System with cube building capabilities. Microsoft SQL Server is a great system
for data management and an excellent choice for building data storage solutions.
IQub Browser is a highly specialized application to leverage
the power of data cubes built by Microsoft SQL Server. IQub Browser is a very
efficient, easy to use information delivery system and as such makes an excellent
add-on to Microsoft SQL Server.
Do I need Microsoft SQL Server to use IQub Browser?
No, you only require access to a cube file (.cub). You can
use Microsoft SQL Server or other products to build the cube file, but IQub
Browser does not require Microsoft SQL Server.
Do I need a data cube to use IQub Browser?
Yes, IQub Browser is a highly specialized application to leverage
the power of data cubes.
However, the IQub Browser application does include a sample
data cube to allow you see it in action and highlight its capabilities without
your own data cube.
How do I create a data cube to work with IQub Browser?
You can create data cubes using Analysis Services within Microsoft
SQL Server, or Microsoft Excel or any application that creates an OLAP cube
(.cub). Please refer to vendor documentation for details on their cube building
process and cube building wizards. You can search topics such as local cubes,
OLAP cubes, offline cubes, .cub.
As Business Intelligence Specialist we can offer a range of
products and services to suit your needs, visit our web site at thebitzinc.com
or contact us at info@thebitzinc.com.
What do I need to try out IQub Browser?
All you need is a windows environment to run IQub Browser.
The IQub Browser application even includes a sample data cube to allow you see
it in action and highlight its capabilities without your own data cube.
How long will it take to setup?
You will be up and running in minutes. There is no setup or
configuration required. Just install IQub Browser, open a data cube, and your
ready to turn your corporate data into meaningful information.
Why can’t I open my data cubes?
IQub Browser supports OLAP cubes in the (.cub) format. If
your data cube is not in this format it will not open. If your data cube is
in this format see your systems administrator for validation.
I would like to use IQub Browser at a client site or at
home, can I do that?
Yes, IQub Browser is a very portable solution. IQub Browser
can be installed on a laptop or a VPN network and cube files are generally relatively
small in size. You can easily perform analysis and reporting in the office,
at home, or on the road.
Do I need training to us IQub Browser?
No. IQub Browser was designed for ease of use. IQub Browser
uses intuitive access screens to put the right information in the hands of those
that need it from Clerk to CEO. But power was not sacrificed for ease of use.
IQub Browser delivers robust analysis capabilities along with point and click
reporting.
Our company could really use this application but we use
databases, is there any way we can take advantage of this application?
IQub Browser uses data cubes not databases.
However, databases can be processed and transformed into a
data cube. The Bitz Inc. offers a cube building service. For more information
on this and other services we provide please contact us at info@thebitzinc.com.
Can I distribute reports?
Yes, you can publish reports in HTML or Excel format. Published
reports are freely distributable and the recipient does not need IQub Browser
to view them. You can distribute your published reports according to your preference;
via email, FTP, etc.
Can I email reports?
Yes, you can publish reports in HTML or Excel format. Published
reports are freely distributable and the recipient does not need IQub Browser
to view them. Your published reports can be distributed as email attachments.
Can I print reports?
Yes, you can publish reports in HTML or Excel format. Your
published reports can be printed from these environments.
Why can’t I see the Grid Menu?
The 3 views (Grid Menu, Grid View, Chart View) can be individually
open, closed, or sized to suit the user’s needs. The 3 views are separated
with borders that act as slider bars which can be resized by dragging to the
desired location or open and closed by clicking the bar tab in the center of
the slider bar.
If you cannot see the Grid Menu it may be completely closed.
Move the mouse pointer to the left edge of the viewing screen until the mouse
pointer changes to 2 parallel bars with arrow indicators. Hold in the mouse
button and drag to the right and release the mouse at the desired location.
Why can’t I see the Grid View?
The 3 views (Grid Menu, Grid View, Chart View) can be individually
open, closed, or sized to suit the user’s needs. The 3 views are separated
with borders that act as slider bars which can be resized by dragging to the
desired location or open and closed by clicking the bar tab in the center of
the slider bar.
There is a hide/show graph icon on the toolbar, selecting
this should close the Chart View and open up the Grid View.
Alternatively move the mouse pointer to the upper edge of
the viewing screen until the mouse pointer changes to 2 parallel bars with arrow
indicators. Hold in the mouse button and drag to it to a lower position on the
screen and then release the mouse at the desired location.
Why can’t I see the Chart View?
The 3 views (Grid Menu, Grid View, Chart View) can be individually
open, closed, or sized to suit the user’s needs. The 3 views are separated
with borders that act as slider bars which can be resized by dragging to the
desired location or open and closed by clicking the bar tab in the center of
the slider bar.
There is a hide/show graph icon on the toolbar, if selecting
this does not open the Chart View, then the Grid View may be almost completely
closed and not visible. Move the mouse pointer to the lower edge of the viewing
screen until the mouse pointer changes to 2 parallel bars with arrow indicators.
Hold in the mouse button and drag to it to a higher position on the screen and
then release the mouse at the desired location.
Can I change the appearance of IQub Browser?
You can choose a theme setting for IQub Browser. The theme
setting allows you to choose different color and shading schemes for the Grid
View.
Steps
1. From Tools, select Settings
2. From Settings, select the Grid View tab
3. Choose the desired theme from the Current Theme drop-down selection list
4. Click Done
What are the system requirements?
You need a Windows operation system 98/2000/ME/NT/XP and
32 Meg of ram.
How do I secure my cube files?
The data within a data cube can only be accessed with a cube
browser. Part of your security plan should include limiting the access of IQub
Browser to authorized users.
For securing the actual data cubes (.cub), we recommend using
windows security and authentication to limit the access to the data cubes to
authorized users. This can be accomplished by placing the cubes in a local or
network directory protected with windows security. Consult your operating system
documentation for the specific details for your version of windows.
Protecting the IQub Browser Application and the
cube files will ensure only authorized users gain access to your corporate data.
