What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

Jass_gill_1
Profile Answers by Jass_gill_1 Questions by Jass_gill_1
Apr 9th, 2006
4
11709

Questions by Jass_gill_1 answers by Jass_gill_1

Showing Answers 1 - 4 of 4 Answers

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.