May 12, 2009 at 1:58 pm
Hi,
Is there a way to import a local cube created from Excel into an Analysis Services (olap) database? I have a .cub and .oqy file create from Excel and need this cube to run on a server. Is that possible?
The short story is a sql table was created in SQL Server by our analysis team with the intention of exporting this to Excel for our accounting department. The problem is the file contained roughly 1 million records and was slow just to open not to mention trying to create a pivot table. The problem then came to me. My first thought was to go about creating a cube from the sql table but it's a flat table and there would be a lot of work involved trying to break out dimensions.
This brings you to where I am now. My last thought (down and dirty solution) was to use SQL Server as a datasource in Excel, create a local cube and then import that into Analysis Services to run on the server.
Let me know if you need more information or know of an easier way to accomplish this.
Thank you for any replies.
September 5, 2010 at 4:35 pm
Hi there... although I am not sure to understand all the details of your problem, I find it "optimistic" to use Excel to load 1 million rows whether using aggregates or not.
Personally, I would probably look into splitting the dimensions with some TSQL (or SSIS if easier to you) and work with Excel on much smaller tables...
Cheers
Eric
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply