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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtros en MDX

Status
Not open for further replies.
5621

5621

Programmer
Joined
Nov 16, 2001
Messages
8
Location
CL
Amigos:

Necesito saber como puedo agregar filtros a una sentencia MDX, por ejemplo

Ventas de todas las personas > 20 años, sexo=F, de un pais determinado, y de un producto en especial

Muchas gracias

Karin
 
Sort by date Sort by votes
igual que en SQL, utiliza la clausula WHERE
 
Upvote 0 Downvote
perdoname por mi poble espanol pero usted no puede usar sentencia como '<20' en la clausula 'WHERE'

Para hacerlo usted tiene que usar funcion 'Filter' Issahar
senior software engineer

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

woezelmann
  • Locked
  • Question Question
MDX Sum values of lower level
Replies
1
Views
872
blom0344
blom0344
PerlIsGood
  • Locked
  • Question Question
MDX Dynamic Set not showing up in cube
Replies
0
Views
240
PerlIsGood
PerlIsGood
DontStealMyFish
  • Locked
  • Question Question
Network application cant use ODBC entries
Replies
0
Views
751
DontStealMyFish
DontStealMyFish
amypham
  • Locked
  • Question Question
MDX Query, binning results together
Replies
0
Views
216
amypham
amypham
Jony77
  • Locked
  • Question Question
MDX Query
Replies
0
Views
234
Jony77
Jony77

Part and Inventory Search

Sponsor

Back
Top