Editing IQD Files

[badhri]

Greetings,

I created a Catalog and generated an IQD File using which i created a cube. When I generated a report from the cube I was missing some years in my data. I ran the query in the IQD file and identified that it had generated an ANSI query. (Don't know what id means).

I tried to change the query with some usual outer join and when I checked the model I found that the model doesn't accept that IQD file and gives me an error message.

The Sample of the isse IQD file is,

Original Query was,

("FDMADM"."CUSTOMER_MASTER" T2 left outer join ("FDMADM"."IW_PARENT_CHILD_CUSTOMER" T1 left outer join "FDMADM"."BBS_HISTORY" T3 on T3."ORG_SOLD_TO_NUM" = T1."CHILD_CUSTOMER_CD&quot on T3."ORG_SOLD_TO_KEY" = T2."CUSTOMER_KEY&quot

Modified Query is,

"FDMADM"."CUSTOMER_MASTER" T2,
"FDMADM"."IW_PARENT_CHILD_CUSTOMER" T1,
"FDMADM"."BBS_HISTORY" T3
WHERE T1."CHILD_CUSTOMER_CD"(+) = T3."ORG_SOLD_TO_NUM" AND
T2."CUSTOMER_KEY"(+) = T3."ORG_SOLD_TO_KEY"

Kindly help me with your thoughts.

Thanks,
Badhri ...

 

[khobar]

Badri

Don't try to modify IQD directly instead go to Catalog-->joins and select outer Join and regenerate the IQD File based on this join

 

[CognosProfessional]

When you say "I ran the IQD file", did you run it in Impromptu? After that, did you look at the SQL through the query dialog box and then click on the Profile tab to view the sql? All you need to do is modify the Impromptu report , which is the .imr, and then save it as an .iqd and click "modify columns" in the .mdl (transformer Model) and re-run your cube. Provided that the correct information is in the (Impromptu Report) .imr before saving as .iqd (Impromptu Query Definition).

CP