Technical Frequently Asked Questions

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? Technical FAQs

iServer produces compiled programs to ensure efficient performance of inStore creation.

Back to top^      

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^      

Click Here

Back to top^      

• 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^      

Back to top^      

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.

Back to top^      

Back to top^      

Back to top^      

Back to top^      

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^      

Back to top^      

Back to top^      

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^      

• 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. 

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^      

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^      

Back to top^      

Back to top^      

Back to top^      

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

Back to top^      

• 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^      

Back to top^      

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^      

Back to top^      

Back to top^      

Back to top^      

Back to top^      

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^      

• 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^     

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^     

Back to top^     

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^     

Back to top^     

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^     

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^     

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^     

Back to top^     

© Copyright Momentum Utilities Pty Ltd - March 2010  
Legal Information - Privacy - Contact Us