Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Distinct Count
Problem now solved- Matt2004
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
looking for a front-end to microsoft-analysys Analysis Services
If your organisation uses MS-Office 2000+ and MS-Frontpage Server extensions, then you could use the Office Web Components as a "free" alternative. These allow the same functionality as Excel - including Web Based Pivot Charts. I have found the components to be much simpler and more...- Matt2004
- Post #15
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Distinct Count
Can anyone tell me if the Distinct Count aggregation works only with numeric data types? If this is the case, can anyone suggest how I can substitute an alpha-numeric value i.e. The Customer ID in a fact table, for a distinct numeric value. Thanks- Matt2004
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
