on 10-19-2010 11:06 AM
Hi Folks,
I am using some VBA code to run logic in BPC for Excel. When i try to click on VBA button, It's giving the below error.However when i am trying to execute same from server it is working fine. Accessing from BPC client only we are facing this problem.
Code have no issues. Is there any specific thing need to mentioned in client when we use VBA programming? Basically we used the VBA program to create the id's in BPC for Excel. So that it will automatically created on fly. Testing was fine interms of working in Server.
" Run-time error '429':Active X component can not create an object ."
Hi,
Are you trying to add a member into the dimension from excel? As you said that this has been already tested in the server and is working fine, I believe, you have taken care of everything.
Now, coming to the point, when you are adding a member in the membersheet, you need to process the dimension. This requires the admin rights. So, please check the task profile of the user ID, with which you are trying from your system. This user ID should be the primary admin.
Hope this helps.
Additionally, can you please elaborate on the steps on what you followed for adding a member from the excel directly?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
I am getting this same error just by opening BPC for Excel Interface and changing the Current View for any dimension. I've tried reinstalling Microsoft Office and the BPC Netweaver suite. Have you ever faced this error in this situation? I've also tried other computers from my peers but no errors appear.
Any help will be greatly appreciated.
Kind regards,
David
Hi,
I am getting the very same error after opening BPC for Excel Interface and changing the Current View for any dimension.
I tried unstall & installing the BPC Netweaver. We are using BPC 7.5 (vr Netweaver) & MS Office 2010 in Windows 7 OS. Other computers operate successfully without any issues.
Please advice.
Thanks & regards,
Manoj
. Make sure into IIS that your Osoft virtual directiry is using ASP.NET 2.0
2. Did you install AntiCross scriptuing library from Microsoft? (AntiXssLibraryV1.5Installer.msi)
If you installed after installation of BPC then you have to copy the AntiXss.dll from installation folder for ASP.NET 2 into C:\BPC\Websrvr\Web\bin
3. Make sure NT AUTHORITY\NETWORK SERVICE has the correct rights into windows\Temp folder.
Before performing the above steps. try to restart your pc and check. Thanks
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.