Technical Frequently Asked Questions

inTuator Home

Technical FAQs

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 support@intuator.com 

1 What impact is inTuator likely to have on machine performance?
2 What are the configuration prerequisites of inTuator?
3 What is the difference between DB2/400 and LAN Access inStores and inTuates? 
4 What is the difference between inTuates for Office 2000 and Office XP?
5 LAN access inStores can cause ODBC connect failure if the file is beyond 999.
6 I am getting some errors in Excel. Where can I find out more information?
7 a) Excel errors when exporting inTuates with conditional number formatting
  b) Number formatting is lost when exporting to Excel
8 What is the number formatting for Pivot Tables?
9 For use with NT 4.0 I need "Microsoft Windows NT 4.0 integrated shell". How do I check if I have this?
10 How do you create a calculated field in the table?
11 How do you add data from other sources?
12 How do you email inTuates to people outside the network?
13 Can you schedule an inStore restock to be run at certain times?
14 a) I've changed the dimensions in an inTuate in the viewer, will it look the same when I re-load it? 
  b) How do I refresh/reset my inTuate to ignore changes I have made without having to resort to amending the inTuate?
15 a) What is the limit to the number of records I can have in an inStore?
  b) What is the limit to the number of levels & totals I can have in an inTuate?
16 Can I show more than one inTuate table at a time in the browser window?
17 Can you translate the inTuate description headings for Page, Column and Row?
18 Can I link inTuates across data from different i-Series applications?
19 Do you need Client Access to run inTuator?
20 When I link inTuates together, do they have to use the same inStore?
21 Some of our users are on 2000 and some on XP. Can they run the same inTuates?
22 If functions such as totals and percentages are in the inTuate design, how will it look in Windows 2000?
23 How do I print charts, do they have to be printed in Excel?
24 Can I lock the headings when displaying an inTuate, similar to the Excel function?
25 Are there limitations when using Portable Mode?
26 Currently, I email an inTuate as an attachment, why are Portable Mode packages better?
27 I am not given the option to choose Portable or Connected Mode on starting inTuator?
28 Why is it recommended that inTuates on DB2/400 based inStores not be involved in Portable Mode?
29 How do I know if I am in Portable Mode?
30 How do I make use of the Portable Mode features?
31 Can data updates be distributed to Portable Mode users regularly?
32 Any prerequisites involved with Portable Mode and Packaging?
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?
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?
 

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.

Back to top^      

 
2   What are the configuration prerequisites of inTuator? Technical FAQs

iServer (server) on the iSeries

iSeries requirements:

  • RPG or RPGLE compiler for report program creation
  • V4R5M0 or later of OS/400
  • 210mb disk space for the the Jacana iServer product
  • Client Access for iSeries V4R5M0 or later
  • Appropriate level of your main application compatible with inSets available.

inTuator and Valet on the PC

PC hardware requirements (minimum):

  • a Pentium processor, Pentium III recommended
  • 128 MB of RAM recommended
  • 8 MB of free hard disk space for the inTuator software
  • 7 MB of free hard disk space for the Valet software
  • additional hard disk space is required for saving definitions on your PC
  • A communication adaptor connecting your PC to your iSeries; for example, Twinax, Ethernet or Token Ring, modem connection under the Client Access router, or TCP/IP

PC software requirements (minimum):

  • Office Web Components of Microsoft Office 2000 or Microsoft Office XP - provided as part of the Office suite and subject to its license being available 
  • Microsoft Windows 98 or 
    Microsoft Windows NT 4.0 (including the IE 5.0 (or later) integrated shell) or
    Microsoft Windows 2000 or
    Microsoft Windows XP
  • Microsoft Internet Explorer 5.0 (or later)
  • If using APPC or CPIC communications protocol, you will also need:
    Client Access Version 4.5 or later ODBC
    or MDAC 2.5 or later
  • Your PC needs to be communicating with an iSeries running Jacana iServer Level 081Xx or later.

PrepP/29T - runs on a Windows NT Server as a service.

Hardware requirements (minimum): 

  • Pentium processor, Pentium III recommended
  • 128 MB of RAM recommended
  • 10 MB of free hard disk space

Software requirements (minimum):

  • Windows operating environment NT 4.0 Server / 2000 Server

Back to top^      

 
3   What is the difference between DB2/400 and LAN Access inStores and inTuates? Technical FAQs
 

Click Here

