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)

from IP address

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 :

WHEN coterimp IN ('001','002') THEN 'NEW YORK'
FROM mytable

Which gives as a result :
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   

  1. Just tried it in and Reject works - Cameron Lackpour on Apr 23, 2012, 1:26 PM
    1. Bad feeling - Sroux on Apr 23, 2012, 2:57 PM
 Copyright © 1999-2016 Network54. All rights reserved.   Terms of Use   Privacy Statement  

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.