How to save the SQL as an IQD

[Steve]

Guys:

Maybe a basic question. After creating a model , how do we create an IQD from Framework Manager. I mean, how to save the SQL as an IQD to be used by Transformer for building a cube? Does it have anything to do with 'Externalise' option in the 'Properties' ?

Thanks for your time.

[leithp]

Indeed it would.

You have to set the Externalize Method to IQD for each query subject you'd like to export (I can't see a way to do it for all of them at once).

Then when you publish the package, you have to check the box that says "generate the files for externalized query subjects" (paying attention to the associated target directory) and publish.

I don't think you can externalize without publishing.Ã,  Wierd.Ã,  But as far as I know at this time, true.

[Steve]

Thanks !! That's exactly what I was missing.

Weird though: The framework mgr model works for making reports in Query and Report Studio so the DB connectivity is there but when I generate the IQD's and try that in Transformer, it can't connect to the DB. It says not defined in Cognos.ini etc. The framework Mgr model is pointing to SAQL Server OLE DB (used when the model was created). Anyway, I will try to figure that one out.

[coggerm]

Hey Steve,

You must write the database in the cognos.ini. than it works.

try it. we have the same problem yesterday with a new source

[Steve]

YUP!  It worked coggerm !  Thanks.