Search results for query: *

You will see from the Imp menu etc. that you can 'schedule' a report. Internally, Impromptu builds an object that it hands off to the scheduler. If the report contains prompts Impromptu will get those from the user and package them into the object. When the time comes for scheduler to 'run' the...

A tabular reference is really a reference to the specification of a query that is merged into the query that references it. eg. Q1=select * from T1 Q2=select * from Q1 becomes select * from ( select * from T1) Q3=select * from T2 where .. in ( .. Q1) So lets assume that only Q2 and Q3...

It may pertain to SQL constructs that by default CRN is peforming locally as opposed to sending to MySQL. You can determine this visually when you know what to look for or do it more slowly by setting the query property to database only and looking at the errors you might see re which constructs...

Only DecisionStream has the ability to communicate directly with R/3. It does so by accepting SQL-9x based select statements which it dynamically transforms in ABAP/OpenSQL code which it executes via rfc calls. Hence, it is able to work with pool/clustered tables, abap functions that return...

I suggest that many who don't know how to use/leverage FM will tend to fall back to hand coding SQL. Ideally, you should limit the desire to do this and where possible leverage the #macro# facility that allows a type-in SQL query to be dynamically generated. The query engine does internally...

In the expression editor you will see a folder for 'business' calculations. These 'functions' allow you to perform various common 'date' calculations such as add/subtract days etc. You will also see the constructs for current timestamp, date and time etc ni the expression tree. These are...

Without examples it hard to know what you have done. If you are using CRN you can review at the cube or tabular query level the logical SQL and native SQL. In the logical queries you will observe for aggregations a notation that defines what partition of data an aggregate is computed over and...

Suggest you contact support with your use case. Without any knowledge of your specific issue ensure that the drive to with the CRN \temp location is mapped is not low on space.

CRN has a layer that provides the query engine capability and within that provides gateways to interface to a specific data provider API. The error message is indicating that the share library failed to load. This means that either the actual library name is missing or more likely the required...

Impromptu allows you to model in the catalog two or more references to the same table using the ALIAS facility. Should you go to the query dialog and the edit button is not greyed and you start to edit the statement you have assumed control of the query definition. That query definition is the...

the upgrade process etc. is documented. presume that things can be upgraded to newer servers but new schemata is not assured to be handled by older servers.

The content store is only certified to be deployed in SQL Server 2000, DB2 8.x UDB Linux/UNIX/Windows and ORACLE 9i/10G in the 1.X releases. ReportNet is able to query many other sources including Informix IDS/XPS etc.