Mulitply rows by qunatity column

[Przemek]

Hi there,

I would like to ask you a question. Maybe someone try to do this in Cognos itself already.

There is an construction you can build in Oracle DB like below:

Code Select Expand

SELECT *
  FROM (SELECT 'line' COLUMN1, 8 QTY FROM DUAL) Q
       JOIN (    SELECT LEVEL N
                   FROM DUAL
             CONNECT BY LEVEL <= 100)
          ON N <= Q.QTY

This will muliply every record by number of QTY column.
How can I do this if I will have query like below:

Code Select Expand

SELECT column1, qty from table
and would like to muliply every record in Cognos using the number from QTY column?

[Przemek]

Kind reminder. Has anyone have any idea?

[bdbits]

Does this produce a tally table? I have used such a technique in ETL processes, but not inside a reporting tool. In fact I am not certain why you would need it. What is the goal you want to accomplish? Or are you just wondering?