Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: OLAP Filtering Question

    I am not sure if this is an OLAP filtering or Where clause questions. Basically I have a dimension called playlog_artists. The dimension is as follows:

    Genre
    Artist
    Album
    Song

    The following query works great. It returns all the artists and how much they have been played for each year.

    select {([Time].[Year].Members)} on columns,
    [playlog_artists].[Artist] Members on rows
    from PlayLogTime

    How would I go about only showing artists that were part of the artists parent with the Genre name 'BLUES'?

    Basically I only want to show the artist that are in the Genre of blues.

    I would appreicate anyones help on this!!

    Thanks in advance,

    Marty

  2. #2
    Join Date
    Apr 2004
    Posts
    11

    Where clause

    Hi Marty

    select {([Time].[Year].Members)} on columns,
    [playlog_artists].[Artist] Members on rows
    from PlayLogTime
    Where [Genre].[BLUES]

    Ta
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •