Posts by Hikari • 111 points
2 posts
-
0
votes2
answers123
viewsA: Generate dynamic table in Excel from MSSQL with 8 million records
I used Powerpivot and with it I was able to load the original Star Schema, instead of using Hyperdenormalization as I was trying to do. But in the end I preferred to continue using Pentaho to…
-
1
votes2
answers123
viewsQ: Generate dynamic table in Excel from MSSQL with 8 million records
I have a table in MSSQL with currently 8 million records. I use Pentaho to analyze this data. I’m trying to use Excel as well. If I set it up to take the data and put it right on the dynamic table,…