How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
14 articlesCan I create a calculated field based on some Progress ABL Business logic?
Applicable Versions: 2.1.0152 Onwards DataPA Freeform Subjects can include calculated fields derived from any valid Progress ABL statement. By using the Progress DYNAMIC-FUNCTION statment, you can include calls to a ABL business logic function on the server to populate your calculated field. The…
Read article →Administration › SetupCan I store the DataPA configuration in a database?
Yes, you can store the DataPA configuration in a database. This allows you to completely control, based on the user, which connections, subjects, subject fields, links and lookups they have access to. In order to achieve this you need to follow the steps below. If you are starting with the…
Read article →Administration › SetupHow can I import links from QAD into DataPA? The import deafult links wizard doesn't return any records.
Because the QAD MFG/PRO database has field names which are unique the import default database links does not return any records. This is the same result as if you ran the DB Relations report in the Progress Data Dictionary. In order to quickly and easily set up links in DataPA for this database…
Read article →Administration › SetupHow do I access to the OpenEdge VST's with DataPA OpenAnalytics?
Applicable Versions: 5.50.0026 Onwards The OpenEdge VST’s offer insights into the physical storage, performance, memory usage and user activity of the database. However, they are not by default exposed to DataPA OpenAnalytics. To expose the VST's to DataPA OpenAnalytics, follow these steps; Add…
Read article →Administration › SetupHow do I change the license applied to DataPA Enterprise when an existing license has already been applied?
Applicable Versions: 4.05.000 Onwards "When I open DataPA Enterprise in a web browser, I get the error 'No valid DataPA OpenAnalytics Enterprise license has been applied to this server';. How do I fix this?" describes how to apply a license to a new installation of DataPA Enterprise. However in…
Read article →Administration › SetupHow do I find the application data folders used by DataPA OpenAnalytics
Applicable Versions: 3.00.0001 Onwards DataPA OpenAnalytics uses two folders to store information on the local machine. For user specific information, DataPA OpenAnalytics uses the Roaming User Profile application data folder. For system wide information, DataPA OpenAnalytics uses the Common…
Read article →Administration › SetupHow do I set up the condition to link a Business Logic Subject with a parameter as a child of a multi-level query?
Applicable Versions: All Ensure that the Business Logic Subject's parameter is set to Mandatory and enter data in the "Prompt user for a parameter value" section. Take note of the Required Value Name. In the example below this would be "Enter Department". When setting up the Query Condition for…
Read article →Administration › SetupIs it possible in DataPA to create a query that will return records from one table which have no matches in a second table?
Yes, in order to achieve this a special type of link between the database tables needs to be created. This functionality is available from version 3.05.0036 onwards. If we take an example using the sports2000 demo database and say that we want to create a query to find customers who have no…
Read article →Administration › SetupOpenanalytics Download - Latest Version
Product Downloads Download the latest installation package and access release documentation for your DataPA product. Latest Software Release The latest production release is available below. Installation Package Download the latest product installer (.exe) Includes all required application files…
Read article →Administration › SetupWhat are the performance implications of using multi-queries to link subjects?
Applicable Versions: 3.05 Onwards The advantage of the multi level level (or complex) queries is that they provide extra flexibility by allowing users to combine subjects together in their queries. The downsides of them are a) that they may be too complex for business users to use as it requires…
Read article →Administration › SetupWhat data sources can I connect to with DataPA OpenAnalytics?
Applicable Versions: 6.00.0001 and above DataPA OpenAnalytics supports many different connection types to enable you to extract and blend data from across your organisation. ODBC and Openedge Application Server connectivity allows you to extract data from most common relational databases,…
Read article →Administration › SetupWhat is wrong when I get a Permission Denied message when trying to save in the DataPA Setup screen.
This message indicates that you do not have permission to save to the folder that has been designated as your Data Location. To resolve this problem you need to change the permissions on the folder that has been designated as your Data Location to allow your user write access.
Read article →Administration › SetupWhen creating a business logic subject, all labels I have entered for the fields returned are unique, but the subject wizard always says "Incomplete data, You cannot have more than one field with the
Applicable Versions: 2.01.0152 and above Field labels must be unique for each parameter and field in a business logic subject. If you give a parameter the same label as a field, you will not be able to proceed past the last screen in the subject wizard (see the screenshots below). To resolve…
Read article →Administration › SetupWhen I try and use the Create New Report option I get the following error 3021 - Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. ADOD
Applicable Versions: All This error can arise if the setup file ( DataPASetup.dat ) has been saved with a later version to that running in the DataPA Client Application. Subjects can be moved from a later Version of DataPA using the Analytics Import/Export functions, available in the Analytics…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