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!
-
How to filter on String properties ?
double quotes gives Syntax Error, while single quote gives Invalid Token Error (I'm using MDXSample application). If I try [Measures].prop1 <> AAA, I've got some results, including the properties whose value is AAA... Any idea ?- jlmuller
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
How to filter on String properties ?
Hello, I need to filter members on one of their properties. I can easily do this if the property is of type numeric, but I'm unable to filter on string properties. The following expression does work : FILTER ([Customer].[Business Id].members, [Measures].prop2 = 1) The following expression...- jlmuller
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Defining Alerts in Analysis Services
Hello everybody, Is it possible to define "alerters" in MS Analysis Services, as it is in Business Objects and other OLAP tools ? e.g, is there a mean to define a criteria like "if the annual amount spent by a customer is 20% above the average customer amount, send an e-mail to...- jlmuller
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
