Is there a way to reverse engineer a cube back into SSAS? Microsoft sent me some demo's many months back but all I had was the .ABF SSAS Cube backup file and I was hoping to see how they designed some of the features inside SSAS - (bids).
Anybody using Cognos and have comments on it? Our shop is using SSIS, SSAS and browsing cubes with Excel 2007. But Cognos tool looks like it may be easier for our users.
I'm required to implement address standardization in my data warehouse. Daily a SQL Server 2005 SSIS package processes a excel file which has customers information. I'm looking for a web service which would provide standard addresses. I really dont know if using web service is ...
I have a design question . I got the requirement of 2 TB starting for enterprise dataware house in my project. I want to implement next generation warehousing technique. So want to have a near line storage layer in the design.