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

Invalid coercion from 'level' to 'value'

Started by ratnalein, 06 Nov 2013 10:58:08 AM

Previous topic - Next topic

ratnalein

Hallo everyone,

My first query looks like this -Customer-:
set(member([Customer]))

My second query looks like this -Dates-:
total(currentMeasure within set [Dates])

My problem is in my third query:
topCount ([Customer];10;[Dates])

The error occures:
invalid coercion from 'level' to 'value' for '[__ns_0].[Customer_dim][Customer_dim].[level1]' in 'set(member([__ns_0].[Customer_dim].[Customer_dim].[level1]))'

Can anybody help me, what have I dont wrong?

Thank you..

Regards,

Ratna

Francis aka khayman

try this:

topCount (set(member([Customer]));10;[Dates])


ratnalein