CODEWITHSUNDEEP
sql-serverssas
Bee
Bee

Reputation: 341

Slicing and dicing data from a single table

We have a table with 20M+ records and growing in SQL Server.Our users want to access this table and slice and dice the data preferably using pivot tables.

What is the best way to go about this? We don't have any tools per se in-house except for SSAS. So thinking of create a cube off a single table and giving the users an excel linked file.

Is this a good approach? Are there any other options?

TIA, Bee

Update:

I apologize I forgot to add that I did try giving the users a Power Pivot file - but it showed up blank when they opened it (oops!). Plus they indicated that they prefer not to use power pivots.

We also have SSAS in-house but Multi-dimensional services. I was hoping to use SSAS tabular until I read that we cannot host both Tabular & MDS in one server. Hence the question.

Thanks again.

Upvotes: 0

Views: 967

Answers (1)

user2841795
user2841795

Reputation: 405

The excel option is the only best option. You can slice and dice in pivot table easily.

Upvotes: 0

Related Questions