Thursday, 18 June 2009
Sharepoint Saturday
Posted by Kristen Hodges at 12:15 pm 0 comments
Labels: Sharepoint 2007 (MOSS)
Can Dynamics CPM pick up where PerformancePoint left off?
Can Dynamics CPM pick up where PerformancePoint left off? And how does all of this fit in with SSRS Report Builder and Project Gemini, a key part of Microsoft's self-service BI drive? When you say things like "Microsoft Forecaster is a budgeting and planning application that allows companies to build budgets based on specific objectives", one has to wonder!
And "Enterprise Reporting is designed for sophisticated group reporting and consolidation needs, and includes advanced multi-dimensional consolidations, eliminations and multicurrency capabilities. Enterprise Reporting’s planning environment is easily customizable to fit diverse budgeting and forecasting needs across all industries and organizations. Enterprise Reporting provides strong analytical modules to make it extremely easy to create new ad-hoc reports on the fly"
Seriously? That's quite a bundle of tasks. Enquiring minds want to know more!
Posted by Kristen Hodges at 10:19 am 1 comments
Labels: Dynamics, PerformancePoint, Planning
Thursday, 11 June 2009
PerformancePoint Planning: Bug in the bsp_DI_ValidateLabelTable Proc
Somewhat irrelevant due to shut down of PerformancePoint Planning but it's an issue I encountered so I will record it for posterity and future generations (*snigger*).
Application: PPSRootModelSite: PPS_PlanningModel: PPS
Posted by Kristen Hodges at 6:12 pm 0 comments
Labels: PerformancePoint, Planning
SSIS: Write to the Output Window from a Script Task
Want to write to the Output window during execution of a script task?
DTS.Events.FireInformation(1,"YOUR TITLE","Your Message","",0, False)
Posted by Kristen Hodges at 5:29 pm 0 comments
Labels: SSIS
SSIS: Error when executing a data flow using the OLEDB SSAS 9.0 Provider
I found an interesting problem today.
"Error code = 0x80040E05, External Code = 0x00000000:."
Posted by Kristen Hodges at 3:42 pm 0 comments
Labels: Analysis Services (SSAS), Bug, Data-Mining, SSIS
Wednesday, 10 June 2009
SQL SSIS: Vote for data viewer suggestion
Vote for a feature request on Microsoft Connect for greater flexibility over when and where an SSIS data viewer is shown.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=465835
Posted by Kristen Hodges at 5:24 pm 0 comments
Tuesday, 9 June 2009
SQL: Retrieving the Metadata for a Query
Sometimes you need to know what the metadata for a query looks like before runtime. This is particularly relevant with SSIS.
Posted by Kristen Hodges at 4:50 pm 0 comments
Wednesday, 3 June 2009
SharePoint Magazine - Part 3 Out Now!
Posted by Kristen Hodges at 12:30 pm 0 comments
Labels: Monitoring and Analysing, PerformancePoint
SQL 2005: Scalar Resultsets and SSIS Variables
Posted by Kristen Hodges at 11:21 am 0 comments