Description:
Microsoft SQL Server newsgroup.
|
|
|
Connecting to OLAP Cube
|
| |
Please help me understand... I am using Radatsoft cube browser control in an ASP.net web application, my web server is in the DMZ and my SQL(OLAP) server is behind the firewall... when connecting I provide a connection string that uses a UserName/Password pair... the User is a Windows users configured on the SQL (OLAP) box and... more »
|
|
|
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 3GB memory. We are installing additional memory and planning to turn on AWE to see if the relational engine will be able to take advantage of the extra memory and AS... more »
|
|
|
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 connect to the SSAS Server, I am getting the below specified error message. ============================== =====... more »
|
|
|
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 my mental block, how can I walk the time dimension to sum my forecast facts for the next 6 years. It has to be a calc measure as it is surfaced in an olap browser.... more »
|
|
|
More than one slices from same dimension in Where clause not working
|
| |
SELECT NON EMPTY {TopCount({Crossjoin({[Measure s].[Average Sales Amount]},{[Date].[Fiscal].[(Al l)].AllMembers})},20,[Measures ].[Average Sales Amount])} ON COLUMNS, NON EMPTY {hierarchize(TopCount({[Geogra phy].[Geography]. [(All)].AllMembers},20,[Measur es].[Average Sales Amount]))} ON ROWS FROM "Adventure Works"... more »
|
|
|
Duplicate Attribute Key Found in SSAS
|
| |
I'm 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 address table, I am now getting duplication errors. The customer master table (CustMstr) has the... more »
|
|
|
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 am able to browse the cube and see the various database, version, branch and department members. After running the wizard and specifying a unary operator column, no matter... more »
|
|
|
"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 see the properties as columns using "Show properties in report" (rightclick on column). Is there a server/AS property for enabling "properties in tooltips"? I'm... more »
|
|
|
Why is my more powerful server slower than my laptop (same database, same query)?
|
| |
I have an SSAS database and when I run a query on it on my laptop, it returns in about 1 second. When I run the exact same query on the same database on the server it takes about 30 seconds. I'd like to know where the best places to look for a performance bottleneck are. The laptop is my development machine and typically has my email, VS 2008,... more »
|
|
|
|
