locked
How to search through all dimensions at once looking for appropriate member RRS feed

  • Question

  • Hi, I try to mimick a qlikview functionality which is about searching a member without the need to choose a dimension, so I should be able to search through all dimensions.

    I googled around a bit but could not find a resolution yet -  I would like to use it in reporting services

    Sunday, February 10, 2013 6:38 PM

Answers

  • This is a feature of an Excel add-in I wrote which enhances PivotTables in Excel which connect to Analysis Services cubes:

    http://olappivottableextend.codeplex.com/wikipage?title=Search&referringTitle=Home

    It's an open source project, and I wrote the "cube search" code to be ignorant about whether it's running in Excel or not.

    I'm not clear where in Reporting Services you would like this search to occur. I suppose you could take the cube search code and use the .NET extensibility model for a custom data source in Reporting Services or something like that, but that would be quite a bit of work, and the user experience would be pretty slow searching every dimension for a particular member with a certain name. Try out my add-in and see if the performance and user experience would be similar to what you're looking for.


    http://artisconsulting.com/Blogs/GregGalloway

    • Proposed as answer by Elvis Long Tuesday, February 19, 2013 2:53 AM
    • Marked as answer by Elvis Long Monday, February 25, 2013 4:25 AM
    Monday, February 11, 2013 11:04 PM

All replies

  • Hi,

    Normally what i am doing to acheive this ... go into Datasource view press ctrl+F and put the attribute which you are going to find and it will bring you in the dimension XML file.

    I hope this helps you.

    Regards,

    Zaim Raza.

    Monday, February 11, 2013 3:13 AM
  • This is a feature of an Excel add-in I wrote which enhances PivotTables in Excel which connect to Analysis Services cubes:

    http://olappivottableextend.codeplex.com/wikipage?title=Search&referringTitle=Home

    It's an open source project, and I wrote the "cube search" code to be ignorant about whether it's running in Excel or not.

    I'm not clear where in Reporting Services you would like this search to occur. I suppose you could take the cube search code and use the .NET extensibility model for a custom data source in Reporting Services or something like that, but that would be quite a bit of work, and the user experience would be pretty slow searching every dimension for a particular member with a certain name. Try out my add-in and see if the performance and user experience would be similar to what you're looking for.


    http://artisconsulting.com/Blogs/GregGalloway

    • Proposed as answer by Elvis Long Tuesday, February 19, 2013 2:53 AM
    • Marked as answer by Elvis Long Monday, February 25, 2013 4:25 AM
    Monday, February 11, 2013 11:04 PM
  • Hi,

    This utility is very nice most of my clients are asking regarding the measures and attribute so i have to search in the document and to inform them that it's present in certain fact/dimension.

    I like this utility.

    Regards,

    Zaim Raza.

    Monday, February 11, 2013 11:10 PM