SuperTABLE FAQ - The five questions posted most recently:

I can't open cubes with SuperTABLE on Windows Vista

Sat, 06 Jun 2009 01:19:34 GMT

SuperTABLE v4.3 is an old version of SuperTABLE and should not be used with Vista.

SuperTABLE v4.6.1 or higher is recommended.

When opening a cube (SRD) file you may see an error such as:

In this case you can try using SuperTABLE in Windows XP compatibility mode.

1:� Close SuperTABLE if you have it open.
2:� Using Windows Explorer, locate the SuperTABLE installation folder - the default being C:\Program Files\STRSuper\TABLE
3:� Locate the file 'Super.exe', right-click the program name, and then click Properties from the pop-up menu.
4:� From the Properties Dialogue, select the Compatibility tab and then select the "Run this program in compatibility mode" check box.
5: Select Windows XP from the list of operating systems presented, and then click OK.
6: Repeat the steps 3 -> 5 for the file 'InstallSRD.exe'.

Can I change the display of decimal places in my table ?

Fri, 05 Jun 2009 05:06:59 GMT

Yes, decimal places can be specified for some or all the columns and rows in a table.

Simply click on the column heading (or row label) for the data you wish to format (not the actual numbers).

Then once it is selected, right-click the label to bring up the floating menu.

From that, select 'Format'�� ...then 'Decimal Places'.

In the Decimal Places dialog box, uncheck the tick next to 'standard'.

Then type in a number for the decimals you wish to display (1-9)

Select the 'Extent of Change' to specify how widely this format applies and press OK.

You may need to drag your column widths wider to allow the extra digits to be fully displayed.

How does an SCS file differ from an SRD file ?

Thu, 04 Jun 2009 04:36:51 GMT

A SuperSTAR Table file (file type '.scs') contains both a definition of the query used to generate the cross-tabulation plus the aggregated results generated when the query was originally run against the SuperSTAR database/cube.

It does not contain a copy or subset of the original micro-data held in the SuperSTAR database/cube.� This only exists within the SRD (cube) file, or the original SuperSTAR database.

You can use SuperTABLE to open the SuperSTAR Table (.scs file) and view the information it contains without having to have access to the original SuperSTAR database/cube. However, if you do happen to have access, you are given the ability to seamlessly reformat the query shown in SuperTABLE and run your new query against the SuperSTAR database/cube to get back fresh results.

If you open a SuperTABLE Table but you do not have access to the original SuperSTAR database/cube then the Field selection window is not displayed and the associated toolbar button that normally launches the Field selection window is greyed out.

When I open a table there is no list of fields ?

Tue, 19 May 2009 02:54:30 GMT

The field list box does not appear when the database that was used to create the table originally is not available.�� You might also notice that the "Cross" menu is greyed out, and the field list box icon on the toolbar is disabled.

If you open an SCS file that another SuperCROSS or SuperTABLE user has provided but don't have access to their database then you can only view the values as last saved.�� There is no means to manipulate the table without access to the database or cube.

Can I see unit records or micro data with SuperTABLE ?

Tue, 19 May 2009 02:48:09 GMT

SuperTABLE is typically used for analysing a summarised subset of data stored in a cube, or for viewing tables and queries created in SuperCROSS.

Even though you have access to the aggregated data and values, there is no way to drill down to the actual unit record level.

If you need to analyse the actual rows of data that contributed to a cell value you would need to have access to the original SuperSTAR database, and a tool such as SuperCROSS or SuperWEB.