Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Newbie Question on relationshop between Category and ...
- Thread starter kingchau
- Start date
Impromptu report is a report against the defined database. Impromptu will generate SQL that queries the database returing the selected data set. Report formatting, grouping, calculations can all be performed with the Impromptu interface, ie, the user will not need to have any knoweldge of SQL.
The Administrator version of Impromptu allows a developer to define the tables and their logical relationship with each other, ie, table joins etc. The administrator determins how the user views the data and which data is accessable.
An impromptu report can be saved as an iqd file (Impromptu Query Definition) which can be used by Transformer to read data returned by the the Impromptu Generated SQL saved in the iqd file. Multiple iqd and other data sources can be accessed by one Transformer Powerplay model.
Other data source types include csv and excel but not a direct connection to the database such as Oracle.
Simplest way to connect is via a single copy of Impromptu Administrator to define the connection to the Oracle db, have this to write reports and then save the reports in the iqd format and get transformer to read these definitions.
A category is any data label within a powerplay cube (ie, customer name, product type, etc) Maximun of 500000 can be held within a single cube.
Good luck
Tony
tony.goldsmith@frontline-consultancy.co.uk
The Administrator version of Impromptu allows a developer to define the tables and their logical relationship with each other, ie, table joins etc. The administrator determins how the user views the data and which data is accessable.
An impromptu report can be saved as an iqd file (Impromptu Query Definition) which can be used by Transformer to read data returned by the the Impromptu Generated SQL saved in the iqd file. Multiple iqd and other data sources can be accessed by one Transformer Powerplay model.
Other data source types include csv and excel but not a direct connection to the database such as Oracle.
Simplest way to connect is via a single copy of Impromptu Administrator to define the connection to the Oracle db, have this to write reports and then save the reports in the iqd format and get transformer to read these definitions.
A category is any data label within a powerplay cube (ie, customer name, product type, etc) Maximun of 500000 can be held within a single cube.
Good luck
Tony
tony.goldsmith@frontline-consultancy.co.uk
- Status
Similar threads
- Locked
- Question