Not needed in 11.1.2.1

For giggles, I created a table, dData, that looks like this (in SQL Server, if it matters):
Scenario Market Product Measures Year Data
-------- ------ ------- -------- ---- ----
Actual New York 100-10 Sales Jan 10
Budget New York 100-10 Sales Jan 5

I created a SQL Load Rule that goes to MVFEDITWWW, aka, Sample.Basic with a simple SELECT * from dData.

I loaded it without any kind of record reject and got the following message:
Reading Rule SQL Information For Database [Basic]
Reading Rules From Rule Object For Database [Basic]
Cannot read SQL driver name for [Hyperion Client Sample] from [ODBC.INI]
Cannot read SQL driver name for [Hyperion BIplus Client Sample1] from [ODBC.INI]
Cannot read SQL driver name for [Hyperion BIplus Client Sample2] from [ODBC.INI]
Cannot read SQL driver name for [Hyperion DDS Sample] from [ODBC.INI]
Connection String is generated
Connection String is [DSN=SampleBasicData;UID=...;PWD=...;]
SELECT Statement [SELECT * from dData] is generated
Connection has been established
Starting to execute query
Finished executing query, and started to fetch records
Connection With SQL Database Server is Established
Parallel dataload enabled: [1] block prepare threads, [1] block write threads.
Finished fetching data
SQL Connection is Freed
Data Load Updated [2] cells
Data Load Elapsed Time for [SQL] with [dData.rul] : [0.223] seconds
Database import completed ['Sample'.'Basic']
Output columns prepared: [0]

The only line that counts is the "Data Load Updated [2] cells".

I then put a record reject on Scenario where the value equals "Budget", saved it, cleared out Sample.Basic, and reloaded with the following result:
Reading Rule SQL Information For Database [Basic]
Reading Rules From Rule Object For Database [Basic]
Cannot read SQL driver name for [Hyperion Client Sample] from [ODBC.INI]
Cannot read SQL driver name for [Hyperion BIplus Client Sample1] from [ODBC.INI]
Cannot read SQL driver name for [Hyperion BIplus Client Sample2] from [ODBC.INI]
Cannot read SQL driver name for [Hyperion DDS Sample] from [ODBC.INI]
Connection String is generated
Connection String is [DSN=SampleBasicData;UID=...;PWD=...;]
SELECT Statement [SELECT * from dData] is generated
Connection has been established
Starting to execute query
Finished executing query, and started to fetch records
Connection With SQL Database Server is Established
Parallel dataload enabled: [1] block prepare threads, [1] block write threads.
Finished fetching data
SQL Connection is Freed
Data Load Updated [1] cells
Data Load Elapsed Time for [SQL] with [dData.rul] : [0.703] seconds
Database import completed ['Sample'.'Basic']
Output columns prepared: [0]

The only line that counts is "Data Load Updated [1] cells". It's rejecting the Budget record.

I took a look at my Essbase.cfg file and did NOT see:
SQLFETCHERRORPOPUP TRUE

So, I don't know what to say about 11.1.1.3 -- for sure it works in 11.1.2.1.

Sebastien, I am selecting the Scenario column and then navigating to the Record->Reject menu selection.

Regards,

Cameron Lackpour