If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

ONE COUNTS BASED ON A CONDITION in FM MODEL (RELATIONAL)

Started by gosoccer, 16 May 2017 02:26:47 PM

Previous topic - Next topic

gosoccer

Hi folks, ;D ;D

I have a the following in my Framework Model and it is producing a 1 or 0 for each record that meets the condition.

if ( [UCM Physical View].[STATUS]  in (1,2,3) )
then (1)
else  (0)

The problem is I need to have any record that falls into (1,2,3) to have only one row as 1 and not 3 rows showing 3 1's.

  ID        STATUS      COUNT
1111       1                 1
1111       2                 1
1111       3                 3

In the other word, I need to have the following to show as one count when the (1,2,3) is met as the condition.
ID        STATUS      COUNT

Pls help if you can.

Thanks so much. :) :)

111       1                 1
1901        1111       2                 1
1902        1111       3                 3

gosoccer

Or if there is a way to handle this count within the Report Studio since I'm dropping it as a measure in the Report Studio Crosstab as a Defined Cell.

:) :)

New_Guy

Hi,

Will maximum status for ID work at the reportstudio or in FM? Also try a running-count as a filter and maximum status for ID as a filter.

Good luck
New guy

gosoccer

I setup the Determinant in FM Model Subject Query for ID, Status, and Date. So, it seems like it's doing the trick.
Thanks,