|
|
|
Frequently Asked QuestionsGeneral
Technology and Performance
SecurityInstallation
Embed Excel
GeneralHow do I request a demo of Data Access Studio™?First check the resellers page to see if there is an authorized reseller in your area. If there is, then contact this reseller for an on-site demo. If there is not a reseller in your area, Contact ReportsNow at support@reportsnow.com or 303-693-6999. We can setup an online demo with you. Back to TopWhy would I need Data Access Studio™ if I have UTB?Data Access Studio™ has significant advantages over UTB. You need Data Access Studio™ if you need the ability to:
Back to TopHow can I deploy new versions of Data Access Studio™ to my enterprise?Data Access Studio™ has four ways to deploy to your enterprise:
With the Full Client option. Data Access Studio™ has an automatic update system. The system administrator simply updates Data Access Studio™ in a central location. Every Data Access Studio™ workstation will pull the update the next time the user opens Data Access Studio™. For those companies that use enterprise deployment software such as Tivoli or ZenWorks, Data Access Studio™ deploys as an MSI package. For the Citrix, LAN Server, and HTTP Server options, simply update the server with the latest version of Data Access Studio™. The clients simply connect and run! Back to TopIs Data Access Studio™ fast?Data Access Studio™ loads records over 2 times faster than UTB. The user interface is fast, modern, and responsive. Back to TopDoes Data Access Studio™ work with non-OneWorld® Data?Data Access Studio™ can view data from any ODBC and OLEDB compliant table. Back to TopIs Data Access Studio™ designed to work with OneWorld®?Data Access Studio™ is specifically designed to work with OneWorld®. This means that Data Access Studio™ seamlessly integrates into the OneWorld® system by leveraging OneWorld®:
Back to TopTechnology and Performance
What is the impact on systems performance when you run Data Access Studio?DAS does the following to minimize any system performance degradation:
Where does DAS keep the results of the reports/grid/query that I see on my screen?All grid results are stored on the local workstation (whether that workstation is a full client or a thin client). Where does DAS perform it’s calculations?All calculations are performed on the machine that runs the DAS Client. On the Fat Client, all calculations are performed on the user's workstation. On the LAN or Web mode, calculations are performed on the user's workstation. On Citrix, all calculations are performed on the Citrix server. How does DAS connect to the JDE OW database?DAS connects using the JDE middleware. This means that DAS will work with whatever OneWorld data sources you have set up. Furthermore, in using the JDE middleware, DAS enforces the JDE data access security. Does DAS perform any locking on tables while it is performing its queries?Because DAS is read-only, it does not lock any records. It is up to the particular database to make the query read-consistent. Does DAS have a log?Yes. DAS has both an error log and a trace log. Furthermore, DAS uses the existing jde.log and jdedebug.log to trace the JDE middleware. You can turn on the DAS error log in the following ways:
DAS Trace is available in version 4.0. The DAS Trace can be useful to see DAS's execution milestones. To turn on the Trace:
The DAS Help topics are blank when viewed over the network. How do I fix?As of Windows XP SP2, Microsoft has disabled .chm content across the network. Please see this Knowledge Base article on how to fix: http://support.microsoft.com/kb/892675/
In IE7, the Web Client gets the message: "There is a problem with this website's security certificate." How do I fix?DAS signs all executables with a Digital Certificate that ReportsNow created. This ensures that all executable files cannot be tampered with. Because ReportsNow is not a Root Certificate authority, IE7 now issues this warning message when you run DAS. You can alter the security settings per the KB article below to fix this issue. Please apply "Method 2" to avoid the Navigation Blocked window below...
SecurityHow does DAS enforce EnterpriseOne security?DAS enforces EnterpriseOne row and column security as follows:
Does DAS provide application-level security as well?Yes. DAS provides a security system that allows the administrator to:
The security system is based on a hierarchical model that simplifies security maintenance. Installation
Why do I need to install from an EnterpriseOne Workstation?DASUpdate.exe reads information from your JDE system to determine how to install Data Access Studio. Because of this requirement, the DASUpdate.exe installer prompts you with an JDE sign in. Once you sign in, the DASUpdate.exe installer reads information, such as the location of the deployment server, to determine what needs to be installed where. The instructions DO NOT recommend that you run DASUpdate.exe on your deployment server for the following reasons:
Why does DASUpdate.exe create a directory on my deployment server?DASUpdate.exe creates a directory called "Data Access Studio" on your deployment server to support the following:
Can DASUpdate.exe run on a FAT Client only without doing anything to my Deployment Server?Yes -- although this configuration is not recommended (see Why does DASUpdate.exe create a directory on my deployment server) When you run DASUpdate.exe on a workstation, and you get to the "Target Folder" Wizard screen, enter a local folder (such as C:\DAS) instead of the Deployment Server folder that the installer provides. This will then extract the DAS install components to the selected local folder. After DASUpdate.exe is complete, share the local folder (i.e. C:\DAS) so that other workstations can install DAS by running C:\DAS\Setup.exe. This procedure will not update the deployment server. However, this procedure will still create one table FDASPROP in your system data source and one OCM mapping. Why does DASUpdate.exe create FDASPROPin my system data source?FDASPROP is the main storage table for Data Access Studio. This table is where DAS stores layouts, reports, preferences, etc. DASUpdate.exe creates this table in the system data source to ensure DAS users have access to FDASPROP no matter which environment they sign in to. Furthermore, because there is only one FDASPROP for your entire enterprise, you DO NOT have to worry about environment promotion (e.g., DV->PY->PD). After DASUpdate.exe creates FDASPROP, it then creates an OCM mapping for FDASPROP. This way, DAS will always know where the FDASPROP is located regardless of the signed-in environment. Note also, that because FDASPROP is a central table, users will have their information stored consistently no matter how they run DAS, from either
The result of this configuration is easier maintenance and less hassle for the users and system administrators. What are the DAS deployment options?You may deploy DAS to your enterprise in any of three ways:
In the Workstation deployment, your users already have a E1 full client install. Your users install the DAS client to their workstations. Once installed, DAS runs entirely from the user's workstation -- consuming resources only from the workstation and the database. In Citrix deployment, your users do not have an E1 full client install and are typically located on a WAN. Once installed and published on Citrix, your users dial in to the Citrix server and run DAS. DAS consumes resources from the Citrix server and database. In the DAS LAN your users do not have an E1 full client install and are located inside your LAN. Once installed, user's run DAS from a shared link. DAS consumes resources on the DAS LAN server, the user's workstation, and the database. In the DAS Web Server, your users are located in a Wide Area Network. Users run DAS from a web page link (hosted by IIS, Apache or other suitable web server). DAS consumes resources on the DAS LAN server, the user's workstation, and the database. How do I delete DAS from my system after a trial?For workstations and Citrix Servers that have DAS installed, use Add/Remove programs. Remove Data Access Studio. For the deployment server, delete directory: \Data Access Studio For FDASPROP, use the drop table command to drop the table from the database. If you set up a DAS Web Server or DAS LAN Server, you need to uninstall the Data Access Studio Service as follows: installUtil.exe /uninstall DASServer.exe
How do I upgrade DAS when I upgrade EnterpriseOne?When you upgrade EnterpriseOne, you will need to do the following:
Data Access Studio will proceed to import the contents for the .dasi file into your new instance. This procedure will work across non-Unicode to Unicode upgrades as well. For more information, please consult the DAS Administrator's Guide under the section Upgrading EnterpriseOne. Embed ExcelThe Excel tab does not show when I enable Excel. How do I fix?If the workstation with the behavior is a fat client: 1. In Windows, click Start | Run 2. Type: regsvr32 "C:\Program Files\ReportsNow\Data Access Studio\dsoframer.ocx" (You may need to change the path to your actual Data Access Studio directory) If the workstation is a thin or web client: 1. In Windows, click Start Run: 2. Type: regsvr32 "\\<WebServerName>\DASBin\dsoframer.ocx" (You will need to substitute the name of your DAS Web server for <WebServerName> in the command above. The Excel menus do not work correctly. How do I fix?Delete Excel11.xlb file located at C:\Documents and Settings\<username>\Application Data\Microsoft\Excel.
How to Open an Excel spreadsheet using OLEDB?Delete Excel11.xlb file located at C:\Documents and Settings\<username>\Application Data\Microsoft\Excel.
1. Open your excel workbook
|
|
|
Frequently Asked Questions
Frequently Asked Questions
 |  |  |
