How can i transfer iqd's to Framework manager from powerplay transformer

[geinel]

How can i transfer iqd's to Framework manager from powerplay transformer ???
Geinel

[BIsrik]

I couldn't get what u want...as far as i know U can transfer the catlog to FM. if u open an iqd in notepad u see only sql there. i couldn't get what u were saying by transferring the iqd's in transformer to FM...

Srik

[sir_jeroen]

Or do you want to build IQD's using FrameWork Manager instead of Impromptu?

[Draoued]

I agree with BISrik , there is no way to import IQD into Framework manager, Except if you copy/paste the IQD SQL part into a query subject.... No easy to modify or maintain.

If you want to create IQD in Framework Manager to be used in Transformer, then have a look to this

[geinel]

Hi everybody,
Actually i already have a model in transformer, but because of the security reason i can't run it. i was thinking if i could do anything to run that model/cube in report net.

[sir_jeroen]

You can run the query (using cut & paste) ... that's all you can do for now maybe in series 8..

[geinel]

Ok Thanks alot.
Geinel

[cognosfreelancer]

This is my major grievance with ReportNet. (I have more...)

You cannot create .iqds directly from ReportNet.

I was speaking to the product manager of Powerplay at Cogns forum 2005 and she assured me that it will make it into Cognos 8 and that it barely missed making into ReportNet 1.1 MR2.

I have not had a chance to review Cognos 8 to verify her statement.

NKT

[sir_jeroen]

Sorry CognosFreelance..
There's 1 thing I have to say about that:
RTFM

It's pretty easy to create IQD's DIRECTLY from ReportNet...


Create Database/Model Query subject -> externalize method = iqd -> publish (incl. externalizatioin) that's all...

[sir_jeroen]

And to prove it:

http://www.jeroendegraaff.nl/tutorials

[cognosfreelancer]

Hi Jeroen

This is a very simplistic feature.

The externalize feature works only with individual query subjects.

We have IQDs that span multiple tables and contain multiple joins.

The only way to work around is to copy the required SQL and use that to create a query subject,

And that is precisely what we are doing.

We are creating Framework Manager packages exclusively for generating .iqd files.

The reason we are doing this is that we are abandoing Impromptu in total.

We cannot modify our production FM packages for .iwd generation as the modeling was done to solve a business problme rather than Cogno's problem.


NKT

[sir_jeroen]

Hi Cognosfreelance,

Maybe I don't understand you, but at work I use my standard ReportNet package for ReportStudio as for Transformer. In my iqd's I use the standard relations (eg. Productline, producttype, Order #, Revenue) and this gives no error at all.


In some cases I create a completely new model query subject, in which I collect all needed data.
So why don't you add a new namespace called e.g. IQD in which you put all the needed Query Subjects and (if you want) recreate all necessary relations.

This won't interfere with you production / business environment.

[BIsrik]

What would be the use of having relations in ur iqd namespace....Powerplay can't recognise ur relations b/w query subjects.

I follow this pattern...during modeling itself i rename all the columns involved in the relationships to a common name b/w both of them. Then externilize and publish. by this u get ur model and ur iqds also.

Srik