i'll post my conclusions and questions for the community in another post.

thx Phil that's a great idea.    i'll circle back here once i've stood up a poc.

the simple answer is yes.   and we even found one record with costs in it that is completely blocked from both inside netsuite (suite ql) and externally (odbc driver).   oracle...

thx frederico.   I'll focus on utf's.  and define my connectors as utf's.   and tell her all files must be utf.   i think all but one of her files is currently...

it seems to me utf is strategic if (like us) you expect some extended character set data from europe etc.

if thats a decent idea, does anybody know what the general...

sorry for the delay.    Frederico are you saying that if i found myself changing the conn mgrs from code pg 65001 (utf-8) to 1252 Ansi Latin, that i was...

• This reply was modified 9 months, 2 weeks ago by stan.

db2ls in the command prompt doesnt give me anything.  i get an error saying its not recognized as an internal or external command, operable program or batch file.  i ran...

• This reply was modified 10 months, 2 weeks ago by stan.
• This reply was modified 10 months, 2 weeks ago by stan.
• This reply was modified 10 months, 2 weeks ago by stan.

thx Phil, I like that solution.   And will use it and mark your post as an answer here in a second.

an ugly solution i got to work while experimenting went...

i can confirm today that CData's odbc driver does indeed show previously hidden netsuite fields once they start getting used (ie arent all null).

There is what sounds like a choice...

• This reply was modified 10 months, 2 weeks ago by stan.

i think somewhat consistent comments are starting to come in from CData (the competitor) and Oracle Netsuite.

CData clarified that their odbc driver taps into netsuite's suite ql API.   and there...

yes.

the 1st thing i tried was to add a dataset (last dataset) for sample size, plumb it to a param and then pass the param to the core dataset for...

thx pietlinden and sorry for the delay as i was travelling and temporarily distracted.

i am convinced of what the problem was and think maybe i now understand what MS's bizarre...

• This reply was modified 10 months, 3 weeks ago by stan.
• This reply was modified 10 months, 2 weeks ago by stan.

here is one of the posts i see on this subject.   its hard for me to make the leap between a division and sql being unable to read a (next)...

• This reply was modified 10 months, 4 weeks ago by stan.
• This reply was modified 10 months, 4 weeks ago by stan.

thx jason and jeff.  I should have mentioned also that someone in this forum suggested power point waking up a pbi dashboard every so often.

i'm reluctant on pbi and ssrs...

• This reply was modified 11 months ago by stan.