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.
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