Cube with IQD..,

[Kanag]

Hi all,
          I have a Cognos Cube build on an IQD...

My Question is:
                        When there is a change in the backend database involving the columns used in IQD (for eg: change in the column name), Do i need to create another IQD newly and from that I need to create a new Cube design?????

Is this correct?? or Any other way to achieve that???


Thanks,
KR

[S2000]

Just open the IQD in notepad and change the SQL.

At the bottom of the IQD is a sequential list of all the columns and what they will be called in Transformer.
It's quite easy to understand what's going on when you look at it.

So, as long as the right number of columns are returned in the right order you can mess about with the SQL as much as you like.

In fact, it's not rocket science or brain surgery to write an entirely new IQD from scratch, just borrowing the header and footer code from an existing IQD.

[cognostechie]

Perfect !

Just to add that if the IQD is not hand written and published by Framework Manager, you can easily change the name of the column there and re-generate the IQD.