The referenced data item ... is not found in the query

[adik]

Hi all,

I'm in need of your help. In a crosstab I have measure Balances, and dimension Customer and Time
for both customer and time dimension i constructed a tree prompt.
ths issue i'm facing is with the customers dimension, whenever i select from the tree prompt the All member and any other child member i get the following error:

The referenced data item 'Balances' is not found in the query 'Deposits_tab0_sub'

Deposits is the name of the query attached to the crosstab.
Selecting only All, or only submembers of All member works fine, when selecting All with any submember is throws the error.

[adik]

i did some more testing and the error actually comes from a calculated measure that is based on Balances measure
the calculated measure has the following formula total([Balances]*[Rate])/total([Balances])
this is what is causing the issue.

any advise?

[blom0344]

A longshot: Did you try to associate the [balances]  item with the crosstab? This is done through the properties of the crosstab header

[adik]

hi,
tried that and it didn't work

[adik]

apparently this seems to be a Cognos 8 issue, we upgraded to 10.2 and in this version it works without any changes