I can understand developers picking up SSIS cause it ships with SQL server and is therefore considered 'free' . It may suffice if you have no comparison.

What I do not...

vidalst (10/22/2013)

---

Another vote for Pentaho... Whilst it isn't as polished as SSIS and lacks the nice SQL Server integration features (i.e. versioning, environment variables, reporting), it shines for non-SQL backends...

We ran similar performance tests, in this case between Pentaho (PDI ,also Java based) and SSIS. With SQL server SSIS is faster (about 10%), perhaps due to native OLE-DB connectivity....

Thanks..

I took the project to a Standard Edition server and processed - with translations - to the SE Analysis Database without any problems. When I open the database...

Did the T-sql take 5 seconds on the first execution? If not , then results may still be in the memory cache. The MDX may not have that advantage.

Thank you.. I found the guide you attached. Not looking for exact figures, but it is clear that the BI version is tremendously more expensive that the standard version....

I was really after a solution for not having to enter a display folder name for an additional language multiple times (the same number of measures with properties set to...

Sorry for reopening quite an old topics, but the Display Folder mechanism seems to be a bit of an afterthought. With translations added to the model and some 50 measures...

The features overview for SQL 2012 would indicate we could live with the standard edition, at least we will have to anyway. We may get customers to upgrade from...

I used my time dimension to create 2 different hierarchies, the first consisting of 4 level, the second 3 level. In both cases the toplevel is year. When...

Would that effectively work as a single-sign-on mechanism? We are accustomed to ask our customers to create an AD group , add users to this and allow this group access...

Suppose we do not have a sharepoint server to work with. Is there any alternative to access the cube data from within Excel?

Example data stored (in reality 200 fields)

Pkey OMG NUMV ...

Lowell (6/6/2012)

---

details are in order, i think.

are you really just running 'dir d:\runtime\SomeExec.exe' (directory!) or are you EXECUTING 'd:\runtime\SomeExec.exe'

The 'dir' version just made clear that xp_cmdshell is working

how do you...

Thanks Jan,

I new it was something small and obvious.. 😉