Object Variable or With block Variable not set-not fr Excel, from BPC Admin

[Former Member]

Hello everyone,

Object Variable or With block Variable not set-not from Excel but from BPC Admin.

I searched the form and all posting/solutions talk about this error appearing from Excel. In my case it happens for BPC Admin - when I try to maintain dimension members. I tried uninstalling and re-installing BPC client few times, processed all dimensions and tried pretty much all solutions posted here. Nothing worked (in BPC Admin). If anybody who came across this issue and solved it,

can you please post the solution?

Thanks

Pals

[Former Member]

Hi,

Are you using office 2007?

Please try to install the primary assembly interop for Office 2007 from the below link:

https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F...

Hope this helps.

[Former Member]

Hi Pals,

Is your Admin client the same Support Pack as your server install?

Do you have any other versions installed on your machine?

Does this happen for all dimensions or just one particular dimension?

Try going into BW - tcode UJFS and delete the xml file for the dimensions that you have problems with.

Hope this helps

[Former Member]

Hi Sabine,

Thanks for your reply.

Is your Admin client the same Support Pack as your server install?

Recently there was an update to SP5 of NW 7.5 and it should be.

Do you have any other versions installed on your machine?

No other versions.

Does this happen for all dimensions or just one particular dimension?

All Dimensions.

Try going into BW - tcode UJFS and delete the xml file for the dimensions that you have problems with.

I tried this approach for one dimension. But the error still persists.

-Pals

[Former Member]

Hi ,

Can you please check table UJE_TEAM to see if there are any special characters maintained in table entries.

Ask your basis team to edit the table as they are authorized to do so. Thanks.

Regards,

Sanjeev

[Former Member]

Hi Pals,

Try clicking "refresh dimension members" in the admin client, for every dimension

Then try again

[Former Member]

Hello Everyone,

Thanks for all your possible solutions. Here is the solution in case if you come across,

"Object Variable or With block Variable not set" error from BPC Admin (not from Excel).

Did some analysis with Basis administrator and found that there was an installation of MS Office 2010 component (not the full version. not sure how it got there since I do not have MS Office 2010) along with MS Office 2007. So,

I un-installed MS Office 2010 component, MS Office 2007 and Planning and Consolidation client.

Re-booted the laptop.

Installed MS Office 2007 first. Re-booted.

Installed Planning and Consolidation client. Re-booted.

Started Planning and Consolidation Admin client. Clicked on Maintain Dimension members for a dimension. Dimension members displayed without any errors.

Tried update, insert and delete of dimension members, worked fine.

Thanks again All.

-Pals