Jass_gill_1

 Profile Answers by Jass_gill_1 Questions by Jass_gill_1

• Apr 9th, 2006

 

(just Learned)IQD=Impromptu Query Definitions. IQD contains the query that is run againt the database to get the data. It also contains the database Information. I still dont know how is is created in FrameWork

amitcognos

 Profile Answers by amitcognos 

• Apr 23rd, 2006

 

1. Create a new namespace.<give it a name, say, IQDReportNet>

2. Create a new query subject inside IQDReportNet.

3.In the query subject definition window, pull in all the data you need.

4. after creating, click on the new query subject, from the properties pane, select "IQD" from the drop down menu of externalizeMethod.

DONE.

to Publish. u need to create a package.

1. create a new package. a WIZARD will open.

2. Name the new Package; select the IQDReportNet object from the project.

3. add security, select language, select the funtion list(DB), select the location from the WIZARD

4. Publish the package.

jyothsna

• May 12th, 2006

 

An .iqd file is typically created by Impromptu and contains the definition for a database query.PowerPlay Transformer can access relational data sources via Impromptu Query Definition files.If Impromptu is not available, you can manually create an .iqd file to provide access to relationaldata sources.An Impromptu Query Definition describes a source table from a Data Source. When you create amodel in Transformer, the contents of the .iqd file are stored in the model and the embedded .iqdcontents are refreshed when the data source is opened (that is, when you generate categories orcreate cubes). The .iqd contents are also refreshed when you click OK on the Data Sourceproperty sheet. Input values are retrieved from a supported database by executing an SQL querythat is stored in the .iqd file.

Amedhyaz

 Profile Answers by Amedhyaz 

• Aug 12th, 2008

 

Impromptu Query Definition - Database metadata - Select the query subject items in FM that we want to export in the form of an IQD and select the right option from the contextual menu.