Aged Inventory query

[akvaid]

Hi All,

I am trying to put an aged inventory in different buckets. For example < 3 months, <  9 months, 6 months and 12 months.

The formula doesn't give any error when i validate it. But, it gives me an sql error when I run the page.I.e.

  An error occurred while performing operation 'sqlOpenResult' status='-237'.

and my formula is

CASE
WHEN
(([DW - Retailer Inventory (Products)].[Last Sale Dates].[Date]<_add_days(current_date,-180)) or ([DW - Retailer Inventory (Products)].[Retailer Inventory (Products)].[Last Sale Date] >_add_days (current_date ,-90)) AND ([DW - Retailer Inventory (Products)].[Last Sale Dates].[Date] is null)) AND (([DW - Retailer Inventory (Products)].[Retailer Inventory (Products)].[Last Purchase Date] <_add_days ( current_date,-180)) or  ([DW - Retailer Inventory (Products)].[Retailer Inventory (Products)].[Last Purchase Date] >_add_days ( current_date,-90)) AND ([DW - Retailer Inventory (Products)].[Retailer Inventory (Products)].[Last Purchase Date] is null)) AND
([DW - Retailer Inventory (Products)].[Products].[SRP2 - Product Class Code] in('GM'))

THEN
(total([Quantity in Stock] for [Parent ID],[Product ID] )
*
total([Retailer Net Price $CAD (Current)] for [Parent ID],[Product ID]))

else (0)
END


I am trying to create aged inventory for 6 months in this query. Please advise. Thank you.

[BigChris]

A quick google search suggests that the server you're running Cognos on is running out of Temp space:

https://stackoverflow.com/questions/39106308/cognos-error-sqlopenresult-status-237