This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Here's an example

April 23 2012 at 12:16 PM
Score 5.0 (1 person)

sroux 
from IP address 213.190.76.3


Response to sql interface reject not working properly

Hi, I'm sorry for the silence as I've been out for a week. I could see that this thread raised quite an interest, so many thanks!

Here below a detailed description of my issue :

My sql interface DLR includes here a simple SQL query for Sample Basic db :

SELECT DISTINCT
CASE
WHEN coterimp IN ('001','002') THEN 'NEW YORK'
ELSE 'NA'
END,
1
FROM mytable

Which gives as a result :
NEW YORK 1
NA 1

Now in my DLR I specify NA as a reject (Reject = String NA Equal) as I want to rejet Non Applicable datarows.
Here dataload header is set as : jan,sales,"100-10",Actual

However this is the error I have as if my reject was not taken into account...
\\ Member NA Not Found In Database
NA 1

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Just tried it in 11.1.2.1 and Reject works - Cameron Lackpour on Apr 23, 2012, 1:26 PM
    1. Bad feeling - Sroux on Apr 23, 2012, 2:57 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.