"Unspecified error" - Browsing dimension in Analysis Manager

Posted on 2005-05-12
Last Modified: 2013-12-03
"Unable to browse the dimension 'CountryDimension'. Unspecified error"

I have only one dimension added to the table. I have processed the dimension succesfully, but when I want to browse the data, I get the error above. The same thing happens (I can process first, but then error browsing), when I try to create other dimensions

best regards,

Question by:henrikatwork
    LVL 12

    Expert Comment


    You need to define hierarchies before you can browse the dimentions. The hierachies define the path of navigation in your multi-dimentional data sets.
    LVL 1

    Author Comment

    I have tried a minimalistic approach - a simple ordertable (I washed the data carefully, each line has it's own ID) and a country dimension (FK_CountryID in the order table), I processed the tree and inserted hierarchies - still it doesn't work!!!
    :( :( :(
    LVL 1

    Accepted Solution


    have you installed MS OLAP Service Pack 3a or 4 ? I saw this on some occasions with SP0.

    LVL 1

    Author Comment

    Downloading it now, I'll get back to you in a few hours

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now