Sign in
|
Help
Sign In
Home
Blogs
Forums
Wikis
Groups
Blogs
Tags
Analysis Services Tuning MDX SQL Server 2008
BI Architecture
BI Events
BI Exams
BI Methodology
BI news
BI Resort
Business Intelligence
CBIP
cep
Certifications
Conferences
cube
Cumulative packages
Excel 2010
Excel Source
For Each Loop
Foreach Loop
SharePoint
sql 2008
SQL Server
SSAS
SSIS
StepByStep
TDWI
View more
Blogs
RSS Syndication
Opml
Blogs on this Site
Sort By:
Most Recent
|
Most Viewed
|
Most Commented
Sharepoint forms Authentication with Excel Services
Well everything was well working with AD then change to forms authentication , ""Unable to delegate credentials. Please modify Excel Services configuration to be consistent with Windows SharePoint Server [User: fbaMembers:xxxxx].""...
Posted to
André Lage
by
Andre lage
on 01-27-2010
Filed under:
SharePoint
All you need to know about Microsoft Business Intelligence
The recordings from Rafal Lukawiecki BI session in Sweden are live on Channel 9: Session 1
Posted to
João Bilhim
by
joaobi
on 01-07-2010
Filed under:
Business Intelligence
,
SQL Server
BI Tools - First Look to Excel 2010
Create Dashboards never been so easy ... the new version of Excel 2010 (Beta) is really amazing. Exploration of a multidimensional cube has never been so intuitive and simple like it is now. The image below shows a simple dashboard that I made in this...
Posted to
BI Blog
by
PedroCGD
on 12-19-2009
Filed under:
Slicers
,
Excel 2010
,
Sparklines
Office 2010 Beta Developer Training Kit
The Office 2010 Beta Developer Training Kit features, among other interesting content, a "Developing BI Applications" set if videos, presentations and labs. Thhe kit is available at: http://www.microsoft.com/downloads/details.aspx?displaylang...
Posted to
João Bilhim
by
joaobi
on 12-16-2009
Filed under:
Business Intelligence
,
SQL Server
SQL Server 2008 Integration Services Metadata Toolkit
The SQL Server Metadata Toolkit has been updated to SQL Server 2008. You cane get it at: http://sqlmetadata.codeplex.com/
Posted to
João Bilhim
by
joaobi
on 12-11-2009
Filed under:
Business Intelligence
,
SQL Server
StepByStep - SSIS Calling a WebService with Web Service Task
Dear friends, I'm back again and with a new StepByStep paper. This paper focus on a way to call a Web Service from a SSIS package. There is lot of issues relating to this subject and I decided to publish about it... I hope this can help you. Please...
Posted to
BI Blog
by
PedroCGD
on 11-30-2009
Filed under:
SSIS
,
StepByStep
,
XML Task
,
Web Service Task
Predictable Changes with Multiple Version Overlays
There is a technique in Kimball's "Data Warehouse toolkit 2nd" book that is suggested for Predictable Changes with Multiple Version Overlays situations. It was a bit intangible for me what Kimball means for that solution, but I could understand...
Posted to
BI Solutions
by
Amin
on 11-13-2009
Filed under:
SCD Type 2
,
SCD
,
Kimball
BI Certifications - CBIP/TDWI Certifications done!
I started writing this post on the return trip to Portugal. It was a very enriching and experience trip, which I reached one more objective I had in mind for more than two years. I passed the four exams and got the specialization in Business Analytics...
Posted to
BI Blog
by
PedroCGD
on 11-13-2009
Filed under:
CBIP
,
TDWI
,
Certifications
,
BI Exams
SQL Server 2008 Star Join Paper
A paper about star joins in relational Datawarehousing scenarios with SQL Server 2008 called "Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries" has been recently added to the MSDN Library: http://msdn.microsoft...
Posted to
João Bilhim
by
joaobi
on 09-09-2009
Filed under:
Business Intelligence
,
SQL Server
BI Tools - SQL Server 2008 R2 CTP version Announcement
Today I finally received an e-mail from Microsoft announcing the release of the CTP version (Community Technology Preview) for SQL 2008 R2 ... and I'm really excited to take the first look and for sure tomorrow I’ll download it ... I'm still...
Posted to
BI Blog
by
PedroCGD
on 08-11-2009
Filed under:
SQL 2008 2008 R2
,
BI news
DevDays DAT302, Tuning & understanding MDX Query Performance in SQL Server 2008 Analysis Services
A little bit late I know , but now in english,. Thanks for the "heads up" Pedro. Anyway, here it is, all the materials I've used on the DevDays session.Notes of interest: Report/Dashboard that shows the mdx trace log, properly organized...
Posted to
Rui Quintino BI
by
Rui Quintino
on 08-07-2009
Filed under:
Analysis Services Tuning MDX SQL Server 2008
StepByStep - SSIS Extract data from multiple Excel worksheets
Scenario Every month a company receive customers data from an excel file to extract and load data into company data warehouse. In brief, is required to extract data from a single excel file with multiple worksheets with same schema into a single destination...
Posted to
BI Blog
by
PedroCGD
on 08-06-2009
Filed under:
SSIS
,
Scrip Component Source
,
Excel Source
,
Foreach Loop
,
StepByStep
SQL2008 - Cumulative Updates
Microsoft released last week new updates for the recent SQL Server 2008 edition. Check links below and don't forget to maintain your SQL Server updated. Cumulative Update #3 for SQL Server 2008 SP1 Cumulative Update #6 for SQL Server 2008 RTM regards...
Posted to
BI Blog
by
PedroCGD
on 07-26-2009
Filed under:
SQL 2008
,
Cumulative packages
Webcasts on SQL Server 2008 relational data warehousing
Joe Longtin has several interesting webcasts on the relational DW features in SQL Server 2008. Check it out at: http://channel9.msdn.com/posts/Joe+Longtin/
Posted to
João Bilhim
by
joaobi
on 07-06-2009
Filed under:
Business Intelligence
,
SQL Server
Financial Planner Accelerator aka source code for Planning available
Microsoft is releasing to customers and partners the sourcecode and project files derived from PerformancePoint Server 2007 Planning. More information on: http://www.microsoft.com/bi/partners/default.aspx http://blogs.msdn.com/bi/archive/2009/06/18/financial...
Posted to
João Bilhim
by
joaobi
on 06-19-2009
Filed under:
Business Intelligence
1
2
Next >