Back to top^      

 
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:
  • Improved filtering with support for top and bottom N filters: Now you can create conditional filters for a richer slice of your data. Create filters to show the top or bottom 10 items based on count, sum, or percent. 
  • Calculated totals and detail fields: Authors can extend the information presented to users by creating new fields and totals using expressions. Calculated detail fields like "Price*Quantity" can be added to the PivotTable list as well as new calculated totals for analysis like "Budget/Actual" or growth from the same period last year.
  • Select multiple items in filter fields: Now you can select more than one item to filter when a field is in the filter area. By doing so, you will see the aggregate of the selected items in the report.
  • Grouping intervals: Developers or end users can group detail field values into higher-level buckets: by their first one or two letters, by every 10 if it is a numeric field, or by date/time intervals.
  • Display your totals as a percentage: Now you can analyze your information by comparing percentages across a row or column. Values can be displayed as a percentage of row, column, grand or row/column parent total.
  • Custom sort sequences: In many reporting situations, users require explicit control over the ordering of members on an axis. Now you can order members exactly the way you want them. Just select a member and drag it where you want it. 
  • Ad-hoc member grouping: Users will be able to group members together with a combined total in a new level. For example, now you can group the sales folks that report to you into a custom group with appropriate totals.

Back to top^      

 
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.

Back to top^      

 
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.

For a Microsoft Excel 2002 version of this article, see Q291061. For a Microsoft Excel 2000 version of this article, see Q211517.

Back to top^      

 
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.

Back to top^      

 
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.

Back to top^      

 
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.

Back to top^      

 
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

Back to top^      

 
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.

Back to top^      

 
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.

Back to top^      

 
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 that data.

Portable Mode has been introduced to overcome these issues, see Currently, I email an inTuate as an attachment, why are Portable Mode packages better?

Back to top^      

 
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
  • it can be done using your iSeries scheduler (see the operating system command WRKJOBSCDE - Work with Job Schedule Entries) 
  • your iSeries may have a specific product such as Robot Scheduler to facilitate this. 
See your iSeries Administrator to set this up for you.

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. 

Here is an example of the RPTRUN command: 

ISERVDTA/RPTRUN REPORT(<your-inStore-name>) SELECT(<select-value-1> <select-value-2> ...) 

The RPTRUN command has parameters to control a number of aspects of its execution. 

You can cut-and-paste the above example to your iSeries command line then press F4 to prompt the command. If you then press F9, you can explore all its parameters and read the available help text (press F1, while prompting the command, to see the help text). 

Back to top^      

 
14a   I've changed the inTuate in the viewer, will it look the same when I re-load it? Technical FAQs
inTuator 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 saved. 

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.

Back to top^      

 
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.

Back to top^      

 
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.

Back to top^      

 
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.

Back to top^      

 
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 detail area. 

You can initiate inTuator more than once, viewing different inTuates in each initiation.

Back to top^      

 
17   Can you translate the inTuate description headings for Page, Column and Row? Technical FAQs
  • By clicking on a field in the table you can access the PivotTable Property Toolbox for a field and the field name is displayed under the Captions heading. 
  • You can edit the name and on closing the toolbox the new name will be reflected in the table. 
  • This change will only be made in the inTuate on your local machine not the source data.

Back to top^      

 
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.

Back to top^      

 
19   Do you need Client Access to run inTuator? Technical FAQs
No. Client Access is only required if you access the inStore contents directly from DB2/400; see inTuate options on first inTuate Wizard window. 

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.

Back to top^      

 
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.

Back to top^      

 
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.

Back to top^      

 
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.

Back to top^      

 
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.

Back to top^      

   
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 -
  1. Click the drop-down arrow for the field that contains the items of data that you want to filter. 
  2. Select the check boxes for the items that you want to display, and clear the check boxes for the items of data that you want to hide. 

Alternatively you can export the Table to Excel and use the Freeze Pane feature.

Back to top^      

 
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 :
  • inStores and inTuates cannot be created, changed or deleted (the definitions are resident on the Server)
  • inStore restocks (with Server data) cannot be requested from inTuator
  • requests to reload an inTuate from the Server cannot be made
  • checks on the web for, and downloading of, Product updates cannot occur
  • Help / Support from the web is not available
  • Packages cannot be prepared
  • the Explore and Find tabs in the Navigator are not available (since these operate only on Server data)

Back to top^     

 
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.

Back to top^     

 
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.

Back to top^     

 
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. 

Back to top^     

 
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.

Back to top^     

 
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.

Back to top^     

 
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.

Back to top^     

 
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 :

  • iServer is at least 8.1Af patched to ISV8108
  • iServer is licensed for Packaging
  • Must be connected to your iServer
  • PC has InTuator 1.1.185 (or later) installed
  • Any inTuates to be packaged are regenerated at this level (choose each inTuate, click Change and step through the wizard without changes, there is no need to recreate)
  • Any inTuate to be packaged must be in Favorites
  • Recommended that inTuates to be packaged use LAN-based inStores. 

Back to top^     

 
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.

Back to top^     

 
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 across domains.

.

Back to top^     

 

Copyright Momentum Utilities Pty Ltd - July 2016  
Legal Information
- Privacy - Contact Us