Acierno1
Technical User
- May 29, 2014
- 1
I am attempted to whittle down my results in a Pareto Chart I have created in Cognos Workspace Advanced.
I get the following error however after validating my Data Item Expression:
OP-ERR-0060 An invalid number of operands was specified for the operator 'topcount' in the dataItem 'dataItem="Number of incidents1"
This is the expression I have written that has the problem.
rank(topcount([Incident Management].[Work Related Incident Information].[Part_Of_Body]),5,tuple([Incident Management].[Work Related Incident Information].[Cause_Of_Injury]))
Also worth noting, I am using Workspace advanced 10.2.1 through a webportal with data hosted off site by a 3rd party.
I have already ranked the data, now all I simply need to do is isolate the top 5, but it proving to be much harder to do than in Microsoft Report Builder.
I get the following error however after validating my Data Item Expression:
OP-ERR-0060 An invalid number of operands was specified for the operator 'topcount' in the dataItem 'dataItem="Number of incidents1"
This is the expression I have written that has the problem.
rank(topcount([Incident Management].[Work Related Incident Information].[Part_Of_Body]),5,tuple([Incident Management].[Work Related Incident Information].[Cause_Of_Injury]))
Also worth noting, I am using Workspace advanced 10.2.1 through a webportal with data hosted off site by a 3rd party.
I have already ranked the data, now all I simply need to do is isolate the top 5, but it proving to be much harder to do than in Microsoft Report Builder.