Hello all,
I'm an Informatica developer, not Cognos so please bear with me =)
I'm populating the kpi_value_stage table for CMM via a batch of Informatica processes with all sorts of metrics. All metrics get loaded and show up correctly on the web interface except for one. Here's the weird issue:
When I load the entire batch of metrics, that one doesn't show up on the web interface (although I see it's kpi_id and kpi_value plainly in the stage table). But when I load that metric separately from all the others, it shows up just fine on the web interface. Here's the kicker: when I rearrange my batch processes to make that metric's process the first one in line, ONLY THAT metric shows up on the web interface and almost all the others are zeroed out. This is a repeatable problem (I'm able to repeat this problem multiple times).
Has anyone run into something like this? Any suggestions or ideas would be greatly appreciated.
Thanks!
Jisoo23
I'm an Informatica developer, not Cognos so please bear with me =)
I'm populating the kpi_value_stage table for CMM via a batch of Informatica processes with all sorts of metrics. All metrics get loaded and show up correctly on the web interface except for one. Here's the weird issue:
When I load the entire batch of metrics, that one doesn't show up on the web interface (although I see it's kpi_id and kpi_value plainly in the stage table). But when I load that metric separately from all the others, it shows up just fine on the web interface. Here's the kicker: when I rearrange my batch processes to make that metric's process the first one in line, ONLY THAT metric shows up on the web interface and almost all the others are zeroed out. This is a repeatable problem (I'm able to repeat this problem multiple times).
Has anyone run into something like this? Any suggestions or ideas would be greatly appreciated.
Thanks!
Jisoo23