Earlier quoted context omitted.
Hey, I clicked through, read the tutorial, got excited about your examples.. tried to download and found out it was windows only! I would have totally evaluated it further if there were an os x/linux option.
Thanks for checking it out! As we're targeting Tableau users so eventually we will release an OS X version.
Eve Version 0
191–195 of 195 posts
Re: Eve Version 0
#192Re: Eve Version 0
#193Earlier quoted context omitted.
> VBA also does SQL operations on Excel tables, but that's, well, worse. Are you sure about that? Afaik it doesn't but I may be mistaken.
Yeah, it could be done using the ADODB interface on data in the workbook itself rather than from some actual DB. See this link for an example: http://stackoverflow.com/a/26678696/1502035 That being said, when I encountered someone doing this I was pretty surprised as well.
Re: Eve Version 0
#194Earlier quoted context omitted.
The PowerPivot engine itself I imagine is in unmanaged code, but the code that just writes datasets and whatnot to the model is (from what I've heard)managed code, and indeed you can decmpile the libraries and see all sorts of things, I've only looked around for about 10 minutes or so. And I had just read on some obscure thread that someone had successfully found the undocumented API call to write to the model, which…
Right, makes sense, I'll try and check out what's available then. :) By writing to the model, you mean programmatically adding new measures or the like? My interest is in programmatically querying models using DAX, though to this end I'd also look to look in the direction of Microsoft's DirectQuery mode in SQL Server which supposedly did DAX-to-SQL conversion. If one could use such a conversion plus MDX to start quer…
Re: Eve Version 0
#195Earlier quoted context omitted.
This is a really helpful perspective. For example, I've started referring to myself as a "user" of Python rather than a programmer.
Care to explain a bit your choice of word ? Funny how I often heard about the user / programmer dichotomy. Always just felt like a user in the know.
I think it's useful to distinguish between the two groups, because not only do they have different skill sets, but they have different motivations. For example I will never directly be evaluated on the performance or style of my code in the way a programmer might be - only the paper that code helped me write.