search table error: [2724] Olap temporary data size exceeded 31/32 bit limit"

[Former Member]

I Have a calculation view which is based on other calculation views and joins to bring material Accounts data from different vendors(all joins have 1-1 maping with target). in the final view I have a calculated column as "Formatted_MATERIAL"(Material numbers without any leading zeros, used Ltrim() to remove leading zeros.) Now, when I m searching Formatted material equal to some specific number its showing read error(heading). if I m searching for some range of material its giving results. for EX: if I serach for material(500098). its present in following query results
select "Formatted_MATERIAL"
FROM "_SYS_BIC"."CA_REPORTS_001_VK"
where "Formatted_MATERIAL" between 5000000 and 6000000
order by "Formatted_MATERIAL" but no results for

select "Formatted_MATERIAL"
FROM "_SYS_BIC"."CA_REPORTS_001_VK"
where "Formatted_MATERIAL" = 5000098

[sastrylssv]

We too facing the similar issue while running the procedure ?

.. any solution from experts ?