Hi guys,
I'm trying to create a cube, using IQD's.
I don't have Impromptu i only have Cognos8.
Do i use framework manager or something else?
thank-you!
hi jeka..
have u installed series 7 IQD bridge with cognos pack?
The Series 7 IQD Bridge is an optional component during installation..
actually im using 8.3..here the option is available to work wit IQD and to build cube in transformer..
with regards
venkys4u :)
IQDs are just sql statements that you can write in notepad or any other word editor. The IQD is unique because the of the format the sql statement must be in. Something like:
COGNOS QUERY
STRUCTURE,1,1
DATABASE, xxx_xxx
DATASOURCENAME,xxx
BEGIN SQL
select *
from abc.view
END SQL
COLUMN,0,field 1
COLUMN,1,field 2
COLUMN,2,field 3
then you use the IQD as a data source in Transformer to build the cube. We don't have impromtu any longer and use IQDs to build all of our cubes. We usually use select * from a view on the database, but some of our iQDs are the actual sql with calculations and where statements. hope this helps
Hi
IQD is nothing but the Impromptu Query Definition.If u not have Impromptu no issues u can create iqd in Cognos 8 using Framework manger.
take ur data source in FM model and click a particular Query Subject i.e. table and see the Properties Pane ,into it there is option like Externalised Query ..... set that as IQD.
Note:-while publishing a Package for the same model don't forget to specify the location for the IDQ's.thats it!!
Hope it will help u :)
Quote from: Nichole on 22 Jul 2008 12:43:07 AM
Hi guys,
I'm trying to create a cube, using IQD's.
I don't have Impromptu i only have Cognos8.
Do i use framework manager or something else?
thank-you!