Foros
Nuevos mensajes
Buscar en foros
Acceder
Regístrate
Novedades
Buscar
Buscar
Buscar solo en títulos
De:
Menú
Acceder
Regístrate
Install the app
Instalar
Foros
Software de Gestión
Business Intelligence
Problems creating a Query Item in Cognos 8 Framework Manager
JavaScript está desactivado. Para una mejor experiencia, por favor, activa JavaScript en el navegador antes de continuar.
Estás utilizando un navegador obsoleto. Este u otros sitios web pueden no ser mostrados correctamente.
Debes actualizarlo o utilizar un
navegador alternativo
.
Responder al tema
Mensaje
<blockquote data-quote="dferreirazoppis" data-source="post: 9357" data-attributes="member: 10558"><p>I have two Query Subjects: TICKETS (with columns id_ticket and insertDate) and HOLIDAYS(with only one column: hDate). </p><p>I must create another column in query subject TICKETS: Holidays_count that counts the number of days of HOLIDAYS with HOLIDAYS.hDate > TICKETS.insertDate</p><p></p><p>Using SQL it could be:</p><p></p><p>select T.id_ticket,</p><p>T.insertDate,</p><p>(Select count(1) from HOLIDAYS H where H.hDate > T.insertDate) Holidays_count</p><p>from TICKETS T</p><p></p><p></p><p>I think I must use 'count' expression, but I don´t know how to apply the filter: H.hDate > T.insertDate in the FM Expression Editor.</p><p></p><p>Thanks in advance.</p></blockquote><p></p>
[QUOTE="dferreirazoppis, post: 9357, member: 10558"] I have two Query Subjects: TICKETS (with columns id_ticket and insertDate) and HOLIDAYS(with only one column: hDate). I must create another column in query subject TICKETS: Holidays_count that counts the number of days of HOLIDAYS with HOLIDAYS.hDate > TICKETS.insertDate Using SQL it could be: select T.id_ticket, T.insertDate, (Select count(1) from HOLIDAYS H where H.hDate > T.insertDate) Holidays_count from TICKETS T I think I must use 'count' expression, but I don´t know how to apply the filter: H.hDate > T.insertDate in the FM Expression Editor. Thanks in advance. [/QUOTE]
Nombre
Verificación
¿Cuanto es 4-3+2?
Responder
Foros
Software de Gestión
Business Intelligence
Problems creating a Query Item in Cognos 8 Framework Manager
Arriba
