I'm using Microsoft SQL Server 2000 Analysis Services.
If I have a measure with Distinct Count aggregation (ie number of distinct customer numbers in a set of purchase transactions), and a time ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20168888.html
Scenario:
There are multilple courses taken by a student in a given year:
StudentID Course# Grade
12 101 A
13 103 F
14 ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20775983.html
Zones:
DatabasesDate Answered: 10/23/2003 Grade: A Views: 0
I built some cubes in analysis services, how do I provide access to the data in a "user friendly" form ? Access ? Crystal ? Some other tool -- we'd like to provide access to the data on our intrane...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20802871.html
hello there,
can you'll please explain in simple terms what these terms mean in analysis service.
Cube
Dimensions
Measures
also can anybody give me a small demo of a db which use AS
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2258...
I have a table describing accounts of a company. It looks like this:
ID Account_id Active Record_start_date Record_end_date
1 1 false 01/01/2007 10/01/2007
2 1 true 11/01/2007 31/12/2007...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2378...
I have setup an analysis services on SQL 2005 and have some questions.
1. Using the Analysis Service templates - Adventure Works Enterprise Edition, I have created the Mesaure, dimensions and ti...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2385...
Hello all,
We are using SQL Server 2000 Enterprise Edition as our OLAP server. It has been performing very well until just recently, when I have been unable to connect to the production server ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21070776.html
Hi..
is there anyone who knows how to calculate correlation without using the correlation function??
I have some 2 set of data points to compare..using correlation but I don't have Analysis Ser...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21241521.html
Will there be an end client tool(both desktop version and the one on Report Manager) to create reports based on Cubes in analysis services 2005 and represent to customers so they can slice and dice...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21412294.html
Hi,
I have a cube with a measure of 'Duration' (this is a bigInt to represent milliseconds) and relates to hours of operation for a device. the Fact table could have many instances of data for a g...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2286...
