robsuttonjr
MIS
The following is an mdx statement that I would like to run via sql server query analyzer. Or more specifically I am trying to run this via odbc so do I use the sql server driver ? What database connection is it going to use? I have only queried from sql server tables not cubes. So how to I query cubes from odbc?
SELECT { [Time].[454].[All Time] } ON COLUMNS , { [Effort].[All Effort] } ON ROWS FROM [Offer Analysis] WHERE ( [Items].[All Items].[JEWELRY].[WOMENS JEWELRY].[WOMENS JEWELRY: BAND RINGS].[34069 - ANIMAL KINGDOM RING], [Measures].[Return Dollars], [Offer].[All Offers].[SUNDANCE CATALOG].[JEWELRY].[B2J] )
SELECT { [Time].[454].[All Time] } ON COLUMNS , { [Effort].[All Effort] } ON ROWS FROM [Offer Analysis] WHERE ( [Items].[All Items].[JEWELRY].[WOMENS JEWELRY].[WOMENS JEWELRY: BAND RINGS].[34069 - ANIMAL KINGDOM RING], [Measures].[Return Dollars], [Offer].[All Offers].[SUNDANCE CATALOG].[JEWELRY].[B2J] )