Technical Frequently Asked Questions
The following FAQs provide a start point for any troubleshooting or questions you may have. If you can't find the answer to the question you are looking to solve please email firstname.lastname@example.org
1 What impact is inTuator likely to have on machine performance? Technical FAQs
iServer produces compiled programs to ensure efficient performance of inStore creation.
Programs only require compilation when they are first produced or when they are amended. The authority to compile or job queue for compilation can be controlled for each user by the iServer administrator.
Extracts which allow variable selection criteria to be entered when the report is run do not require re-compilation each time they are used.
|2 What are the configuration prerequisites of inTuator? Technical FAQs|
iServer (server) on the iSeries
inTuator and Valet on the PC
PC hardware requirements (minimum):
PC software requirements (minimum):
PrepP/29T - runs on a Windows NT Server as a service.
Hardware requirements (minimum):
Software requirements (minimum):
|3 What is the difference between DB2/400 and LAN Access inStores and inTuates? Technical FAQs|
|4 What is the difference between inTuates for Office 2000 and Office XP? Technical FAQs|
|The Office Pivot Table component in Office XP has many new features and improvements over the features that were available in the Office 2000 component. The Office XP improvements includes:
|5 LAN access inStores can cause ODBC connect failure if the file is beyond 999. Technical FAQs|
|One potential cause of an ODBC connect failure is that the inStore contains too many levels and totals. The current limit of the length of an inStore record is 999. That is the sum of the lengths of all the levels and totals in the inStore cannot exceed 999. To avoid this limitation multiple inStores can be created and corresponding inTuates can be set up and linked to each other.|
|6 I am getting some errors in Excel. Where can I find out more information? Technical FAQs|
These Microsoft support articles discuss the limits of pivot tables in Excel 2000 and 2002 (XP) - the articles also describe the error messages that would be displayed by Excel.
|7a Excel errors when exporting inTuates with conditional number formatting Technical FAQs|
|The conditional number formats that are available in inTuates are not supported in Excel.|
|7b Number formatting is lost when exporting to Excel Technical FAQs|
|The conditional number formats that are available in inTuates are not supported in Excel.|
|8 What is the number formatting for Pivot Tables? Technical FAQs|
|The regional settings in the Windows Control Panel determine how number, currency, date, and time formats are displayed. For example, these settings determine whether years are displayed with two digits or four digits. See Windows Help for information about these formats. Click here for more details.|
|9 I need "MS Windows NT 4.0 integrated shell". How do I check if I have this? Technical FAQs|
inTuator component checker (Help / Component Checker) will show you the current components installed on your PC.
For more details on how to get the Integrated Shell components, click here
|10 How do you create a calculated field in the table? Technical FAQs|
|This is only available if you are using Office XP Web Components. To create a calculated field click on the Calculated Totals and Fields button on the inTuate table toolbar and select Create Calculated Total from the context menu. In the Commands and Options window enter the required data under each tab.|
|11 How do you add data from other sources? Technical FAQs|
|To add data from other sources you would need to export your inTuate table into Excel using the Export to Microsoft Excel button on the inTuate table toolbar. When in Excel you can add in the required data manually.|
|12 How do you email inTuates to people outside the network? Technical FAQs|
|In order for
inTuates to work the recipient must have inTuator installed and
have access to the inStore. If you email an inTuate to someone outside the
network they would only be able to see the data that is displayed on
screen as an image, they would not be able to work interactively with
Portable Mode has been introduced to overcome these issues, see Currently, I email an inTuate as an attachment, why are Portable Mode packages better?
|13 Can you schedule the inStore restocks to be run at certain times? Technical FAQs|
Yes - your iServer product includes an iSeries command ("RPTRUN") that will
initiate an inStore restock.
The RPTRUN command resides in your iServer Product data library and can be executed (or submitted for BATCH execution) from your own programs, or
Like all iSeries commands, RPTRUN can be prompted (using the F4 function key)
either from the iSeries command line or from within SEU when editing Control
Language (CL) program source.
|14a I've changed the inTuate in the viewer, will it look the same when I re-load it? Technical FAQs|
uses Workspaces to save your local changes, so long as the Workspace is saved
when you exit from an inTuate the latest changes you have made will be
This feature is optional for each inTuate and can be set by clicking on the inTuate Options button on the first window of the inTuate Wizard and under the General tab checking the Save and load workspace for this inTuate box.
|14b How do I refresh/reset my inTuate to ignore changes I have made without having to resort to amending the inTuate? Technical FAQs|
|Hold the Shift key and click on Refresh inTuate in the inTuator toolbar. This will refresh the inTuate with the definition stored in the server.|
|15a What is the limit to the number of records I can have in an inStore? Technical FAQs|
|There is no limit to the number of records, however the processing time and speed of your iSeries and your PC might be a limiting factor.|
|15b What is the limit to the number of levels & totals I can have in an inTuate? Technical FAQs|
|You are limited to 19 levels. There is no limit on the number of totals.|
|16 Can I show more than one inTuate table at a time in the browser window? Technical FAQs|
|No, you can only
display one table at a time, however by linking inTuates you can
quickly move from one inTuate to another by double clicking in the
You can initiate inTuator more than once, viewing different inTuates in each initiation.
|17 Can you translate the inTuate description headings for Page, Column and Row? Technical FAQs|
|18 Can I link inTuates across data from different i-Series applications? Technical FAQs|
|Yes: providing that inSets are designed to use the different applications. Contact your Momentum for more information.|
|19 Do you need Client Access to run inTuator? Technical FAQs|
Access is only required if you access the inStore contents directly
from DB2/400; see inTuate options on first inTuate Wizard
If you access the inStore contents from a LAN location Client Access is not required, however you will have to ensure that the inStore has been set up to copy the contents from the iSeries to the LAN.
|20 When I link inTuates together, do they have to use the same inStore? Technical FAQs|
|No, you can link any inTuates together as long as they have the relevant fields to link with.|
|21 Some of our users are on 2000 and some on XP. Can they run the same inTuates? Technical FAQs|
|Yes they can view the same inTuates so long as they have both the Office XP Web Components and the Office 2000 Web Components installed and licensed.|
|22 If functions such as totals and percentages are in the inTuate design, how will it look in Windows 2000? Technical FAQs|
|If an inTuate is created using the Office XP Web Components it will not be viewable on a PC with only Office 2000 Web Components. The user on trying to open such an inTuate will be presented with a message specifying the requirements for viewing the inTuate.|
|23 How do I print charts, do they have to be printed in Excel? Technical FAQs|
|When creating an inTuate you have the option of including a number of Tool buttons that are displayed as icons above the Table (See Advanced theme Page formatting). One of these Tools is the Print button. This Print function does use Microsoft Excel print features. Alternatively you can use the Snapshot Tool and save the Chart and/or the Table as a file with a gif extension and then insert the file into another document, for example a Word document.|
|24 Can I lock the headings when displaying an inTuate, similar to the Excel function?Technical FAQs|
|The display of the Table is controlled by the Microsoft Web Component hence it not
possible within inTuator to have such a feature as Freeze Pane as in Excel. To minimize the amount of data on display you can -
Alternatively you can export the Table to Excel and use the Freeze Pane feature.
|25 Are there limitations when using Portable Mode? Technical FAQs|
|The primary purpose of Portable mode is to allow users to make use of inTuator functionality on information available on their PC when it is disconnected from the LAN / Server. A few limitations arise from this disconnected state :
|26 Currently, I email an inTuate as an attachment, why are Portable Mode packages better? Technical FAQs|
|The email options provided are primarily targeted at sending information relating to a single, currently displayed, inTuate to one recipient. They are provided to satisfy one-off requirements, regardless of whether the recipient uses inTuator or not.
Portable mode Packaging provides options to include one or more inTuates (including Linked to 'children'), any workspaces involved and/or associated inStores and their contents, data compression of the package contents and the choice of saving the package - perhaps to a CD. In addition, Packaging simplifies the process of refreshing / updating the inStore data previously provided.
Portable mode is a complete solution to providing information and enabling disconnected users to utilize it.
|27 I am not given the option to choose Portable or Connected Mode on starting inTuator? Technical FAQs|
|At some time inTuator has been asked to remember your default and not ask the mode to use. To change this, choose the Tools / Options/ General Tab, select 'Confirm Connected Mode', exit inTuator, re-start inTuator. You will be asked to choose the mode required.|
|28 Why is it recommended that inTuates on DB2/400 based inStores not be involved in Portable Mode? Technical FAQs|
|The flexibility provided in inTuator to choose any entry in a parent inTuate, then display only the appropriate information in a linked 'child' inTuate is the reason for this recommendation. Due to the manner in which this 'child' information is retrieved from its inStore, in Portable Mode any such links to 'children' inTuates based on DB2/400 inStores will fail.
This may be inapplicable and/or acceptable in some situations (for example if no links are involved) and the Package preparation process allows the recommendation to be ignored. In such cases instead of an inStore and its content, the package prepared will contain the PC-resident cube(s) of multi-dimensional data.
The recipient of such the package will have full capabilities, except for linking, mentioned above.
|29 How do I know if I am in Portable Mode? Technical FAQs|
|There are a number of clear indicators - the Connection icon in the lower right will indicate that there is no connection, the Home page will only indicate that you can select an inTuate from the slide out list, the navigator bar on the left will only have Favorite and History tabs and a number of menu options, such as create/change inTuates, inStores will be unavailable.|
|30 How do I make use of the Portable Mode features? Technical FAQs|
|When opening inTuator, you have the option to confirm the mode required - Connected or Portable. Choose whichever you wish. If the option is not presented, at some time inTuator has been asked to remember your default and not ask the mode to use. To change this, choose the Tools / Options/ General Tab, select 'Confirm Connected Mode', exit inTuator, re-start inTuator. You will be asked to choose the mode required.
To prepare a package for distribution you must be connected to your iSeries iServer and this must have been licensed for Portable mode Packaging. From the Tools menu, choose Prepare a Package and follow the wizard.
Any inTuator user can open and install the contents of a Package that they receive. Either, double-click the Package attached to an email and the installer should commence or, choose Tools / Install Package and the contents of the Package will be installed to the locations indicated in Tools / Options / File Locations. For each new inTuate involved, an entry will be added into Favorites.
|31 Can data updates be distributed to Portable Mode users regularly? Technical FAQs|
|Yes. When preparing a package, one step in the wizard is to indicate whether 'full' or 'restock' is required. If 'restock' is chosen the package prepared will only contain the current data from the
inStore(s) or cube(s) involved.
The task of packaging / distributing regular data restocks will be simplified by organizing each package that you intend to distribute into its own folder. Use the Favorites context menu (right mouse click when pointing at an inTuate) to create a separate and name a sub-folder in the My Packages folder, then copy each inTuate involved to this sub-folder. When necessary to prepare a 'restock' package, the folder required can be selected, Prepare Package started and the wizard will process the selected folder's contents.
|32 Any prerequisites involved with Portable Mode and Packaging? Technical FAQs|
|Any PC running inTuator Release 1.1.185 or later can use inTuator in Portable mode.
To prepare packages :
|33 I tried to use inTuator Help and I got a security warning - it wanted to install software, a Republico Active X TOC. What is this?Technical FAQs|
|inTuator's innovative online help uses an Active X control supplied by Republicorp. It is safe to install this software.|
|34 When I open an inTuate, I get an error Safety Settings on this machine prohibit accessing a data source on another domain. What is this?|
|This means you need to allow your
internet zone security settings to access data sources