Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Business Intelligence > Analysis Services filter width
Ask a questionAsk a question
Search Forums:
 

QuestionAnalysis Services filter width

  • Tuesday, January 30, 2007 10:17 AMJoos Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    I have built a dashboard page with Analysis Services filters on top of it. The filters all have a default value (mdx entered). But I have problems with the width of the entry field of the filters. It is possible to control this width by entering a value in the advanced filter options. However, this value is not being used when first opening the dashboard! It seems as if the length of the mdx specifying the default value controls the width! After pressing the "Apply Filters button, the width is set correctly. This looks like a bug to me...Is there any workaround? Setting the webpart width to a fixed value does not seem to be an option since scroll bars are added then.

    Regards

    Joos 

     

All Replies

  • Wednesday, March 21, 2007 1:29 PMRichChapler Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Did you hear anything on the width question?  I'm experiencing the same issue.

    Also, can you expand on the use of MDX to set default value... I'm at a loss re: how to set a default value that doesn't result in "unable to set one or more parameters" on the Excel Services web part.

     
  • Monday, April 02, 2007 7:14 AMJoos Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    I still have the same issue...

    But I am able to set a default value...in the default value box, you have to enter the mdx of the member and it works fine. Of course you have to connect the filter to your excel report. And you have to publish the parameter in the excel report...

     
  • Thursday, April 24, 2008 3:06 PMJoão Leitão Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    hi,

     

    Sorry my english, i will try do my best

     

    when you write the MDX to get the default value you need to use the "id" and not the "description" / "name" of the value you want. For example, if you need to, call by default, the month january of 2008 you write samething like this:

     

    [Date].[Hierarchy by Month].[Month].&[2008M01]  

     

    this way you are using the id of the january 2008 (2008M01).  If you use the MDX expression

     

    [Date].[Hierarchy by Month].[08JAN]   you will have the message "unable to set one or more parameters"

     

    If you don't understand i can use a dictionary

     

     
  • Monday, November 02, 2009 11:34 PMN Totall Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I am having the same issue with the filter width and have not found any other postings with either work-arounds or possible solutions.  Is anyone aware of a way to control the width of the Analysis Services filter drop-down list since the Advanced Filter Option to Control width in pixels. Specify an empty value or "0" for auto-size with the Filter Web Part provided clearly does not work.

    Maybe there is a new web part available?