Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
SQL Server GroupsView
SQL Server Ce
SQL Server Clients
SQL Server Connect
SQL Server Datamining
SQL Server Datawarehouse
SQL Server Dts
SQL Server Fulltext
SQL Server Msde
SQL Server Olap
SQL Server Replication
SQL Server Reportingsvcs
SQL Server Security
SQL Server Server
SQL Server Setup
SQL Server Tools
SQL Server Clustering
SQL Server Programming
SQL Server Xml
SQL Server Newusers
SQL Server Integrationsvcs

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

Microsoft SQL Server Olap
 Ask A New Question    

Analysis Services and relational engine on same server
We have a server with Analysis Services 2005 SP2 and the SQL Server 2005 SP2 Enterprise. AS processing is failing and performance counters point to memory issues. This version of AS can use at most... on 17-Nov-09
Cannot Connect to the SSAS servies
Hi, I am Trying to connect to the SSAS from my PC, But i was able to connect to the port of SSAS and the Port number named 2383 is listening to the telnet IP address 2383, then also i was not able to... on 17-Nov-09
Calculate across future periods
Hi all I have 6 years of finance data that relates to a project, the fin data contains future years forecasts ie. Year 1 to 6 I want to calculate the sum of the forecasts for year 1 to 6. Forgive m... on 17-Nov-09
More than one slices from same dimension in Where clause not working
SELECT NON EMPTY {TopCount({Crossjoin({[Measures].[Average Sales Amount]},{[Date].[Fiscal].[(All)].AllMembers})},20,[Measures].[Average Sales Amount])} ON COLUMNS, NON EMPTY {hierarchize(TopCount({[G... on 17-Nov-09
Duplicate Attribute Key Found in SSAS
I am fairly new to SSAS 2008, and am having some challenges with duplicates in my dimensions. When I was working with just a customer master table, the dimension processed fine. When I linked in an... on 16-Nov-09
Problem after adding unary operator to financial cube
I have a financial cube with 6 dimensions: Date, Account, Version, Database, Department and Branch. Before I add a unary operator to the Account dimension, using the Business Intelligence wizard, I... on 16-Nov-09
"Show properties in tooltip" in Excel cant be checked
Hi, I want to use properties as tooltips in Excel2007/SSAS2005 sp3. I try "Pivot Table Options/Display/Show properties in tooltips" in Excel but the field is locked and unchecked. But I can use and ... on 13-Nov-09