Skip to Content
author's profile photo Former Member
Former Member

Error in Processing Dimension

Hi

I have a USER DEFINED DIMENSION , MATERIAL, which i am when trying to process the dimension from the Admin Console it is given me an error message

"The request falied with HHTP status 401: Unauthorized.

Cannot save member sheet to the server, do you want to save it to the local machine"

For all other dimenion,(along with other User Defined DimensionAlso) the Processing is Successful.

We are using customized SSIS Package to update & process the MATERIAL Dimension at the back end to the mbr table.

Can anybody throw some light on the same

Thanks & Regards

krish

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Apr 12, 2010 at 11:00 AM

    The problem it is related to your custom SSIS package.

    You said you are updating the mbr table but this doesn't means the excel sheet will be updated automatically.

    More than that you have to use standard BPC tasks to process the dimension into back end.

    If you didn't use these tasks then I can understand why you have these authentication issue.

    So I suggest to check the custom package and also I suggest first to do modify dimension and to see if you have the right properties and to save this dimension one more time.

    I suppose after that you will be able to process dimension but again I don't know if what you have into excel sheet it is the same with what you have ointo mbrtable.

    Regards

    Sorin Radulescu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 12, 2010 at 06:33 AM

    Hello,

    Please make sure u'r not open the excel file directly to the folder and if u open it please close and then re-open again dimension u want to process after that u can process like usual.

    hope helps..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2011 at 03:46 AM

    Thanks for the approach

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.