Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Reporting Services by Paul Turley, Todd Bryant, James Counihan, Dave DuVarney; ISBN: 9780764584978
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 14th, 2006, 09:50 AM
Registered User
 
Join Date: Apr 2006
Location: BUCHAREST, , Romania.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default MDX filters an Parameters

Hi,

 i try to create a dataset in RS 2005 with MDX Query Designer. I don't have experience with MDX language and i try to use MDX filters and parameters, but the MDX filters and parameters pane don't appear in the MDX Query Designer window. How to resolve this problem?

In 'Professional SQL Server Reporting Services 2005' book edited by WROX, Paul Turley & comp use a visual method to define MDX filters and parameters, based on Filter and parameters panel.
In Books Online I don't find anything about this method.
Thanks,
GabiP




  #2 (permalink)  
Old April 24th, 2006, 11:15 AM
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

GabiP,

Which version of Analysis Services are you using? Reporting Services 2005 does not support the visual query designer for Analysis Services 2000. If you are using Analysis Services 2000, you will have to manually enter the MDX and there are other posts that will talk about using Parameters.

Dave

  #3 (permalink)  
Old May 16th, 2006, 08:31 AM
Registered User
 
Join Date: Apr 2006
Location: BUCHAREST, , Romania.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
i use Analysis Services 2000 and that's the problem. If use AS 2005 the filter and parameters panel appear, and everything is normal.
thanks for answer

GabiP



Similar Threads
Thread Thread Starter Forum Replies Last Post
MDX lem SQL Server 2005 1 June 6th, 2008 03:40 PM
Parameters / Filters in a datatable AussieRay VB Databases Basics 3 February 22nd, 2007 10:26 AM
Recursive Relationships with MDX Dima20 BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 October 6th, 2006 04:45 AM
Parameters / Filters s15199d Reporting Services 0 March 23rd, 2006 12:08 PM
MDX - where clause with parameters?? boson SQL Language 3 August 24th, 2004 05:44 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.