We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed [...]
Answer Question | February 16, 2011 2:43 PM
SQL Server data warehousing/business intelligence, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
I am running Sage M500 – I need to be able to link my project files to my M500/SQL data and vice versa. I see lots of information on functionality but only consultants that want to set it up! HELP Me do this for free and save the day!
Answer Question | July 10, 2008 2:03 PM
MAS 500, Microsoft Project, Sage Software, SQL Server data warehousing/business intelligence
I am designing a data warehouse database to be implemented in SQL Server. There are a number of variable length character fields for which I intend to use the varchar field type. On previous data warehouse implementations in Oracle, I frequently set the length for the varchar fields higher than the current data length. I [...]
Answer Question | April 9, 2008 11:14 PM
SQL Server data warehousing/business intelligence
Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?
Answer Question | April 9, 2008 10:38 PM
SQL Server Analysis Services, SQL Server data warehousing/business intelligence, SSAS